Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000315Openbravo ERP07. Sales managementpublic2008-05-15 14:422008-09-03 21:49
Reporterplujan 
Assigned Tocromero 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS10OS VersionXPsp2
Product Version2.35 
Target Version2.40Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0000315: AT235mp4 - On PostgreSQL, when I try to complete a Sales Order, I get an error
DescriptionWith demo data, I create a new Sales Order like this:
Order type: Warehouse order
Business Partner: Actassi ,Corporation
All other data as default, except Form of Payment: Shipment cash

Then I add a line:
Product: Corkscrew Pink
Quantity: 1
All other data as default.

When I try to complete that order, I get this error message:

Error:
invalid input syntax for type numeric: "22P02"
Steps To Reproduceas descripted
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0004047 closed cromero Deprecate table DBA_ERRORLOG 
related to defect 0008309 closed shuehner Error message not parsed in postgres. Sales order window 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-05-15 14:42plujanNew Issue
2008-05-15 14:42plujanAssigned To => cromero
2008-05-19 18:58cromeroStatusnew => scheduled
2008-06-09 18:05cromeroNote Added: 0000474
2008-06-10 19:08svnbotCheckin
2008-06-10 19:08svnbotNote Added: 0000486
2008-06-10 19:08svnbotStatusscheduled => resolved
2008-06-10 19:08svnbotResolutionopen => fixed
2008-06-10 19:08svnbotsvn_revision => 4934
2008-06-11 11:21svnbotCheckin
2008-06-11 11:21svnbotNote Added: 0000496
2008-06-11 11:21svnbotsvn_revision4934 => 4947
2008-06-11 12:43cromeroFixed in Version => 2.40alpha r3
2008-06-11 12:46cromeroTarget Version => 2.40
2008-06-17 18:38svnbotCheckin
2008-06-17 18:38svnbotNote Added: 0007811
2008-06-17 18:38svnbotsvn_revision4947 => 5121
2008-06-18 13:42plujanStatusresolved => new
2008-06-18 13:42plujanResolutionfixed => open
2008-06-18 13:42plujanNote Added: 0007830
2008-06-18 13:42plujanStatusnew => scheduled
2008-06-18 14:22cromeroNote Added: 0007833
2008-06-18 18:10cromeroRelationship addeddepends on 0004037
2008-06-18 18:10cromeroResolutionopen => open
2008-06-18 18:10cromeroFixed in Version2.40alpha-r3 =>
2008-06-18 18:10cromerosvn_revision5121 =>
2008-06-18 18:11cromeroRelationship deleteddepends on 0004037
2008-06-18 18:11cromeroRelationship addeddepends on 0004047
2008-06-18 18:37cromeroStatusscheduled => resolved
2008-06-18 18:37cromerosvn_revision => 5156
2008-06-18 18:37cromeroResolutionopen => fixed
2008-06-18 18:37cromeroNote Added: 0007840
2008-07-01 17:56anonymoussf_bug_id0 => 2007873
2008-09-03 21:49psarobeRegression testing => No
2008-09-03 21:49psarobeStatusresolved => closed
2009-04-21 11:13shuehnerRelationship addedrelated to 0008309

Notes
(0000474)
cromero   
2008-06-09 18:05   
This bugs applies both to Oracle and PostgreSQL.

The problem is that you are trying to complete an order and you have not enough stock.

The message shown is not accurate.
(0000486)
svnbot   
2008-06-10 19:08   
Repository: openbravo
Revision: 4934
Author: cromeroherrero
Date: 2008-06-10 19:08:21 +0200 (Tue, 10 Jun 2008)

Fixed bug 0000315 : AT235mp4 - On PostgreSQL, when I try to complete a Sales Order, I get an error
* Needed to raise/catch the error in the invokied functions
* Modified field CODE from number to varchar for PostgreSQL compatibility (alphanumeric exception codes)
* Added sequence for table DBA_ERRORLOG

