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 | ||||||
| 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 | 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 | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0009756) psarobe (manager) 2008-10-27 10:20 |
This bug has been fixed because of 5473 although they are different ones |
|
Notes |
|
Issue History |
|||
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |