Project:
View Revisions: Issue #26094 | [ All Revisions ] [ Back to Issue ] | ||
Summary | 0026094: Build failed having the m_product_category.description column defined as identifier | ||
Revision | 2014-03-27 08:14 by alostale | ||
Steps To Reproduce | -Define a template -Go to tables and columns window -find the m_product_category table- -ON the columns tab find the description column -check it as indevelopment. *Execute a compile.complete and the process fails with this error buildAD: [java] 0 [main] INFO org.openbravo.data.Sqlc - strFileProperties: /home/alostale/ws/pi-pg/openbravo/config/Openbravo.properties [java] 615 [main] INFO org.openbravo.data.Sqlc - javaDateFormat: dd-MM-yyyy [java] 633 [main] INFO org.openbravo.data.Sqlc - directory source: ../srcAD [java] 656 [main] INFO org.openbravo.data.Sqlc - directory destiny: /home/alostale/ws/pi-pg/openbravo/build/javasqlc/src [java] 682 [main] INFO org.openbravo.data.Sqlc - file termination: .xsql [java] 707 [main] INFO org.openbravo.data.Sqlc - file connection: /home/alostale/ws/pi-pg/openbravo/config/Openbravo.properties [java] 732 [main] INFO org.openbravo.data.Sqlc - Write TXT Files: false [java] 757 [main] INFO org.openbravo.data.Sqlc - QueryExecutionStrategy: traditional [java] 782 [main] INFO org.openbravo.data.Sqlc - Loading driver: org.postgresql.Driver [java] 807 [main] INFO org.openbravo.data.Sqlc - Driver loaded [java] 836 [main] INFO org.openbravo.data.Sqlc - connect made [java] 912 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/ProductCategory/Accounting_data.xsql processed [java] 991 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT (TO_CHAR(COALESCE(TO_CHAR((CASE WHEN tableTRL1.Name IS NULL THEN TO_CHAR(table1.Name) ELSE TO_CHAR(tableTRL1.Name) END)), '')) || ' - ' || TO_CHAR(COALESCE(TO_CHAR((CASE WHEN tableTRL1.Description IS NULL THEN TO_CHAR(table1.Description) ELSE TO_CHAR(tableTRL1.Description) END)), ''))) AS NAME FROM M_Product_Category left join (select M_Product_Category_ID, Name, Description from M_Product_Category) table1 on (M_Product_Category.M_Product_Category_ID = table1.M_Product_Category_ID) left join (select M_Product_Category_ID,AD_Language, Name from M_Product_Category_TRL) tableTRL1 on (table1.M_Product_Category_ID = tableTRL1.M_Product_Category_ID and tableTRL1.AD_Language = ?) left join (select M_Product_Category_ID,AD_Language, Description from M_Product_Category_TRL) tableTRL1 on (table1.M_Product_Category_ID = tableTRL1.M_Product_Category_ID and tableTRL1.AD_Language = ?) WHERE M_Product_Category.M_Product_Category_ID = ? [java] [java] org.postgresql.util.PSQLException: ERROR: table name "tabletrl1" specified more than once [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) [java] at org.openbravo.data.Sqlc.query(Sqlc.java:738) [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:558) [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(Sqlc.java:355) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:279) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:258) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:258) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:258) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:258) [java] at org.openbravo.data.Sqlc.main(Sqlc.java:204) |
||
Revision | 2014-03-26 19:00 by alostale | ||
Steps To Reproduce | -Define a template -Go to tables and columns window -find the m_product_category table- -ON the columns tab find the description column -check it as indevelopment. *Execute a compile.complete and the process fails |
Copyright © 2000 - 2009 MantisBT Group |