rendered paste bodybuildAD:
[java] 0 [main] INFO org.openbravo.data.Sqlc - strFileProperties: /opt/AppsConstruccion/config/Openbravo.properties
[java] 1 [main] INFO org.openbravo.data.Sqlc - javaDateFormat: dd-MM-yyyy
[java] 2 [main] INFO org.openbravo.data.Sqlc - directory source: ../srcAD
[java] 2 [main] INFO org.openbravo.data.Sqlc - directory destiny: /opt/AppsConstruccion/build/javasqlc/src
[java] 2 [main] INFO org.openbravo.data.Sqlc - file termination: .xsql
[java] 2 [main] INFO org.openbravo.data.Sqlc - file connection: /opt/AppsConstruccion/config/dbCon5.xml
[java] 2 [main] INFO org.openbravo.data.Sqlc - Write TXT Files: false
[java] 13 [main] INFO org.openbravo.data.Sqlc - Loading driver: oracle.jdbc.OracleDriver
[java] 29 [main] INFO org.openbravo.data.Sqlc - Driver loaded
[java] 231 [main] INFO org.openbravo.data.Sqlc - connect made
[java] 250 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/MultiphaseProject/ProjectTask_data.xsql processed
[java] 458 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/MultiphaseProject/ProjectPhase_data.xsql processed
[java] 495 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/MultiphaseProject/Project_data.xsql processed
[java] 574 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/ProjectType/StandardTask_data.xsql processed
[java] 597 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/ProjectType/ProjectType_data.xsql processed
[java] 610 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/ProjectType/StandardPhase_data.xsql processed
[java] 632 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/WithoutProject/WithoutProject_data.xsql processed
[java] 662 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/ConstructionProject/ConstructionSite_data.xsql processed
[java] 794 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
[java] SELECT C_Project.VC_Certificationpercent ,
[java] C_Project.AD_Client_ID,
[java] (CASE WHEN C_Project.AD_Client_ID IS NULL THEN '' ELSE (TO_CHAR(table1.Name) ) END) AS AD_Client_IDR,
[java] C_Project.AD_Org_ID,
[java] (CASE WHEN C_Project.AD_Org_ID IS NULL THEN '' ELSE (TO_CHAR(table2.Name) ) END) AS AD_Org_IDR,
[java] C_Project.Value,
[java] C_Project.Name,
[java] COALESCE(C_Project.IsActive, 'N') AS IsActive,
[java] C_Project.Description,
[java] C_Project.Note,
[java] C_Project.Projectstatus,
[java] (CASE WHEN C_Project.Projectstatus IS NULL THEN '' ELSE ( TO_CHAR(list1.name) ) END) AS ProjectstatusR,
[java] java.sql.SQLException: ORA-00904: "C_PROJECT"."VC_CERTIFICATIONPERCENT": identificador no válido
[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] C_Project.Projectphase,
[java] (CASE WHEN C_Project.Projectphase IS NULL THEN '' ELSE ( TO_CHAR(list2.name) ) END) AS ProjectphaseR,
[java] C_Project.Projectkind,
[java] (CASE WHEN C_Project.Projectkind IS NULL THEN '' ELSE ( TO_CHAR(list3.name) ) END) AS ProjectkindR,
[java] C_Project.Publicprivate,
[java] (CASE WHEN C_Project.Publicprivate IS NULL THEN '' ELSE ( TO_CHAR(list4.name) ) END) AS PublicprivateR,
[java] C_Project.C_Location_ID,
[java] (CASE WHEN C_Project.C_Location_ID IS NULL THEN '' ELSE (TO_CHAR(table3.Address1) || ' - ' || TO_CHAR(table3.Address2) || ' - ' || TO_CHAR(table3.Postal) || ' - ' || TO_CHAR(table3.City) || ' - ' || TO_CHAR(table4.Name) || ' - ' || TO_CHAR((CASE WHEN tableTRL5.Name IS NULL THEN TO_CHAR(table5.Name) ELSE TO_CHAR(tableTRL5.Name) END)) ) END) AS C_Location_IDR,
[java] C_Project.SalesRep_ID,
[java] (CASE WHEN C_Project.SalesRep_ID IS NULL THEN '' ELSE ( TO_CHAR(table6.Name) ) END) AS SalesRep_IDR,
[java] C_Project.C_BPartner_ID,
[java] (CASE WHEN C_Project.C_BPartner_ID IS NULL THEN '' ELSE (TO_CHAR(table7.Name) ) END) AS C_BPartner_IDR,
[java] C_Project.C_BPartner_Location_ID,
[java] (CASE WHEN C_Project.C_BPartner_Location_ID IS NULL THEN '' ELSE (TO_CHAR(table8.Name) ) END) AS C_BPartner_Location_IDR,
[java] C_Project.AD_User_ID,
[java] (CASE WHEN C_Project.AD_User_ID IS NULL THEN '' ELSE (TO_CHAR(table9.Name) ) END) AS AD_User_IDR,
[java] C_Project.BillTo_ID,
[java] (CASE WHEN C_Project.BillTo_ID IS NULL THEN '' ELSE ( TO_CHAR(table10.Name) ) END) AS BillTo_IDR,
[java] COALESCE(C_Project.Invoice_ToProject, 'N') AS Invoice_ToProject,
[java] C_Project.M_PriceList_ID,
[java] (CASE WHEN C_Project.M_PriceList_ID IS NULL THEN '' ELSE (TO_CHAR(table11.Name) ) END) AS M_PriceList_IDR,
[java] C_Project.C_Currency_ID,
[java] (CASE WHEN C_Project.C_Currency_ID IS NULL THEN '' ELSE (TO_CHAR(table12.ISO_Code) ) END) AS C_Currency_IDR,
[java] C_Project.AccountNo,
[java] C_Project.Document_Copies,
[java] C_Project.PaymentRule,
[java] (CASE WHEN C_Project.PaymentRule IS NULL THEN '' ELSE ( TO_CHAR(list5.name) ) END) AS PaymentRuleR,
[java] C_Project.C_PaymentTerm_ID,
[java] (CASE WHEN C_Project.C_PaymentTerm_ID IS NULL THEN '' ELSE (TO_CHAR((CASE WHEN tableTRL13.Name IS NULL THEN TO_CHAR(table13.Name) ELSE TO_CHAR(tableTRL13.Name) END)) ) END) AS C_PaymentTerm_IDR,
[java] C_Project.M_Warehouse_ID,
[java] (CASE WHEN C_Project.M_Warehouse_ID IS NULL THEN '' ELSE (TO_CHAR(table14.Name) ) END) AS M_Warehouse_IDR,
[java] C_Project.DateContract,
[java] C_Project.DateFinish,
[java] C_Project.PlannedAmt,
[java] C_Project.InvoicedAmt,
[java] C_Project.ChangeProjectStatus,
[java] C_Project.GenerateOrder,
[java] C_Project.VC_Constructor,
[java] (CASE WHEN C_Project.VC_Constructor IS NULL THEN '' ELSE (TO_CHAR(table15.Name) ) END) AS VC_ConstructorR,
[java] C_Project.VC_Promoter,
[java] (CASE WHEN C_Project.VC_Promoter IS NULL THEN '' ELSE (TO_CHAR(table16.Name) ) END) AS VC_PromoterR,
[java] C_Project.VC_Datebudget,
[java] C_Project.VC_Datelicitation,
[java] C_Project.VC_Dateawarding,
[java] C_Project.VC_Datecontract,
[java] C_Project.VC_Datelicence,
[java] C_Project.VC_Datefirstocupation,
[java] C_Project.VC_Dateplanedstart,
[java] C_Project.VC_Dateplanedend,
[java] C_Project.VC_Daterealstart,
[java] C_Project.VC_Daterealend,
[java] C_Project.VC_Head1,
[java] (CASE WHEN C_Project.VC_Head1 IS NULL THEN '' ELSE (TO_CHAR(table17.Name) ) END) AS VC_Head1R,
[java] C_Project.VC_Head2,
[java] (CASE WHEN C_Project.VC_Head2 IS NULL THEN '' ELSE (TO_CHAR(table18.Name) ) END) AS VC_Head2R,
[java] C_Project.VC_Architect1,
[java] (CASE WHEN C_Project.VC_Architect1 IS NULL THEN '' ELSE (TO_CHAR(table19.Name) ) END) AS VC_Architect1R,
[java] C_Project.VC_Architect2,
[java] (CASE WHEN C_Project.VC_Architect2 IS NULL THEN '' ELSE (TO_CHAR(table20.Name) ) END) AS VC_Architect2R,
[java] C_Project.VC_Technicianarchitect1,
[java] (CASE WHEN C_Project.VC_Technicianarchitect1 IS NULL THEN '' ELSE (TO_CHAR(table21.Name) ) END) AS VC_Technicianarchitect1R,
[java] C_Project.VC_Technicianarchitect2,
[java] (CASE WHEN C_Project.VC_Technicianarchitect2 IS NULL THEN '' ELSE (TO_CHAR(table22.Name) ) END) AS VC_Technicianarchitect2R,
[java] C_Project.VC_Ssauthor,
[java] (CASE WHEN C_Project.VC_Ssauthor IS NULL THEN '' ELSE (TO_CHAR(table23.Name) ) END) AS VC_SsauthorR,
[java] C_Project.VC_Sscoordinator,
[java] (CASE WHEN C_Project.VC_Sscoordinator IS NULL THEN '' ELSE (TO_CHAR(table24.Name) ) END) AS VC_SscoordinatorR,
[java] C_Project.VC_Ssasistcentre,
[java] (CASE WHEN C_Project.VC_Ssasistcentre IS NULL THEN '' ELSE (TO_CHAR(table25.Name) ) END) AS VC_SsasistcentreR,
[java] C_Project.VC_Insurance,
[java] C_Project.VC_Oct,
[java] C_Project.VC_Registry,
[java] C_Project.VC_Surfacetotal,
[java] C_Project.VC_Surfaceabove,
[java] C_Project.VC_Surfaceunder,
[java] C_Project.VC_Surfacelot,
[java] C_Project.VC_Surfacecommonspaces,
[java] C_Project.VC_Nohouses,
[java] C_Project.VC_Surfacetotalhouses,
[java] C_Project.VC_Nolocals,
[java] C_Project.VC_Surfacetotallocals,
[java] C_Project.VC_Noparkings,
[java] C_Project.VC_Surfacetotalparkings,
[java] C_Project.C_Campaign_ID,
[java] C_Project.Setprojecttype,
[java] C_Project.C_ProjectType_ID,
[java] C_Project.C_Project_ID,
[java] C_Project.CommittedAmt,
[java] C_Project.CommittedQty,
[java] C_Project.CopyFrom,
[java] C_Project.Expexpenses,
[java] C_Project.Expmargin,
[java] C_Project.Expreinvoicing,
[java] C_Project.GenerateTo,
[java] C_Project.InvoicedQty,
[java] COALESCE(C_Project.IsCommitCeiling, 'N') AS IsCommitCeiling,
[java] COALESCE(C_Project.IsCommitment, 'N') AS IsCommitment,
[java] COALESCE(C_Project.IsSummary, 'N') AS IsSummary,
[java] C_Project.LastPlannedProposalDate,
[java] C_Project.M_PriceList_Version_ID,
[java] C_Project.POReference,
[java] C_Project.PlannedMarginAmt,
[java] C_Project.PlannedPOAmt,
[java] C_Project.PlannedQty,
[java] COALESCE(C_Project.Processed, 'N') AS Processed,
[java] C_Project.Processing,
[java] C_Project.ProjectBalanceAmt,
[java] C_Project.ProjectCategory,
[java] C_Project.Responsible_ID,
[java] C_Project.Servcost,
[java] C_Project.Servmargin,
[java] C_Project.Servrevenue,
[java] C_Project.C_Phase_ID,
[java]
[java] '' AS TR_BGCOLOR ,
[java] C_Project.Created,
[java] C_Project.CreatedBy,
[java] C_Project.Updated,
[java] C_Project.UpdatedBy, ? AS LANGUAGE
[java] FROM C_Project left join (select AD_Client_ID, Name from AD_Client) table1 on (C_Project.AD_Client_ID = table1.AD_Client_ID) left join (select AD_Org_ID, Name from AD_Org) table2 on (C_Project.AD_Org_ID = table2.AD_Org_ID) left join ad_ref_list_v list1 on (C_Project.Projectstatus = list1.value and list1.ad_reference_id = 800002 and list1.ad_language = ?) left join ad_ref_list_v list2 on (C_Project.Projectphase = list2.value and list2.ad_reference_id = 800003 and list2.ad_language = ?) left join ad_ref_list_v list3 on (C_Project.Projectkind = list3.value and list3.ad_reference_id = 800004 and list3.ad_language = ?) left join ad_ref_list_v list4 on (C_Project.Publicprivate = list4.value and list4.ad_reference_id = 800005 and list4.ad_language = ?) left join (select C_Location_ID, Address1, Address2, Postal, City, C_Region_ID, C_Country_ID from C_Location) table3 on (C_Project.C_Location_ID = table3.C_Location_ID) left join (select C_Region_ID, Name from C_Region) table4 on (table3.C_Region_ID = table4.C_Region_ID) left join (select C_Country_ID, Name from C_Country) table5 on (table3.C_Country_ID = table5.C_Country_ID) left join (select C_Country_ID,AD_Language, Name from C_Country_TRL) tableTRL5 on (table5.C_Country_ID = tableTRL5.C_Country_ID and tableTRL5.AD_Language = ?) left join (select AD_User_ID, Name from AD_User) table6 on (C_Project.SalesRep_ID = table6.AD_User_ID) left join (select C_BPartner_ID, Name from C_BPartner) table7 on (C_Project.C_BPartner_ID = table7.C_BPartner_ID) left join (select C_BPartner_Location_ID, Name from C_BPartner_Location) table8 on (C_Project.C_BPartner_Location_ID = table8.C_BPartner_Location_ID) left join (select AD_User_ID, Name from AD_User) table9 on (C_Project.AD_User_ID = table9.AD_User_ID) left join (select C_BPartner_Location_ID, Name from C_BPartner_Location) table10 on (C_Project.BillTo_ID = table10.C_BPartner_Location_ID) left join (select M_PriceList_ID, Name from M_PriceList) table11 on (C_Project.M_PriceList_ID = table11.M_PriceList_ID) left join (select C_Currency_ID, ISO_Code from C_Currency) table12 on (C_Project.C_Currency_ID = table12.C_Currency_ID) left join ad_ref_list_v list5 on (C_Project.PaymentRule = list5.value and list5.ad_reference_id = 195 and list5.ad_language = ?) left join (select C_PaymentTerm_ID, Name from C_PaymentTerm) table13 on (C_Project.C_PaymentTerm_ID = table13.C_PaymentTerm_ID) left join (select C_PaymentTerm_ID,AD_Language, Name from C_PaymentTerm_TRL) tableTRL13 on (table13.C_PaymentTerm_ID = tableTRL13.C_PaymentTerm_ID and tableTRL13.AD_Language = ?) left join (select M_Warehouse_ID, Name from M_Warehouse) table14 on (C_Project.M_Warehouse_ID = table14.M_Warehouse_ID) left join (select C_BPartner_ID, Name from C_BPartner) table15 on (C_Project.VC_Constructor = table15.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table16 on (C_Project.VC_Promoter = table16.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table17 on (C_Project.VC_Head1 = table17.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table18 on (C_Project.VC_Head2 = table18.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table19 on (C_Project.VC_Architect1 = table19.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table20 on (C_Project.VC_Architect2 = table20.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table21 on (C_Project.VC_Technicianarchitect1 = table21.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table22 on (C_Project.VC_Technicianarchitect2 = table22.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table23 on (C_Project.VC_Ssauthor = table23.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table24 on (C_Project.VC_Sscoordinator = table24.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table25 on (C_Project.VC_Ssasistcentre = table25.C_BPartner_ID)
[java] java.sql.SQLException: manejador de sentencias no ejecutado
[java] WHERE 2=2
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] AND 1=1
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
[java] AND C_Project.AD_Client_ID IN ('1')
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
[java] AND C_Project.AD_Org_ID IN ('1')
[java] at oracle.jdbc.driver.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:720)
[java]
[java] at oracle.jdbc.driver.OracleStatement.getNumberOfColumns(OracleStatement.java:1702)
[java] ORDER BY 1, 1
[java] at oracle.jdbc.driver.OracleResultSetMetaData.getValidColumnIndex(OracleResultSetMetaData.java:142)
[java]
[java] at oracle.jdbc.driver.OracleResultSetMetaData.getColumnType(OracleResultSetMetaData.java:354)
[java] Exception:java.sql.SQLException: ORA-00904: "C_PROJECT"."VC_CERTIFICATIONPERCENT": identificador no válido
[java]
[java] at org.openbravo.data.Sqlc.printKeySequenceSql(Unknown Source)
[java] 810 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado
[java] at org.openbravo.data.Sqlc.printFunctionSql(Unknown Source)
[java] 811 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado
[java] at org.openbravo.data.Sqlc.endElement(Unknown Source)
[java] 812 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado
[java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
[java] 814 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado
[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] java.sql.SQLException: manejador de sentencias no ejecutado
[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] 939 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
[java] java.sql.SQLException: ORA-00904: "C_PROJECT"."VC_CERTIFICATIONPERCENT": identificador no válido
[java] SELECT C_Project.VC_Certificationpercent ,
[java]
[java] C_Project.AD_Client_ID,
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] (CASE WHEN C_Project.AD_Client_ID IS NULL THEN '' ELSE (TO_CHAR(table1.Name) ) END) AS AD_Client_IDR,
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] C_Project.AD_Org_ID,
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] (CASE WHEN C_Project.AD_Org_ID IS NULL THEN '' ELSE (TO_CHAR(table2.Name) ) END) AS AD_Org_IDR,
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] C_Project.Value,
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
[java] C_Project.Name,
[java] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
[java] COALESCE(C_Project.IsActive, 'N') AS IsActive,
[java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
[java] C_Project.Description,
[java] at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
[java] C_Project.Note,
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
[java] C_Project.Projectstatus,
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
[java] (CASE WHEN C_Project.Projectstatus IS NULL THEN '' ELSE ( TO_CHAR(list1.name) ) END) AS ProjectstatusR,
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
[java] C_Project.Projectphase,
[java] at org.openbravo.data.Sqlc.query(Unknown Source)
[java] (CASE WHEN C_Project.Projectphase IS NULL THEN '' ELSE ( TO_CHAR(list2.name) ) END) AS ProjectphaseR,
[java] at org.openbravo.data.Sqlc.endElement(Unknown Source)
[java] C_Project.Projectkind,
[java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
[java] (CASE WHEN C_Project.Projectkind IS NULL THEN '' ELSE ( TO_CHAR(list3.name) ) END) AS ProjectkindR,
[java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
[java] C_Project.Publicprivate,
[java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
[java] (CASE WHEN C_Project.Publicprivate IS NULL THEN '' ELSE ( TO_CHAR(list4.name) ) END) AS PublicprivateR,
[java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
[java] C_Project.C_Location_ID,
[java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[java] (CASE WHEN C_Project.C_Location_ID IS NULL THEN '' ELSE (TO_CHAR(table3.Address1) || ' - ' || TO_CHAR(table3.Address2) || ' - ' || TO_CHAR(table3.Postal) || ' - ' || TO_CHAR(table3.City) || ' - ' || TO_CHAR(table4.Name) || ' - ' || TO_CHAR((CASE WHEN tableTRL5.Name IS NULL THEN TO_CHAR(table5.Name) ELSE TO_CHAR(tableTRL5.Name) END)) ) END) AS C_Location_IDR,
[java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[java] C_Project.SalesRep_ID,
[java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
[java] (CASE WHEN C_Project.SalesRep_ID IS NULL THEN '' ELSE ( TO_CHAR(table6.Name) ) END) AS SalesRep_IDR,
[java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
[java] C_Project.C_BPartner_ID,
[java] at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source)
[java] (CASE WHEN C_Project.C_BPartner_ID IS NULL THEN '' ELSE (TO_CHAR(table7.Name) ) END) AS C_BPartner_IDR,
[java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
[java] C_Project.C_BPartner_Location_ID,
[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] java.sql.SQLException: manejador de sentencias no ejecutado
[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] (CASE WHEN C_Project.C_BPartner_Location_ID IS NULL THEN '' ELSE (TO_CHAR(table8.Name) ) END) AS C_BPartner_Location_IDR,
[java] at oracle.jdbc.driver.OracleStatement.getNumberOfColumns(OracleStatement.java:1702)
[java] C_Project.AD_User_ID,
[java] at oracle.jdbc.driver.OracleResultSetMetaData.getValidColumnIndex(OracleResultSetMetaData.java:142)
[java] (CASE WHEN C_Project.AD_User_ID IS NULL THEN '' ELSE (TO_CHAR(table9.Name) ) END) AS AD_User_IDR,
[java] at oracle.jdbc.driver.OracleResultSetMetaData.getColumnType(OracleResultSetMetaData.java:354)
[java] C_Project.BillTo_ID,
[java] at org.openbravo.data.Sqlc.printKeySequenceSql(Unknown Source)
[java] (CASE WHEN C_Project.BillTo_ID IS NULL THEN '' ELSE ( TO_CHAR(table10.Name) ) END) AS BillTo_IDR,
[java] at org.openbravo.data.Sqlc.printFunctionSql(Unknown Source)
[java] COALESCE(C_Project.Invoice_ToProject, 'N') AS Invoice_ToProject,
[java] at org.openbravo.data.Sqlc.endElement(Unknown Source)
[java] C_Project.M_PriceList_ID,
[java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
[java] (CASE WHEN C_Project.M_PriceList_ID IS NULL THEN '' ELSE (TO_CHAR(table11.Name) ) END) AS M_PriceList_IDR,
[java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
[java] C_Project.C_Currency_ID,
[java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
[java] (CASE WHEN C_Project.C_Currency_ID IS NULL THEN '' ELSE (TO_CHAR(table12.ISO_Code) ) END) AS C_Currency_IDR,
[java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
[java] C_Project.AccountNo,
[java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[java] C_Project.Document_Copies,
[java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[java] C_Project.PaymentRule,
[java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
[java] (CASE WHEN C_Project.PaymentRule IS NULL THEN '' ELSE ( TO_CHAR(list5.name) ) END) AS PaymentRuleR,
[java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
[java] C_Project.C_PaymentTerm_ID,
[java] at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source)
[java] (CASE WHEN C_Project.C_PaymentTerm_ID IS NULL THEN '' ELSE (TO_CHAR((CASE WHEN tableTRL13.Name IS NULL THEN TO_CHAR(table13.Name) ELSE TO_CHAR(tableTRL13.Name) END)) ) END) AS C_PaymentTerm_IDR,
[java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
[java] C_Project.M_Warehouse_ID,
[java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
[java] (CASE WHEN C_Project.M_Warehouse_ID IS NULL THEN '' ELSE (TO_CHAR(table14.Name) ) END) AS M_Warehouse_IDR,
[java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
[java] C_Project.DateContract,
[java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
[java] C_Project.DateFinish,
[java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
[java] C_Project.PlannedAmt,
[java] at org.openbravo.data.Sqlc.main(Unknown Source)
[java] C_Project.InvoicedAmt,
[java] C_Project.ChangeProjectStatus,
[java] C_Project.GenerateOrder,
[java] C_Project.VC_Constructor,
[java] (CASE WHEN C_Project.VC_Constructor IS NULL THEN '' ELSE (TO_CHAR(table15.Name) ) END) AS VC_ConstructorR,
[java] C_Project.VC_Promoter,
[java] (CASE WHEN C_Project.VC_Promoter IS NULL THEN '' ELSE (TO_CHAR(table16.Name) ) END) AS VC_PromoterR,
[java] C_Project.VC_Datebudget,
[java] C_Project.VC_Datelicitation,
[java] C_Project.VC_Dateawarding,
[java] C_Project.VC_Datecontract,
[java] C_Project.VC_Datelicence,
[java] C_Project.VC_Datefirstocupation,
[java] C_Project.VC_Dateplanedstart,
[java] java.sql.SQLException: manejador de sentencias no ejecutado
[java] C_Project.VC_Dateplanedend,
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] C_Project.VC_Daterealstart,
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
[java] C_Project.VC_Daterealend,
[java] C_Project.VC_Head1,
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
[java] (CASE WHEN C_Project.VC_Head1 IS NULL THEN '' ELSE (TO_CHAR(table17.Name) ) END) AS VC_Head1R,
[java] at oracle.jdbc.driver.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:720)
[java] C_Project.VC_Head2,
[java] at oracle.jdbc.driver.OracleStatement.getNumberOfColumns(OracleStatement.java:1702)
[java] (CASE WHEN C_Project.VC_Head2 IS NULL THEN '' ELSE (TO_CHAR(table18.Name) ) END) AS VC_Head2R,
[java] at oracle.jdbc.driver.OracleResultSetMetaData.getValidColumnIndex(OracleResultSetMetaData.java:142)
[java] C_Project.VC_Architect1,
[java] at oracle.jdbc.driver.OracleResultSetMetaData.getColumnType(OracleResultSetMetaData.java:354)
[java] (CASE WHEN C_Project.VC_Architect1 IS NULL THEN '' ELSE (TO_CHAR(table19.Name) ) END) AS VC_Architect1R,
[java] at org.openbravo.data.Sqlc.printFunctionSql(Unknown Source)
[java] C_Project.VC_Architect2,
[java] at org.openbravo.data.Sqlc.endElement(Unknown Source)
[java] (CASE WHEN C_Project.VC_Architect2 IS NULL THEN '' ELSE (TO_CHAR(table20.Name) ) END) AS VC_Architect2R,
[java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
[java] C_Project.VC_Technicianarchitect1,
[java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
[java] (CASE WHEN C_Project.VC_Technicianarchitect1 IS NULL THEN '' ELSE (TO_CHAR(table21.Name) ) END) AS VC_Technicianarchitect1R,
[java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
[java] C_Project.VC_Technicianarchitect2,
[java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
[java] (CASE WHEN C_Project.VC_Technicianarchitect2 IS NULL THEN '' ELSE (TO_CHAR(table22.Name) ) END) AS VC_Technicianarchitect2R,
[java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[java] C_Project.VC_Ssauthor,
[java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[java] (CASE WHEN C_Project.VC_Ssauthor IS NULL THEN '' ELSE (TO_CHAR(table23.Name) ) END) AS VC_SsauthorR,
[java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
[java] C_Project.VC_Sscoordinator,
[java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
[java] (CASE WHEN C_Project.VC_Sscoordinator IS NULL THEN '' ELSE (TO_CHAR(table24.Name) ) END) AS VC_SscoordinatorR,
[java] at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source)
[java] C_Project.VC_Ssasistcentre,
[java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
[java] (CASE WHEN C_Project.VC_Ssasistcentre IS NULL THEN '' ELSE (TO_CHAR(table25.Name) ) END) AS VC_SsasistcentreR,
[java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
[java] C_Project.VC_Insurance,
[java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
[java] C_Project.VC_Oct,
[java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
[java] C_Project.VC_Registry,
[java] at org.openbravo.data.Sqlc.listDir(Unknown Source)
[java] C_Project.VC_Surfacetotal,
[java] at org.openbravo.data.Sqlc.main(Unknown Source)
[java] C_Project.VC_Surfaceabove,
[java] C_Project.VC_Surfaceunder,
[java] C_Project.VC_Surfacelot,
[java] C_Project.VC_Surfacecommonspaces,
[java] C_Project.VC_Nohouses,
[java] C_Project.VC_Surfacetotalhouses,
[java] C_Project.VC_Nolocals,
[java] C_Project.VC_Surfacetotallocals,
[java] C_Project.VC_Noparkings,
[java] C_Project.VC_Surfacetotalparkings,
[java] C_Project.C_Campaign_ID,
[java] C_Project.Setprojecttype,
[java] C_Project.C_ProjectType_ID,
[java] C_Project.C_Project_ID,
[java] C_Project.CommittedAmt,
[java] C_Project.CommittedQty,
[java] C_Project.CopyFrom,
[java] C_Project.Expexpenses,
[java] C_Project.Expmargin,
[java] C_Project.Expreinvoicing,
[java] C_Project.GenerateTo,
[java] C_Project.InvoicedQty,
[java] COALESCE(C_Project.IsCommitCeiling, 'N') AS IsCommitCeiling,
[java] COALESCE(C_Project.IsCommitment, 'N') AS IsCommitment,
[java] COALESCE(C_Project.IsSummary, 'N') AS IsSummary,
[java] C_Project.LastPlannedProposalDate,
[java] C_Project.M_PriceList_Version_ID,
[java] C_Project.POReference,
[java] C_Project.PlannedMarginAmt,
[java] C_Project.PlannedPOAmt,
[java] C_Project.PlannedQty,
[java] COALESCE(C_Project.Processed, 'N') AS Processed,
[java] C_Project.Processing,
[java] C_Project.ProjectBalanceAmt,
[java] C_Project.ProjectCategory,
[java] C_Project.Responsible_ID,
[java] C_Project.Servcost,
[java] C_Project.Servmargin,
[java] C_Project.Servrevenue,
[java] C_Project.C_Phase_ID,
[java]
[java] C_Project.Created,
[java] C_Project.CreatedBy,
[java] C_Project.Updated,
[java] C_Project.UpdatedBy, ? AS LANGUAGE
[java] FROM C_Project left join (select AD_Client_ID, Name from AD_Client) table1 on (C_Project.AD_Client_ID = table1.AD_Client_ID) left join (select AD_Org_ID, Name from AD_Org) table2 on (C_Project.AD_Org_ID = table2.AD_Org_ID) left join ad_ref_list_v list1 on (C_Project.Projectstatus = list1.value and list1.ad_reference_id = 800002 and list1.ad_language = ?) left join ad_ref_list_v list2 on (C_Project.Projectphase = list2.value and list2.ad_reference_id = 800003 and list2.ad_language = ?) left join ad_ref_list_v list3 on (C_Project.Projectkind = list3.value and list3.ad_reference_id = 800004 and list3.ad_language = ?) left join ad_ref_list_v list4 on (C_Project.Publicprivate = list4.value and list4.ad_reference_id = 800005 and list4.ad_language = ?) left join (select C_Location_ID, Address1, Address2, Postal, City, C_Region_ID, C_Country_ID from C_Location) table3 on (C_Project.C_Location_ID = table3.C_Location_ID) left join (select C_Region_ID, Name from C_Region) table4 on (table3.C_Region_ID = table4.C_Region_ID) left join (select C_Country_ID, Name from C_Country) table5 on (table3.C_Country_ID = table5.C_Country_ID) left join (select C_Country_ID,AD_Language, Name from C_Country_TRL) tableTRL5 on (table5.C_Country_ID = tableTRL5.C_Country_ID and tableTRL5.AD_Language = ?) left join (select AD_User_ID, Name from AD_User) table6 on (C_Project.SalesRep_ID = table6.AD_User_ID) left join (select C_BPartner_ID, Name from C_BPartner) table7 on (C_Project.C_BPartner_ID = table7.C_BPartner_ID) left join (select C_BPartner_Location_ID, Name from C_BPartner_Location) table8 on (C_Project.C_BPartner_Location_ID = table8.C_BPartner_Location_ID) left join (select AD_User_ID, Name from AD_User) table9 on (C_Project.AD_User_ID = table9.AD_User_ID) left join (select C_BPartner_Location_ID, Name from C_BPartner_Location) table10 on (C_Project.BillTo_ID = table10.C_BPartner_Location_ID) left join (select M_PriceList_ID, Name from M_PriceList) table11 on (C_Project.M_PriceList_ID = table11.M_PriceList_ID) left join (select C_Currency_ID, ISO_Code from C_Currency) table12 on (C_Project.C_Currency_ID = table12.C_Currency_ID) left join ad_ref_list_v list5 on (C_Project.PaymentRule = list5.value and list5.ad_reference_id = 195 and list5.ad_language = ?) left join (select C_PaymentTerm_ID, Name from C_PaymentTerm) table13 on (C_Project.C_PaymentTerm_ID = table13.C_PaymentTerm_ID) left join (select C_PaymentTerm_ID,AD_Language, Name from C_PaymentTerm_TRL) tableTRL13 on (table13.C_PaymentTerm_ID = tableTRL13.C_PaymentTerm_ID and tableTRL13.AD_Language = ?) left join (select M_Warehouse_ID, Name from M_Warehouse) table14 on (C_Project.M_Warehouse_ID = table14.M_Warehouse_ID) left join (select C_BPartner_ID, Name from C_BPartner) table15 on (C_Project.VC_Constructor = table15.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table16 on (C_Project.VC_Promoter = table16.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table17 on (C_Project.VC_Head1 = table17.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table18 on (C_Project.VC_Head2 = table18.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table19 on (C_Project.VC_Architect1 = table19.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table20 on (C_Project.VC_Architect2 = table20.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table21 on (C_Project.VC_Technicianarchitect1 = table21.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table22 on (C_Project.VC_Technicianarchitect2 = table22.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table23 on (C_Project.VC_Ssauthor = table23.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table24 on (C_Project.VC_Sscoordinator = table24.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table25 on (C_Project.VC_Ssasistcentre = table25.C_BPartner_ID)
[java] WHERE 2=2
[java]
[java] AND 1=1
[java] AND C_Project.C_Project_ID = ?
[java] Exception:java.sql.SQLException: ORA-00904: "C_PROJECT"."VC_CERTIFICATIONPERCENT": identificador no válido
[java]
[java] 946 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado
[java] 953 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado
[java] 963 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado
[java] Exception in thread "main" java.lang.NullPointerException
[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)
compileSqlc:
[javac] Compiling 26 source files to /opt/AppsConstruccion/build/classes/src
[javac] Compiling 7 source files to /opt/AppsConstruccion/build/classes/src
[javac] Compiling 31 source files to /opt/AppsConstruccion/build/classes/src
[javac] /opt/AppsConstruccion/srcAD/org/openbravo/erpWindows/ConstructionProject/ConstructionSite.java:436: cannot find symbol
[javac] symbol : variable vcCertificationpercent
[javac] location: class org.openbravo.erpWindows.ConstructionProject.ConstructionSiteData
[javac] data.vcCertificationpercent = vars.getStringParameter("inpvcCertificationpercent "); data.adClientId = vars.getRequiredGlobalVariable("inpadClientId", windowId + "|AD_Client_ID"); data.adClientIdr = vars.getStringParameter("inpadClientId_R"); data.adOrgId = vars.getRequiredGlobalVariable("inpadOrgId", windowId + "|AD_Org_ID"); data.adOrgIdr = vars.getStringParameter("inpadOrgId_R"); data.value = vars.getStringParameter("inpvalue"); data.name = vars.getRequiredStringParameter("inpname"); data.isactive = vars.getStringParameter("inpisactive", "N"); data.description = vars.getStringParameter("inpdescription"); data.note = vars.getStringParameter("inpnote"); data.projectstatus = vars.getRequiredStringParameter("inpprojectstatus"); data.projectstatusr = vars.getStringParameter("inpprojectstatus_R"); data.projectphase = vars.getStringParameter("inpprojectphase"); data.projectphaser = vars.getStringParameter("inpprojectphase_R"); data.projectkind = vars.getStringParameter("inpprojectkind"); data.projectkindr = vars.getStringParameter("inpprojectkind_R"); data.publicprivate = vars.getStringParameter("inppublicprivate"); data.publicprivater = vars.getStringParameter("inppublicprivate_R"); data.cLocationId = vars.getStringParameter("inpcLocationId"); data.cLocationIdr = vars.getStringParameter("inpcLocationId_R"); data.salesrepId = vars.getStringParameter("inpsalesrepId"); data.salesrepIdr = vars.getStringParameter("inpsalesrepId_R"); data.cBpartnerId = vars.getStringParameter("inpcBpartnerId"); data.cBpartnerIdr = vars.getStringParameter("inpcBpartnerId_R"); data.cBpartnerLocationId = vars.getStringParameter("inpcBpartnerLocationId"); data.cBpartnerLocationIdr = vars.getStringParameter("inpcBpartnerLocationId_R"); data.adUserId = vars.getStringParameter("inpadUserId"); data.adUserIdr = vars.getStringParameter("inpadUserId_R"); data.billtoId = vars.getStringParameter("inpbilltoId"); data.billtoIdr = vars.getStringParameter("inpbilltoId_R"); data.invoiceToproject = vars.getStringParameter("inpinvoiceToproject", "N"); data.mPricelistId = vars.getStringParameter("inpmPricelistId"); data.mPricelistIdr = vars.getStringParameter("inpmPricelistId_R"); data.cCurrencyId = vars.getRequiredStringParameter("inpcCurrencyId"); data.cCurrencyIdr = vars.getStringParameter("inpcCurrencyId_R"); data.accountno = vars.getStringParameter("inpaccountno"); data.documentCopies = vars.getStringParameter("inpdocumentCopies"); data.paymentrule = vars.getStringParameter("inppaymentrule"); data.paymentruler = vars.getStringParameter("inppaymentrule_R"); data.cPaymenttermId = vars.getStringParameter("inpcPaymenttermId"); data.cPaymenttermIdr = vars.getStringParameter("inpcPaymenttermId_R"); data.mWarehouseId = vars.getStringParameter("inpmWarehouseId"); data.mWarehouseIdr = vars.getStringParameter("inpmWarehouseId_R"); data.datecontract = vars.getStringParameter("inpdatecontract"); data.datefinish = vars.getStringParameter("inpdatefinish"); data.plannedamt = vars.getRequiredStringParameter("inpplannedamt"); data.invoicedamt = vars.getRequiredStringParameter("inpinvoicedamt"); data.changeprojectstatus = vars.getStringParameter("inpchangeprojectstatus"); data.generateorder = vars.getStringParameter("inpgenerateorder"); data.vcConstructor = vars.getStringParameter("inpvcConstructor"); data.vcConstructorr = vars.getStringParameter("inpvcConstructor_R"); data.vcPromoter = vars.getStringParameter("inpvcPromoter"); data.vcPromoterr = vars.getStringParameter("inpvcPromoter_R"); data.vcDatebudget = vars.getStringParameter("inpvcDatebudget"); data.vcDatelicitation = vars.getStringParameter("inpvcDatelicitation"); data.vcDateawarding = vars.getStringParameter("inpvcDateawarding"); data.vcDatecontract = vars.getStringParameter("inpvcDatecontract"); data.vcDatelicence = vars.getStringParameter("inpvcDatelicence"); data.vcDatefirstocupation = vars.getStringParameter("inpvcDatefirstocupation"); data.vcDateplanedstart = vars.getStringParameter("inpvcDateplanedstart"); data.vcDateplanedend = vars.getStringParameter("inpvcDateplanedend"); data.vcDaterealstart = vars.getStringParameter("inpvcDaterealstart"); data.vcDaterealend = vars.getStringParameter("inpvcDaterealend"); data.vcHead1 = vars.getStringParameter("inpvcHead1"); data.vcHead1r = vars.getStringParameter("inpvcHead1_R"); data.vcHead2 = vars.getStringParameter("inpvcHead2"); data.vcHead2r = vars.getStringParameter("inpvcHead2_R"); data.vcArchitect1 = vars.getStringParameter("inpvcArchitect1"); data.vcArchitect1r = vars.getStringParameter("inpvcArchitect1_R"); data.vcArchitect2 = vars.getStringParameter("inpvcArchitect2"); data.vcArchitect2r = vars.getStringParameter("inpvcArchitect2_R"); data.vcTechnicianarchitect1 = vars.getStringParameter("inpvcTechnicianarchitect1"); data.vcTechnicianarchitect1r = vars.getStringParameter("inpvcTechnicianarchitect1_R"); data.vcTechnicianarchitect2 = vars.getStringParameter("inpvcTechnicianarchitect2"); data.vcTechnicianarchitect2r = vars.getStringParameter("inpvcTechnicianarchitect2_R"); data.vcSsauthor = vars.getStringParameter("inpvcSsauthor"); data.vcSsauthorr = vars.getStringParameter("inpvcSsauthor_R"); data.vcSscoordinator = vars.getStringParameter("inpvcSscoordinator"); data.vcSscoordinatorr = vars.getStringParameter("inpvcSscoordinator_R"); data.vcSsasistcentre = vars.getStringParameter("inpvcSsasistcentre"); data.vcSsasistcentrer = vars.getStringParameter("inpvcSsasistcentre_R"); data.vcInsurance = vars.getStringParameter("inpvcInsurance"); data.vcOct = vars.getStringParameter("inpvcOct"); data.vcRegistry = vars.getStringParameter("inpvcRegistry"); data.vcSurfacetotal = vars.getStringParameter("inpvcSurfacetotal"); data.vcSurfaceabove = vars.getStringParameter("inpvcSurfaceabove"); data.vcSurfaceunder = vars.getStringParameter("inpvcSurfaceunder"); data.vcSurfacelot = vars.getStringParameter("inpvcSurfacelot"); data.vcSurfacecommonspaces = vars.getStringParameter("inpvcSurfacecommonspaces"); data.vcNohouses = vars.getStringParameter("inpvcNohouses"); data.vcSurfacetotalhouses = vars.getStringParameter("inpvcSurfacetotalhouses"); data.vcNolocals = vars.getStringParameter("inpvcNolocals"); data.vcSurfacetotallocals = vars.getStringParameter("inpvcSurfacetotallocals"); data.vcNoparkings = vars.getStringParameter("inpvcNoparkings"); data.vcSurfacetotalparkings = vars.getStringParameter("inpvcSurfacetotalparkings"); data.cCampaignId = vars.getStringParameter("inpcCampaignId"); data.setprojecttype = vars.getStringParameter("inpsetprojecttype"); data.cProjecttypeId = vars.getStringParameter("inpcProjecttypeId"); data.cProjectId = vars.getRequestGlobalVariable("inpcProjectId", windowId + "|C_Project_ID"); data.committedamt = vars.getRequiredStringParameter("inpcommittedamt"); data.committedqty = vars.getRequiredStringParameter("inpcommittedqty"); data.copyfrom = vars.getStringParameter("inpcopyfrom"); data.expexpenses = vars.getStringParameter("inpexpexpenses"); data.expmargin = vars.getStringParameter("inpexpmargin"); data.expreinvoicing = vars.getStringParameter("inpexpreinvoicing"); data.generateto = vars.getStringParameter("inpgenerateto"); data.invoicedqty = vars.getRequiredStringParameter("inpinvoicedqty"); data.iscommitceiling = vars.getStringParameter("inpiscommitceiling", "N"); data.iscommitment = vars.getRequiredInputGlobalVariable("inpiscommitment", windowId + "|IsCommitment", "N"); data.issummary = vars.getStringParameter("inpissummary", "N"); data.lastplannedproposaldate = vars.getStringParameter("inplastplannedproposaldate"); data.mPricelistVersionId = vars.getStringParameter("inpmPricelistVersionId"); data.poreference = vars.getStringParameter("inpporeference"); data.plannedmarginamt = vars.getRequiredStringParameter("inpplannedmarginamt"); data.plannedpoamt = vars.getStringParameter("inpplannedpoamt"); data.plannedqty = vars.getRequiredStringParameter("inpplannedqty"); data.processed = vars.getStringParameter("inpprocessed", "N"); data.processing = vars.getStringParameter("inpprocessing"); data.projectbalanceamt = vars.getRequiredStringParameter("inpprojectbalanceamt"); data.projectcategory = vars.getStringParameter("inpprojectcategory"); data.responsibleId = vars.getStringParameter("inpresponsibleId"); data.servcost = vars.getStringParameter("inpservcost"); data.servmargin = vars.getStringParameter("inpservmargin"); data.servrevenue = vars.getStringParameter("inpservrevenue"); data.cPhaseId = vars.getStringParameter("inpcPhaseId");
[javac] ^
[javac] /opt/AppsConstruccion/srcAD/org/openbravo/erpWindows/ConstructionProject/ConstructionSite.java:764: set(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String) in org.openbravo.erpWindows.ConstructionProject.ConstructionSiteData cannot be applied to (java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String)
[javac] data = ConstructionSiteData.set(Utility.getDefault(this, vars, "VC_Certificationpercent ", "", "800001", ""), Utility.getDefault(this, vars, "AD_Client_ID", "@AD_CLIENT_ID@", "800001", ""), Utility.getDefault(this, vars, "AD_Org_ID", "@AD_Org_ID@", "800001", ""), Utility.getDefault(this, vars, "Value", "", "800001", ""), Utility.getDefault(this, vars, "Name", "", "800001", ""), "Y", Utility.getDefault(this, vars, "Description", "", "800001", ""), Utility.getDefault(this, vars, "Note", "", "800001", ""), Utility.getDefault(this, vars, "Projectstatus", "OP", "800001", ""), Utility.getDefault(this, vars, "Projectphase", "", "800001", ""), Utility.getDefault(this, vars, "Projectkind", "", "800001", ""), Utility.getDefault(this, vars, "Publicprivate", "", "800001", ""), Utility.getDefault(this, vars, "C_Location_ID", "", "800001", ""), ConstructionSiteData.selectDef800142_0(this, Utility.getDefault(this, vars, "C_Location_ID", "", "800001", "")), Utility.getDefault(this, vars, "SalesRep_ID", "", "800001", ""), Utility.getDefault(this, vars, "C_BPartner_ID", "", "800001", ""), ConstructionSiteData.selectDef3902_1(this, Utility.getDefault(this, vars, "C_BPartner_ID", "", "800001", "")), Utility.getDefault(this, vars, "C_BPartner_Location_ID", "", "800001", ""), Utility.getDefault(this, vars, "AD_User_ID", "-1", "800001", ""), Utility.getDefault(this, vars, "BillTo_ID", "", "800001", ""), Utility.getDefault(this, vars, "Invoice_ToProject", "", "800001", "N"), Utility.getDefault(this, vars, "M_PriceList_ID", "", "800001", ""), Utility.getDefault(this, vars, "C_Currency_ID", "", "800001", ""), Utility.getDefault(this, vars, "AccountNo", "", "800001", ""), Utility.getDefault(this, vars, "Document_Copies", "1", "800001", ""), Utility.getDefault(this, vars, "PaymentRule", "", "800001", ""), Utility.getDefault(this, vars, "C_PaymentTerm_ID", "", "800001", ""), Utility.getDefault(this, vars, "M_Warehouse_ID", "", "800001", ""), Utility.getDefault(this, vars, "DateContract", "", "800001", ""), Utility.getDefault(this, vars, "DateFinish", "", "800001", ""), Utility.getDefault(this, vars, "PlannedAmt", "", "800001", "0"), Utility.getDefault(this, vars, "InvoicedAmt", "", "800001", "0"), Utility.getDefault(this, vars, "ChangeProjectStatus", "", "800001", "N"), (vars.getLanguage().equals("en_US")?ListData.selectName(this, "800002", Utility.getDefault(this, vars, "ChangeProjectStatus", "", "800001", "N")):ListData.selectNameTrl(this, vars.getLanguage(), "800002", Utility.getDefault(this, vars, "ChangeProjectStatus", "", "800001", "N"))), Utility.getDefault(this, vars, "GenerateOrder", "", "800001", "N"), Utility.getDefault(this, vars, "VC_Constructor", "", "800001", ""), ConstructionSiteData.selectDef400400_2(this, Utility.getDefault(this, vars, "VC_Constructor", "", "800001", "")), Utility.getDefault(this, vars, "VC_Promoter", "", "800001", ""), ConstructionSiteData.selectDef400424_3(this, Utility.getDefault(this, vars, "VC_Promoter", "", "800001", "")), Utility.getDefault(this, vars, "VC_Datebudget", "", "800001", ""), Utility.getDefault(this, vars, "VC_Datelicitation", "", "800001", ""), Utility.getDefault(this, vars, "VC_Dateawarding", "", "800001", ""), Utility.getDefault(this, vars, "VC_Datecontract", "", "800001", ""), Utility.getDefault(this, vars, "VC_Datelicence", "", "800001", ""), Utility.getDefault(this, vars, "VC_Datefirstocupation", "", "800001", ""), Utility.getDefault(this, vars, "VC_Dateplanedstart", "", "800001", ""), Utility.getDefault(this, vars, "VC_Dateplanedend", "", "800001", ""), Utility.getDefault(this, vars, "VC_Daterealstart", "", "800001", ""), Utility.getDefault(this, vars, "VC_Daterealend", "", "800001", ""), Utility.getDefault(this, vars, "VC_Head1", "", "800001", ""), ConstructionSiteData.selectDef400401_4(this, Utility.getDefault(this, vars, "VC_Head1", "", "800001", "")), Utility.getDefault(this, vars, "VC_Head2", "", "800001", ""), ConstructionSiteData.selectDef400402_5(this, Utility.getDefault(this, vars, "VC_Head2", "", "800001", "")), Utility.getDefault(this, vars, "VC_Architect1", "", "800001", ""), ConstructionSiteData.selectDef400405_6(this, Utility.getDefault(this, vars, "VC_Architect1", "", "800001", "")), Utility.getDefault(this, vars, "VC_Architect2", "", "800001", ""), ConstructionSiteData.selectDef400406_7(this, Utility.getDefault(this, vars, "VC_Architect2", "", "800001", "")), Utility.getDefault(this, vars, "VC_Technicianarchitect1", "", "800001", ""), ConstructionSiteData.selectDef400422_8(this, Utility.getDefault(this, vars, "VC_Technicianarchitect1", "", "800001", "")), Utility.getDefault(this, vars, "VC_Technicianarchitect2", "", "800001", ""), ConstructionSiteData.selectDef400423_9(this, Utility.getDefault(this, vars, "VC_Technicianarchitect2", "", "800001", "")), Utility.getDefault(this, vars, "VC_Ssauthor", "", "800001", ""), ConstructionSiteData.selectDef400408_10(this, Utility.getDefault(this, vars, "VC_Ssauthor", "", "800001", "")), Utility.getDefault(this, vars, "VC_Sscoordinator", "", "800001", ""), ConstructionSiteData.selectDef400410_11(this, Utility.getDefault(this, vars, "VC_Sscoordinator", "", "800001", "")), Utility.getDefault(this, vars, "VC_Ssasistcentre", "", "800001", ""), ConstructionSiteData.selectDef400409_12(this, Utility.getDefault(this, vars, "VC_Ssasistcentre", "", "800001", "")), Utility.getDefault(this, vars, "VC_Insurance", "", "800001", ""), Utility.getDefault(this, vars, "VC_Oct", "", "800001", ""), Utility.getDefault(this, vars, "VC_Registry", "", "800001", ""), Utility.getDefault(this, vars, "VC_Surfacetotal", "", "800001", ""), Utility.getDefault(this, vars, "VC_Surfaceabove", "", "800001", ""), Utility.getDefault(this, vars, "VC_Surfaceunder", "", "800001", ""), Utility.getDefault(this, vars, "VC_Surfacelot", "", "800001", ""), Utility.getDefault(this, vars, "VC_Surfacecommonspaces", "", "800001", ""), Utility.getDefault(this, vars, "VC_Nohouses", "", "800001", ""), Utility.getDefault(this, vars, "VC_Surfacetotalhouses", "", "800001", ""), Utility.getDefault(this, vars, "VC_Nolocals", "", "800001", ""), Utility.getDefault(this, vars, "VC_Surfacetotallocals", "", "800001", ""), Utility.getDefault(this, vars, "VC_Noparkings", "", "800001", ""), Utility.getDefault(this, vars, "VC_Surfacetotalparkings", "", "800001", ""), Utility.getDefault(this, vars, "Responsible_ID", "", "800001", ""), Utility.getDefault(this, vars, "IsSummary", "", "800001", "N"), Utility.getDefault(this, vars, "Servmargin", "", "800001", ""), Utility.getDefault(this, vars, "Servcost", "", "800001", ""), Utility.getDefault(this, vars, "Servrevenue", "", "800001", ""), Utility.getDefault(this, vars, "Expmargin", "", "800001", ""), Utility.getDefault(this, vars, "Expexpenses", "", "800001", ""), Utility.getDefault(this, vars, "Setprojecttype", "", "800001", "N"), Utility.getDefault(this, vars, "C_Project_ID", "", "800001", "0"), Utility.getDefault(this, vars, "ProjectCategory", "@PREPROJECTCATEGORY@", "800001", ""), Utility.getDefault(this, vars, "PlannedMarginAmt", "", "800001", "0"), Utility.getDefault(this, vars, "CommittedQty", "", "800001", "0"), Utility.getDefault(this, vars, "CommittedAmt", "", "800001", "0"), Utility.getDefault(this, vars, "M_PriceList_Version_ID", "", "800001", ""), Utility.getDefault(this, vars, "C_Campaign_ID", "", "800001", ""), Utility.getDefault(this, vars, "POReference", "", "800001", ""), Utility.getDefault(this, vars, "C_ProjectType_ID", "", "800001", ""), Utility.getDefault(this, vars, "PlannedPOAmt", "", "800001", ""), Utility.getDefault(this, vars, "LastPlannedProposalDate", "", "800001", ""), Utility.getDefault(this, vars, "Created", "", "800001", ""), Utility.getDefault(this, vars, "GenerateTo", "", "800001", "N"), Utility.getDefault(this, vars, "CopyFrom", "", "800001", "N"), Utility.getDefault(this, vars, "IsCommitCeiling", "", "800001", "N"), Utility.getDefault(this, vars, "Processing", "", "800001", "N"), Utility.getDefault(this, vars, "Processed", "", "800001", "N"), Utility.getDefault(this, vars, "ProjectBalanceAmt", "", "800001", "0"), Utility.getDefault(this, vars, "InvoicedQty", "", "800001", "0"), Utility.getDefault(this, vars, "C_Phase_ID", "", "800001", ""), Utility.getDefault(this, vars, "IsCommitment", "", "800001", "N"), Utility.getDefault(this, vars, "PlannedQty", "", "800001", "0"), Utility.getDefault(this, vars, "Expreinvoicing", "", "800001", ""));
[javac] ^
[javac] 2 errors