Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0027793
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSminorhave not tried2014-10-08 04:292014-10-08 20:20
ReporterszapataView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in VersionRR14Q4
StatusclosedFix in branchFixed in SCM revision29d11576b3af
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomalsasua
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027793: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0027425 closedOrekaria Cash up invoices are created as not paid since Q2.2 

-  Notes
(0070789)
hgbot (developer)
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 (manager)
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 (developer)
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 (developer)
2014-10-08 20:20

verified

- Issue History
Date Modified Username Field Change
2014-10-08 04:29 szapata New Issue
2014-10-08 04:29 szapata Assigned To => marvintm
2014-10-08 04:29 szapata Triggers an Emergency Pack => No
2014-10-08 04:31 hgbot Checkin
2014-10-08 04:31 hgbot Note Added: 0070789
2014-10-08 04:31 hgbot Status new => resolved
2014-10-08 04:31 hgbot Resolution open => fixed
2014-10-08 04:31 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/fde8956470b953313a75a3ce184b805af09ad492 [^]
2014-10-08 06:55 mtaal Note Added: 0070791
2014-10-08 12:24 mtaal Relationship added related to 0027425
2014-10-08 19:25 hgbot Checkin
2014-10-08 19:25 hgbot Note Added: 0070824
2014-10-08 19:25 hgbot Fixed in SCM revision http://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:20 malsasua Review Assigned To => malsasua
2014-10-08 20:20 malsasua Note Added: 0070825
2014-10-08 20:20 malsasua Status resolved => closed
2014-10-08 20:20 malsasua Fixed in Version => RR14Q4


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker