Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0005411 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] Z. Others | critical | always | 2008-10-04 11:06 | 2008-11-25 22:22 | |||
Reporter | jpabloae | View Status | public | |||||
Assigned To | cromero | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | 8239 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Linux 64 bit | Database | Any | Java version | 1.5.0_16 | |||
OS Version | Gentoo - 2.6.24 | Database version | 10.2.0.4 | Ant version | 1.7.0 | |||
Product Version | pi | SCM revision | 8232 | |||||
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 | 0005411: Region_data.xsql does not compile | |||||||
Description | This generated xsql file does not compile and it is not possible to build the trunk. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ![]() [java] 14962 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/CountryRegionandCity/Region_data.xsql processed [java] 15003 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: [java] SELECT C_Region.AD_Client_ID, [java] (CASE WHEN C_Region.AD_Client_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table1.Name), ''))),'') ) END) AS AD_Client_IDR, [java] C_Region.AD_Org_ID, [java] (CASE WHEN C_Region.AD_Org_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table2.Name), ''))),'') ) END) AS AD_Org_IDR, [java] C_Region.C_Country_ID, [java] (CASE WHEN C_Region.C_Country_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR((CASE WHEN tableTRL3.Name IS NULL THEN TO_CHAR(table3.Name) ELSE TO_CHAR(tableTRL3.Name) END)), ''))),'') ) END) AS C_Country_IDR, [java] C_Region.Name, [java] C_Region.Description, [java] COALESCE(C_Region.IsActive, 'N') AS IsActive, [java] COALESCE(C_Region.IsDefault, 'N') AS IsDefault, [java] C_Region.Value, [java] C_Region.C_Nation_ID, [java] C_Region.C_Region_ID, [java] [java] '' AS TR_BGCOLOR, '' as total_count, [java] C_Region.Created, [java] C_Region.CreatedBy, [java] C_Region.Updated, [java] C_Region.UpdatedBy, ? AS LANGUAGE, '' AS AD_USER_CLIENT, '' AS AD_ORG_CLIENT [java] FROM C_Region left join (select AD_Client_ID, Name from AD_Client) table1 on (C_Region.AD_Client_ID = table1.AD_Client_ID) left join (select AD_Org_ID, Name from AD_Org) table2 on (C_Region.AD_Org_ID = table2.AD_Org_ID) left join (select C_Country_ID, Name from C_Country) table3 on (C_Region.C_Country_ID = table3.C_Country_ID) left join (select C_Country_ID,AD_Language, Name from C_Country_TRL) tableTRL3 on (table3.C_Country_ID = tableTRL3.C_Country_ID and tableTRL3.AD_Language = ?) [java] java.sql.SQLException: ORA-00904: "C_REGION"."C_NATION_ID": invalid identifier [java] WHERE 2=2 [java] [java] AND 1=1 [java] AND C_Region.AD_Client_ID IN ('1') [java] AND C_Region.AD_Org_ID IN ('1') [java] AND C_Region.C_Country_ID = ? [java] ORDER BY 1, 1 [java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] Exception:java.sql.SQLException: ORA-00904: "C_REGION"."C_NATION_ID": invalid identifier [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329) [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) [java] 15020 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: statement handle not executed [java] 15020 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: statement handle not executed [java] 15021 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: statement handle not executed [java] java.sql.SQLException: statement handle not executed [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.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:720) [java] at oracle.jdbc.driver.OracleStatement.getNumberOfColumns(OracleStatement.java:1702) [java] at oracle.jdbc.driver.OracleResultSetMetaData.getValidColumnIndex(OracleResultSetMetaData.java:142) [java] at oracle.jdbc.driver.OracleResultSetMetaData.getColumnType(OracleResultSetMetaData.java:354) [java] at org.openbravo.data.Sqlc.printKeySequenceSql(Unknown Source) [java] at org.openbravo.data.Sqlc.printFunctionSql(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) [java] 15024 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: statement handle not executed [java] java.sql.SQLException: statement handle not executed [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.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:720) [java] at oracle.jdbc.driver.OracleStatement.getNumberOfColumns(OracleStatement.java:1702) [java] at oracle.jdbc.driver.OracleResultSetMetaData.getValidColumnIndex(OracleResultSetMetaData.java:142) [java] at oracle.jdbc.driver.OracleResultSetMetaData.getColumnType(OracleResultSetMetaData.java:354) [java] at org.openbravo.data.Sqlc.printFunctionSql(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) [java] 15031 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: [java] SELECT C_Region.AD_Client_ID, [java] (CASE WHEN C_Region.AD_Client_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table1.Name), ''))),'') ) END) AS AD_Client_IDR, [java] C_Region.AD_Org_ID, [java] (CASE WHEN C_Region.AD_Org_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table2.Name), ''))),'') ) END) AS AD_Org_IDR, [java] C_Region.C_Country_ID, [java] (CASE WHEN C_Region.C_Country_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR((CASE WHEN tableTRL3.Name IS NULL THEN TO_CHAR(table3.Name) ELSE TO_CHAR(tableTRL3.Name) END)), ''))),'') ) END) AS C_Country_IDR, [java] C_Region.Name, [java] C_Region.Description, [java] COALESCE(C_Region.IsActive, 'N') AS IsActive, [java] COALESCE(C_Region.IsDefault, 'N') AS IsDefault, [java] C_Region.Value, [java] C_Region.C_Nation_ID, [java] C_Region.C_Region_ID, [java] [java] C_Region.Created, [java] C_Region.CreatedBy, [java] C_Region.Updated, [java] C_Region.UpdatedBy, ? AS LANGUAGE [java] FROM C_Region left join (select AD_Client_ID, Name from AD_Client) table1 on (C_Region.AD_Client_ID = table1.AD_Client_ID) left join (select AD_Org_ID, Name from AD_Org) table2 on (C_Region.AD_Org_ID = table2.AD_Org_ID) left join (select C_Country_ID, Name from C_Country) table3 on (C_Region.C_Country_ID = table3.C_Country_ID) left join (select C_Country_ID,AD_Language, Name from C_Country_TRL) tableTRL3 on (table3.C_Country_ID = tableTRL3.C_Country_ID and tableTRL3.AD_Language = ?) [java] WHERE 2=2 [java] [java] AND 1=1 [java] AND C_Region.C_Region_ID = ? [java] AND C_Region.AD_Client_ID IN ('1') [java] AND C_Region.AD_Org_ID IN ('1') [java] Exception:java.sql.SQLException: ORA-00904: "C_REGION"."C_NATION_ID": invalid identifier [java] [java] java.sql.SQLException: ORA-00904: "C_REGION"."C_NATION_ID": invalid identifier [java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329) [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) [java] 15036 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: statement handle not executed [java] java.sql.SQLException: statement handle not executed [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.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:720) [java] at oracle.jdbc.driver.OracleStatement.getNumberOfColumns(OracleStatement.java:1702) [java] at oracle.jdbc.driver.OracleResultSetMetaData.getValidColumnIndex(OracleResultSetMetaData.java:142) [java] at oracle.jdbc.driver.OracleResultSetMetaData.getColumnType(OracleResultSetMetaData.java:354) [java] at org.openbravo.data.Sqlc.printKeySequenceSql(Unknown Source) [java] at org.openbravo.data.Sqlc.printFunctionSql(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) [java] 15040 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: statement handle not executed [java] java.sql.SQLException: statement handle not executed [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.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:720) [java] at oracle.jdbc.driver.OracleStatement.getNumberOfColumns(OracleStatement.java:1702) [java] at oracle.jdbc.driver.OracleResultSetMetaData.getValidColumnIndex(OracleResultSetMetaData.java:142) [java] at oracle.jdbc.driver.OracleResultSetMetaData.getColumnType(OracleResultSetMetaData.java:354) [java] at org.openbravo.data.Sqlc.printFunctionSql(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) [java] 15043 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: statement handle not executed | |||||||
![]() |
|
![]() |
|
(0009361) svnbot (viewer) 2008-10-05 22:08 |
Repository: openbravo Revision: 8239 Author: eduardoargal Date: 2008-10-05 22:08:12 +0200 (Sun, 05 Oct 2008) Fixes bug 0005411: Region_data.xsql does not compile --- U trunk/src-db/database/sourcedata/AD_COLUMN.xml U trunk/src-db/database/sourcedata/AD_FIELD.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=8239&sc=1 [^] |
![]() |
|||
Date Modified | Username | Field | Change |
2008-10-04 11:06 | jpabloae | New Issue | |
2008-10-04 11:06 | jpabloae | Assigned To | => cromero |
2008-10-04 11:06 | jpabloae | sf_bug_id | 0 => 2146047 |
2008-10-04 11:06 | jpabloae | OBNetwork customer | => No |
2008-10-04 11:06 | jpabloae | Regression testing | => No |
2008-10-04 11:22 | jpabloae | File Added: error.txt | |
2008-10-05 22:08 | svnbot | Checkin | |
2008-10-05 22:08 | svnbot | Note Added: 0009361 | |
2008-10-05 22:08 | svnbot | Status | new => resolved |
2008-10-05 22:08 | svnbot | Resolution | open => fixed |
2008-10-05 22:08 | svnbot | svn_revision | => 8239 |
2008-11-25 22:22 | psarobe | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |