Notes |
|
(0070789)
|
hgbot
|
2014-10-08 04:31
|
|
|
|
(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
---
|
|
|
|
|