0027500: Error on Oracle installation ORA-00911: invalid character

Openbravo Issue Tracking System - Modules

View Issue Details

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 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

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