Openbravo Issue Tracking System - Retail Modules
View Issue Details
0047979Retail ModulesWeb POSpublic2021-11-03 20:192021-11-24 07:41
lbressan 
ranjith_qualiantech_com 
highmajoralways
closedduplicate 
5
RR19Q4 
 
marvintm
2021-11-22
No
0047979: EWI: Error in OrderLoader: org.hibernate.exception.DataException: could not execute batch
This is a recurring EWI that we have been noticing for a few weeks in DKT Italy environments (PROD - PRODUNIT - PROD2). We had a chat about it with Antonio Moreno and he is already aware of this problem.
This is a recurring EWI that we have been noticing for a few weeks in DKT Italy environments (PROD - PRODUNIT - PROD2). We had a chat about it with Antonio Moreno and he is already aware of this problem.
Attached is a JSON as an example of the EWI in question.
-
No tags attached.
related to defect 0047612 closed ranjith_qualiantech_com Length of referenceZnumber field needs to be decreased to maximum int chars in the user interface 
txt ewijson.txt (57,680) 2021-11-03 20:19
https://issues.openbravo.com/file_download.php?file_id=16328&type=bug
txt stacktrace_47979.txt (8,371) 2021-11-08 20:05
https://issues.openbravo.com/file_download.php?file_id=16334&type=bug
Issue History
2021-11-03 20:19lbressanNew Issue
2021-11-03 20:19lbressanAssigned To => Retail
2021-11-03 20:19lbressanFile Added: ewijson.txt
2021-11-03 20:19lbressanRegression date => 2021-11-22
2021-11-03 20:19lbressanTriggers an Emergency Pack => No
2021-11-08 20:05lbressanFile Added: stacktrace_47979.txt
2021-11-24 06:39ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2021-11-24 07:04ranjith_qualiantech_comRelationship addedrelated to 0047612
2021-11-24 07:41marvintmReview Assigned To => marvintm
2021-11-24 07:41marvintmNote Added: 0133316
2021-11-24 07:41marvintmStatusnew => closed
2021-11-24 07:41marvintmResolutionopen => duplicate

Notes
(0133316)
marvintm   
2021-11-24 07:41   
It seems this problem would be prevented by applying the fix for issue:

https://issues.openbravo.com/view.php?id=47612 [^]

As the specified JSON has the property EM_Obrtser_Refznumber set to 660702312001. This number has length 12, and the column only accepts 10. With the fix for the mentioned issue, the user can no longer specify such a long value, and the problem should no longer happen.