Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0005612 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] Z. Others | major | always | 2008-10-22 13:02 | 2008-10-27 10:20 | |||
Reporter | jtarbal | View Status | public | |||||
Assigned To | cromero | |||||||
Priority | normal | Resolution | duplicate | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 2.40 | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0005612: Error when synchronizing POS Orders with ERP | |||||||
Description | When synchronizing the Openbravo POS (v2.20) sales orders with the Openbravo ERP (v2.40), no sales orders are imported to OB ERP, although the POS shows a message saying that the imoprtation has been done successfully. Looking to the OB ERP logs the error happens when trying to insert data in I_ORDER (ORA-01810). Debuging the error, I found where it is exactly: In ExternalSalesImpl.java in line 417 the date format to be used in the insert is defined. The problem is that the date format is taken from java, that is: dd-MM-yyyy HH:mm:ss. This format is used in the XSQL when doing the insert. In Oracle, MM and mm are the same thing, so an error 01810 is thrown. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
||||||||
|
![]() |
|
(0009756) psarobe (viewer) 2008-10-27 10:20 |
This bug has been fixed because of 5473 although they are different ones |
![]() |
|||
Date Modified | Username | Field | Change |
2008-10-22 13:02 | jtarbal | New Issue | |
2008-10-22 13:02 | jtarbal | Assigned To | => cromero |
2008-10-22 13:02 | jtarbal | sf_bug_id | 0 => 2186574 |
2008-10-27 10:19 | psarobe | Regression testing | => No |
2008-10-27 10:20 | psarobe | Relationship added | duplicate of 0005473 |
2008-10-27 10:20 | psarobe | Status | new => closed |
2008-10-27 10:20 | psarobe | Note Added: 0009756 | |
2008-10-27 10:20 | psarobe | Duplicate ID | 0 => 5473 |
2008-10-27 10:20 | psarobe | Resolution | open => duplicate |
Copyright © 2000 - 2009 MantisBT Group |