---
U trunk/src-db/database/model/functions/A_ASSET_POST.xml
U trunk/src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml
U trunk/src-db/database/model/functions/C_INVOICE_CANCEL.xml
U trunk/src-db/database/model/functions/C_INVOICE_CREATE.xml
U trunk/src-db/database/model/functions/C_INVOICE_POST.xml
U trunk/src-db/database/model/functions/C_ORDER_POST1.xml
U trunk/src-db/database/model/functions/C_REMITTANCE_POST.xml
U trunk/src-db/database/model/functions/C_SETTLEMENT_POST.xml
U trunk/src-db/database/model/functions/MA_GLOBALUSE_DISTRIBUTE.xml
U trunk/src-db/database/model/functions/MA_MAINTENANCE_SCHEDULE.xml
U trunk/src-db/database/model/functions/MA_MAINT_ALL.xml
U trunk/src-db/database/model/functions/MA_MEASURE_TIME_EXPLODE.xml
U trunk/src-db/database/model/functions/MA_PC_CASE_CREATE.xml
U trunk/src-db/database/model/functions/MA_PRODUCTION_COST.xml
U trunk/src-db/database/model/functions/MA_STANDARD_COST.xml
U trunk/src-db/database/model/functions/MA_WORKREQUIREMENT_CLOSE.xml
U trunk/src-db/database/model/functions/MA_WORKREQUIREMENT_PROCESS.xml
U trunk/src-db/database/model/functions/MA_WRPHASE_CLOSE.xml
U trunk/src-db/database/model/functions/M_CHECK_STOCK.xml
U trunk/src-db/database/model/functions/M_INOUT_CANCEL.xml
U trunk/src-db/database/model/functions/M_INOUT_CREATE.xml
U trunk/src-db/database/model/functions/M_INOUT_POST.xml
U trunk/src-db/database/model/functions/M_UPDATE_PARETO_PRODUCT.xml
U trunk/src-db/database/model/tables/DBA_ERRORLOG.xml
U trunk/src-db/database/sampledata/AD_SEQUENCE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=4934&sc=1 [^]
(0000496)
svnbot   
2008-06-11 11:21   
Repository: openbravo
Revision: 4947
Author: cromeroherrero
Date: 2008-06-11 11:21:00 +0200 (Wed, 11 Jun 2008)

Fixed bug 0000315 : AT235mp4 - On PostgreSQL, when I try to complete a Sales Order, I get an error
* Improved error messages

---
U trunk/src-db/database/model/functions/C_ORDER_POST1.xml
U trunk/src-db/database/model/functions/M_INOUT_CREATE.xml
U trunk/src-db/database/model/functions/M_INOUT_POST.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=4947&sc=1 [^]
(0007811)
svnbot   
2008-06-17 18:38   
Repository: openbravo
Revision: 5121
Author: cromeroherrero
Date: 2008-06-17 18:38:10 +0200 (Tue, 17 Jun 2008)

Fixed bug 0000315 : AT235mp4 - On PostgreSQL, when I try to complete a Sales Order, I get an error
* Improved error messages

---
U trunk/src-db/database/model/functions/MA_PRODUCTION_COST.xml
U trunk/src-db/database/model/functions/MA_STANDARD_COST.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=5121&sc=1 [^]
(0007830)
plujan   
2008-06-18 13:42   
I tried again on 2.40r3 and I still have an incorrect message, now is "para la columna «dba_errorlog_id» viola la restricción not null"
(0007833)
cromero   
2008-06-18 14:22   
It is fixed in the trunk and not in the release since I have inserted a new sequence in the sampledata:

trunk/src-db/database/sampledata/AD_SEQUENCE.xml

and it has not been inserted in the sampledata for the demo.
(0007840)
cromero   
2008-06-18 18:37   
Once the bug 4047: Deprecate table DBA_ERRORLOG has been resolved (r5156). this bug is correctly fixed.