Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0027793 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | minor | have not tried | 2014-10-08 04:29 | 2014-10-08 20:20 | |||
| Reporter | szapata | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | RR14Q4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 29d11576b3af | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | malsasua | |||||||
| OBNetwork customer | No | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0027793: Modulescript FixDataIssue27425 fails sometimes in Oracle | |||||||
| Description | Modulescript FixDataIssue27425 fails sometimes in Oracle if more than 1000 invoices needs to be updated | |||||||
| Steps To Reproduce | NA | |||||||
| Proposed Solution | Replace IN by EXISTS | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
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 (viewer) 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 (viewer) 2014-10-08 20:20 |
verified |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |