0005411: Region_data.xsql does not compile - Openbravo Issue Tracking System

[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

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

Notes
(0009361) svnbot (reporter) 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 [^]

Relationships [ Relation Graph ] [ Dependency Graph ]