Openbravo Issue Tracking System - Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0027500 | Modules | Invoices Register Book | public | 2014-08-28 18:11 | 2014-08-28 18:12 |
|
| Reporter | rafaroda | |
| Assigned To | jonalegriaesarte | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Regression date | |
| Regression introduced by commit | |
| Regression level | |
| Review Assigned To | |
| Support ticket | |
| OBNetwork customer | No |
| Regression introduced in release | |
|
| Summary | 0027500: Error on Oracle installation ORA-00911: invalid character |
| Description | Error on Oracle 10 module installation when executing module script ORA-00911: invalid character |
| Steps To Reproduce | Install last version of module on Oracle 10: seems that does not parse properly queries when executing modulescript Issue26091UpdateOperationCode.class: this modulescript was introduced when fixing issue 0026091
[java] 173967 ERROR - SQL error in query: UPDATE C_Invoice SET PROCESSED='N' WHERE C_Invoice_ID in (select ci.c_invoice_id from c_invoice ci left join C_InvoiceTax ct on ci.c_invoice_id=ct.c_invoice_id where ci.iscashvat='Y'); UPDATE C_InvoiceTax SET EM_OBIRB_OperationCode='Z' WHERE C_INVOICE_ID in (select ci.c_invoice_id from c_invoice ci left join C_InvoiceTax ct on ci.c_invoice_id=ct.c_invoice_id where ci.iscashvat='Y'); UPDATE C_Invoice SET PROCESSED='Y' WHERE C_Invoice_ID in (select ci.c_invoice_id from c_invoice ci left join C_InvoiceTax ct on ci.c_invoice_id=ct.c_invoice_id where ci.iscashvat='Y');Exception:java.sql.SQLSyntaxErrorException: ORA-00911: invalid character |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0026091 | | closed | Sandrahuguet | Localization Pack: Spain | The invoice register book must set the key "Z" for every single line of a purchase/sales invoice under CASH VAT regime. | | blocks | defect | 0027493 | | new | jonalegriaesarte | Modules | Compilation and execution errors in Oracle for some modules |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-08-28 18:11 | rafaroda | New Issue | |
| 2014-08-28 18:11 | rafaroda | Assigned To | => jonalegriaesarte |
| 2014-08-28 18:11 | rafaroda | OBNetwork customer | => No |
| 2014-08-28 18:11 | rafaroda | Relationship added | blocks 0027493 |
| 2014-08-28 18:12 | rafaroda | Relationship added | related to 0026091 |