Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027793Retail ModulesWeb POSpublic2014-10-08 04:292014-10-08 20:20
Reporterszapata 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR14Q4 
Merge Request Status
Review Assigned Tomalsasua
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027793: Modulescript FixDataIssue27425 fails sometimes in Oracle
DescriptionModulescript FixDataIssue27425 fails sometimes in Oracle if more than 1000 invoices needs to be updated
Steps To ReproduceNA
Proposed SolutionReplace IN by EXISTS
Additional Information
TagsNo tags attached.
Relationships
related to defect 0027425 closed Orekaria Cash up invoices are created as not paid since Q2.2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-10-08 04:29szapataNew Issue
2014-10-08 04:29szapataAssigned To => marvintm
2014-10-08 04:29szapataOBNetwork customer => No
2014-10-08 04:29szapataTriggers an Emergency Pack => No
2014-10-08 04:31hgbotCheckin
2014-10-08 04:31hgbotNote Added: 0070789
2014-10-08 04:31hgbotStatusnew => resolved
2014-10-08 04:31hgbotResolutionopen => fixed
2014-10-08 04:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/fde8956470b953313a75a3ce184b805af09ad492 [^]
2014-10-08 06:55mtaalNote Added: 0070791
2014-10-08 12:24mtaalRelationship addedrelated to 0027425
2014-10-08 19:25hgbotCheckin
2014-10-08 19:25hgbotNote Added: 0070824
2014-10-08 19:25hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/fde8956470b953313a75a3ce184b805af09ad492 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/29d11576b3af9c22f83be8fecc0256dba7075e62 [^]
2014-10-08 20:20malsasuaReview Assigned To => malsasua
2014-10-08 20:20malsasuaNote Added: 0070825
2014-10-08 20:20malsasuaStatusresolved => closed
2014-10-08 20:20malsasuaFixed in Version => RR14Q4

Notes
(0070789)
hgbot   
2014-10-08 04:31   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: fde8956470b953313a75a3ce184b805af09ad492
Author: Salvador Zapata <salvador.zapata <at> gmail.com>
Date: Tue Oct 07 23:30:06 2014 -0300
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/fde8956470b953313a75a3ce184b805af09ad492 [^]

Fixed issue 27793: replaced IN by EXISTS

---
M build/classes/org/openbravo/retail/posterminal/modulescript/FixDataIssue27425Data.class
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/FixDataIssue27425_Data.xsql
---
(0070791)
mtaal   
2014-10-08 06:55   
Original error message:
 [java] 39775 INFO - Executing moduleScript: org.openbravo.retail.posterminal.modulescript.FixDataIssue27425
     [java] Execution of moduleScript org.openbravo.retail.posterminal.modulescript.FixDataIssue27425failed.
     [java] at org.openbravo.modulescript.ModuleScriptHandler.execute(ModuleScriptHandler.java:68)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:175)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
     [java] Exception in thread "main" Execution of moduleScript org.openbravo.retail.posterminal.modulescript.FixDataIssue27425failed.
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:250)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
     [java] Caused by: Execution of moduleScript org.openbravo.retail.posterminal.modulescript.FixDataIssue27425failed.
     [java] at org.openbravo.modulescript.ModuleScriptHandler.execute(ModuleScriptHandler.java:68)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:175)
     [java] ... 2 more
     [java] 39990 ERROR - SQL error in query: UPDATE fin_payment_schedule AS a SET paidamt = amount WHERE a.c_invoice_id IN ( SELECT c_invoice.c_invoice_id FROM c_invoice INNER JOIN c_invoiceline ON c_invoice.c_invoice_id = c_invoiceline.c_invoice_id LEFT JOIN fin_payment_schedule ON c_invoice.c_invoice_id = fin_payment_schedule.c_invoice_id INNER JOIN c_orderline ON c_invoiceline.c_orderline_id = c_orderline.c_orderline_id INNER JOIN c_order ON c_orderline.c_order_id = c_order.c_order_id WHERE c_order.em_obpos_app_cashup_id IS NOT null AND fin_payment_schedule.fin_payment_schedule_id IS NOT NULL AND c_invoice.ispaid = 'N' )Exception:java.sql.SQLSyntaxErrorException: ORA-00971: missing SET keyword
     [java]
     [java] 39994 ERROR - Error executing moduleScript org.openbravo.retail.posterminal.modulescript.FixDataIssue27425: @CODE=971@ORA-00971: missing SET keyword
     [java]
     [java] 39995 ERROR - Error executing moduleScript: org.openbravo.retail.posterminal.modulescript.FixDataIssue27425
     [java] java.lang.reflect.InvocationTargetException
     [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
     [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [java] at java.lang.reflect.Method.invoke(Method.java:622)
     [java] at org.openbravo.modulescript.ModuleScriptHandler.callExecute(ModuleScriptHandler.java:76)
     [java] at org.openbravo.modulescript.ModuleScriptHandler.execute(ModuleScriptHandler.java:64)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:175)
     [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
     [java] Caused by: Execution of moduleScript org.openbravo.retail.posterminal.modulescript.FixDataIssue27425failed.
     [java] at org.openbravo.modulescript.ModuleScript.handleError(ModuleScript.java:69)
     [java] at org.openbravo.retail.posterminal.modulescript.FixDataIssue27425.execute(FixDataIssue27425.java:44)
     [java] ... 9 more
(0070824)
hgbot   
2014-10-08 19:25   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 29d11576b3af9c22f83be8fecc0256dba7075e62
Author: Salvador Zapata <salvador.zapata <at> gmail.com>
Date: Wed Oct 08 13:37:35 2014 -0300
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/29d11576b3af9c22f83be8fecc0256dba7075e62 [^]

Fixed issue 27793: changed alias to be compatible with oracle and pg

---
M build/classes/org/openbravo/retail/posterminal/modulescript/FixDataIssue27425Data.class
M src-util/modulescript/src/org/openbravo/retail/posterminal/modulescript/FixDataIssue27425_Data.xsql
---
(0070825)
malsasua   
2014-10-08 20:20   
verified