Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000415Openbravo ERP09. Financial managementpublic2008-05-23 09:182008-07-01 17:56
Reporterjpabloae 
Assigned Toeduardo_Argal 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionGentoo
Product Version 
Target Version2.40Fixed in Version2.40alpha-r3 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0000415: After r4469 trunk compilation fails in GeneralAccountingReports_data.xsql
DescriptionAfter commit r4469 trunk doesn't compile, both under PostgreSQL and Oracle. It fails with this error:
  [java] 8877 [main] INFO org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql processed
     [java] 9340 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java] SELECT COALESCE(SUM(AMTACCTCR-AMTACCTDR), 0) AS NAME
     [java] FROM FACT_ACCT, C_PERIOD, C_YEAR, (SELECT C_ELEMENTVALUE_ID
     [java] FROM C_ELEMENTVALUE
     [java] WHERE C_ELEMENTVALUE.ACCOUNTTYPE = 'E') AA
     [java] WHERE FACT_ACCT.C_PERIOD_ID = C_PERIOD.C_PERIOD_ID
     [java] AND C_PERIOD.C_YEAR_ID = C_YEAR.C_YEAR_ID
     [java] AND FACT_ACCT.ACCOUNT_ID = AA.C_ELEMENTVALUE_ID
     [java] AND FACT_ACCT.FACTACCTTYPE <> 'R'
     [java] AND 1=1
     [java] AND C_YEAR.YEAR = ?
     [java] AND FACT_ACCT.AD_ORG_ID IN ('1')
     [java] Exception:java.sql.SQLException: Invalid column index
     [java] java.sql.SQLException: Invalid column index
     [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
     [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
     [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
     [java] at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4194)
     [java] at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4186)
     [java] at org.openbravo.data.Sqlc.query(Unknown Source)
     [java] at org.openbravo.data.Sqlc.endElement(Unknown Source)
     [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
     [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
     [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
     [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
     [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
     [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
     [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
     [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
     [java] at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
     [java] at org.openbravo.data.Sqlc.main(Unknown Source)
Steps To Reproduce1. Update to the latest revision (currently 4485).
2. Run ant install.source .
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-05-23 09:18jpabloaeNew Issue
2008-05-23 09:18jpabloaeAssigned To => cromero
2008-05-23 09:18jpabloaeOBNetwork customer => N
2008-05-23 11:36cromeroStatusnew => scheduled
2008-05-23 11:36cromeroAssigned Tocromero => eduardo_Argal
2008-05-26 11:20eduardo_ArgalStatusscheduled => resolved
2008-05-26 11:20eduardo_ArgalFixed in Version => trunk
2008-05-26 11:20eduardo_Argalsvn_revision => 4487
2008-05-26 11:20eduardo_ArgalResolutionopen => fixed
2008-06-11 14:47cromeroTarget Version => 2.40
2008-06-11 14:50cromeroFixed in Versiontrunk => 2.40alpha r3
2008-06-19 11:27plujanStatusresolved => closed
2008-07-01 17:56anonymoussf_bug_id0 => 2007887

There are no notes attached to this issue.