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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027500
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Invoices Register Bookmajoralways2014-08-28 18:112014-08-28 18:12
ReporterrafarodaView Statuspublic 
Assigned Tojonalegriaesarte 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

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

DescriptionError on Oracle 10 module installation when executing module script ORA-00911: invalid character
Steps To ReproduceInstall 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0026091 closedSandrahuguet 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 newjonalegriaesarte Modules Compilation and execution errors in Oracle for some modules 

-  Notes
There are no notes attached to this issue.

- 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 Relationship added blocks 0027493
2014-08-28 18:12 rafaroda Relationship added related to 0026091

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker