Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0000315 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | major | have not tried | 2008-05-15 14:42 | 2008-09-03 21:49 | |||
| Reporter | plujan | View Status | public | |||||
| Assigned To | cromero | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 5156 | ||||
| Projection | none | ETA | none | Target Version | 2.40 | |||
| OS | Windows | Database | PostgreSQL | Java version | don't know | |||
| OS Version | XPsp2 | Database version | 8.2.7 | Ant version | don't know | |||
| Product Version | 2.35 | SCM revision | mp4 Community | |||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0000315: AT235mp4 - On PostgreSQL, when I try to complete a Sales Order, I get an error | |||||||
| Description | With 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 Reproduce | as descripted | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0000474) cromero (reporter) 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 (reporter) 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 (reporter) 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 (reporter) 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 (manager) 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 (reporter) 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 (reporter) 2008-06-18 18:37 |
Once the bug 4047: Deprecate table DBA_ERRORLOG has been resolved (r5156). this bug is correctly fixed. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-05-15 14:42 | plujan | New Issue | |
| 2008-05-15 14:42 | plujan | Assigned To | => cromero |
| 2008-05-19 18:58 | cromero | Status | new => scheduled |
| 2008-06-09 18:05 | cromero | Note Added: 0000474 | |
| 2008-06-10 19:08 | svnbot | Checkin | |
| 2008-06-10 19:08 | svnbot | Note Added: 0000486 | |
| 2008-06-10 19:08 | svnbot | Status | scheduled => resolved |
| 2008-06-10 19:08 | svnbot | Resolution | open => fixed |
| 2008-06-10 19:08 | svnbot | svn_revision | => 4934 |
| 2008-06-11 11:21 | svnbot | Checkin | |
| 2008-06-11 11:21 | svnbot | Note Added: 0000496 | |
| 2008-06-11 11:21 | svnbot | svn_revision | 4934 => 4947 |
| 2008-06-11 12:43 | cromero | Fixed in Version | => 2.40alpha r3 |
| 2008-06-11 12:46 | cromero | Target Version | => 2.40 |
| 2008-06-17 18:38 | svnbot | Checkin | |
| 2008-06-17 18:38 | svnbot | Note Added: 0007811 | |
| 2008-06-17 18:38 | svnbot | svn_revision | 4947 => 5121 |
| 2008-06-18 13:42 | plujan | Status | resolved => new |
| 2008-06-18 13:42 | plujan | Resolution | fixed => open |
| 2008-06-18 13:42 | plujan | Note Added: 0007830 | |
| 2008-06-18 13:42 | plujan | Status | new => scheduled |
| 2008-06-18 14:22 | cromero | Note Added: 0007833 | |
| 2008-06-18 18:10 | cromero | Relationship added | depends on 0004037 |
| 2008-06-18 18:10 | cromero | Resolution | open => open |
| 2008-06-18 18:10 | cromero | Fixed in Version | 2.40alpha-r3 => |
| 2008-06-18 18:10 | cromero | svn_revision | 5121 => |
| 2008-06-18 18:11 | cromero | Relationship deleted | depends on 0004037 |
| 2008-06-18 18:11 | cromero | Relationship added | depends on 0004047 |
| 2008-06-18 18:37 | cromero | Status | scheduled => resolved |
| 2008-06-18 18:37 | cromero | svn_revision | => 5156 |
| 2008-06-18 18:37 | cromero | Resolution | open => fixed |
| 2008-06-18 18:37 | cromero | Note Added: 0007840 | |
| 2008-07-01 17:56 | anonymous | sf_bug_id | 0 => 2007873 |
| 2008-09-03 21:49 | psarobe | Regression testing | => No |
| 2008-09-03 21:49 | psarobe | Status | resolved => closed |
| 2009-04-21 11:13 | shuehner | Relationship added | related to 0008309 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |