0005612: Error when synchronizing POS Orders with ERP

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0005612

Openbravo ERP

Z. Others

public

2008-10-22 13:02

2008-10-27 10:20

Reporter

jtarbal

Assigned To

cromero

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

2.40

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

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.

Steps To Reproduce

Proposed Solution

Additional Information