Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0000415 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2008-05-23 09:18 | 2008-07-01 17:56 | |||
| Reporter | jpabloae | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.40alpha-r3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 4487 | ||||
| Projection | none | ETA | none | Target Version | 2.40 | |||
| OS | Linux 64 bit | Database | Oracle | Java version | 1.5.0_15 | |||
| OS Version | Gentoo | Database version | 10.2.0.1 | Ant version | 1.7.0 | |||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0000415: After r4469 trunk compilation fails in GeneralAccountingReports_data.xsql | |||||||
| Description | After 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 Reproduce | 1. Update to the latest revision (currently 4485). 2. Run ant install.source . | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-05-23 09:18 | jpabloae | New Issue | |
| 2008-05-23 09:18 | jpabloae | Assigned To | => cromero |
| 2008-05-23 09:18 | jpabloae | OBNetwork customer | => N |
| 2008-05-23 11:36 | cromero | Status | new => scheduled |
| 2008-05-23 11:36 | cromero | Assigned To | cromero => eduardo_Argal |
| 2008-05-26 11:20 | eduardo_Argal | Status | scheduled => resolved |
| 2008-05-26 11:20 | eduardo_Argal | Fixed in Version | => trunk |
| 2008-05-26 11:20 | eduardo_Argal | svn_revision | => 4487 |
| 2008-05-26 11:20 | eduardo_Argal | Resolution | open => fixed |
| 2008-06-11 14:47 | cromero | Target Version | => 2.40 |
| 2008-06-11 14:50 | cromero | Fixed in Version | trunk => 2.40alpha r3 |
| 2008-06-19 11:27 | plujan | Status | resolved => closed |
| 2008-07-01 17:56 | anonymous | sf_bug_id | 0 => 2007887 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |