View source | Discuss this page | Page history | Printable version   

Release Notes/Issue31959


Who is affected

Bulbgraph.png   If you have any doubts, please contact Openbravo support.

You are affected by issue 31959 in case all of these 3 conditions are true:

Warn-icon.png   When updating to any higher version (PR15Q4.2 or superior) the issue is not reproducible anymore.

But any data that might have been incorrectly generated will not be automatically fixed.

How it affects

This issue causes incorrect reads from database of date and date time values. It mainly affects Openbravo's data references, which has been detected to be read with one day of difference compared with its actual stored value.

Affected flows

This problem can, potentially, affect to any process/report using 2.50 (SQLC technology).

Below is the list of known affected processes but there might be cases that we did not manage to detect. If you think you have some area of the application that is affected, please contact Openbravo Support.

Accounting process

As reported in 31959, accounting process is highly affected by creating accounting records in a previous day that the one they should be in.

You can check whether there are incorrect records by running this script in database. Note after executing it, you should remove the created function by running drop function getAcctDateMismatch();.

The output of this script is the number of records per table and client/organization with incorrect dates.

If there is any affected record, it is possible to recalculate the accounting by resetting it and re-scheduling the Accounting Process again.

Technical details

The root cause is a bug in PostgreSQL JDBC library (version 9.4.1201 was included in Openbravo PR15Q4) affecting binary processing of date formats, see PR#387 and PR#376.

In Openbravo it affects processes and reports implemented with SQLC technology. It has not been possible to reproduce it for processes using DAL. It does not affect PL/SQL processes (functions nor triggers).

Retrieved from ""

This page has been accessed 1,719 times. This page was last modified on 21 January 2016, at 15:55. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.