buildAD: [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] 28 [main] INFO org.openbravo.data.Sqlc - Driver loaded [java] 228 [main] INFO org.openbravo.data.Sqlc - connect made [java] 243 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/MultiphaseProject/ProjectTask_data.xsql processed [java] 438 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/MultiphaseProject/ProjectPhase_data.xsql processed [java] 474 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/MultiphaseProject/Project_data.xsql processed [java] 556 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/ProjectType/StandardTask_data.xsql processed [java] 582 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/ProjectType/ProjectType_data.xsql processed [java] 596 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/ProjectType/StandardPhase_data.xsql processed [java] 624 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/WithoutProject/WithoutProject_data.xsql processed [java] 661 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/ConstructionProject/ConstructionSite_data.xsql processed [java] 676 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: [java] SELECT C_Project.VC_Certificationpercent , [java] C_Project.VC_Certificationtax , [java] (CASE WHEN C_Project.VC_Certificationtax IS NULL THEN '' ELSE ( TO_CHAR((CASE WHEN tableTRL1.Name IS NULL THEN TO_CHAR(table1.Name) ELSE TO_CHAR(tableTRL1.Name) END)) ) END) AS VC_Certificationtax R, [java] COALESCE(C_Project.VC_Certificationretention , 'N') AS VC_Certificationretention , [java] C_Project.AD_Client_ID, [java] (CASE WHEN C_Project.AD_Client_ID IS NULL THEN '' ELSE (TO_CHAR(table2.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(table3.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] java.sql.SQLException: ORA-00923: palabra clave FROM no encontrada donde se esperaba [java] C_Project.Note, [java] [java] C_Project.Projectstatus, [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] (CASE WHEN C_Project.Projectstatus IS NULL THEN '' ELSE ( TO_CHAR(list1.name) ) END) AS ProjectstatusR, [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] C_Project.Projectphase, [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] (CASE WHEN C_Project.Projectphase IS NULL THEN '' ELSE ( TO_CHAR(list2.name) ) END) AS ProjectphaseR, [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213) [java] C_Project.Projectkind, [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796) [java] (CASE WHEN C_Project.Projectkind IS NULL THEN '' ELSE ( TO_CHAR(list3.name) ) END) AS ProjectkindR, [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031) [java] C_Project.Publicprivate, [java] at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836) [java] (CASE WHEN C_Project.Publicprivate IS NULL THEN '' ELSE ( TO_CHAR(list4.name) ) END) AS PublicprivateR, [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124) [java] C_Project.C_Location_ID, [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285) [java] (CASE WHEN C_Project.C_Location_ID IS NULL THEN '' ELSE (TO_CHAR(table4.Address1) || ' - ' || TO_CHAR(table4.Address2) || ' - ' || TO_CHAR(table4.Postal) || ' - ' || TO_CHAR(table4.City) || ' - ' || TO_CHAR(table5.Name) || ' - ' || TO_CHAR((CASE WHEN tableTRL6.Name IS NULL THEN TO_CHAR(table6.Name) ELSE TO_CHAR(tableTRL6.Name) END)) ) END) AS C_Location_IDR, [java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329) [java] C_Project.SalesRep_ID, [java] at org.openbravo.data.Sqlc.query(Unknown Source) [java] at org.openbravo.data.Sqlc.endElement(Unknown Source) [java] (CASE WHEN C_Project.SalesRep_ID IS NULL THEN '' ELSE ( TO_CHAR(table7.Name) ) END) AS SalesRep_IDR, [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) [java] C_Project.C_BPartner_ID, [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) [java] (CASE WHEN C_Project.C_BPartner_ID IS NULL THEN '' ELSE (TO_CHAR(table8.Name) ) END) AS C_BPartner_IDR, [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) [java] C_Project.C_BPartner_Location_ID, [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) [java] (CASE WHEN C_Project.C_BPartner_Location_ID IS NULL THEN '' ELSE (TO_CHAR(table9.Name) ) END) AS C_BPartner_Location_IDR, [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) [java] C_Project.AD_User_ID, [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) [java] (CASE WHEN C_Project.AD_User_ID IS NULL THEN '' ELSE (TO_CHAR(table10.Name) ) END) AS AD_User_IDR, [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) [java] C_Project.BillTo_ID, [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) [java] (CASE WHEN C_Project.BillTo_ID IS NULL THEN '' ELSE ( TO_CHAR(table11.Name) ) END) AS BillTo_IDR, [java] at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source) [java] COALESCE(C_Project.Invoice_ToProject, 'N') AS Invoice_ToProject, [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] C_Project.M_PriceList_ID, [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] (CASE WHEN C_Project.M_PriceList_ID IS NULL THEN '' ELSE (TO_CHAR(table12.Name) ) END) AS M_PriceList_IDR, [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] C_Project.C_Currency_ID, [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] (CASE WHEN C_Project.C_Currency_ID IS NULL THEN '' ELSE (TO_CHAR(table13.ISO_Code) ) END) AS C_Currency_IDR, [java] at org.openbravo.data.Sqlc.main(Unknown Source) [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 tableTRL14.Name IS NULL THEN TO_CHAR(table14.Name) ELSE TO_CHAR(tableTRL14.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(table15.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(table16.Name) ) END) AS VC_ConstructorR, [java] C_Project.VC_Promoter, [java] (CASE WHEN C_Project.VC_Promoter IS NULL THEN '' ELSE (TO_CHAR(table17.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(table18.Name) ) END) AS VC_Head1R, [java] C_Project.VC_Head2, [java] (CASE WHEN C_Project.VC_Head2 IS NULL THEN '' ELSE (TO_CHAR(table19.Name) ) END) AS VC_Head2R, [java] C_Project.VC_Architect1, [java] (CASE WHEN C_Project.VC_Architect1 IS NULL THEN '' ELSE (TO_CHAR(table20.Name) ) END) AS VC_Architect1R, [java] C_Project.VC_Architect2, [java] (CASE WHEN C_Project.VC_Architect2 IS NULL THEN '' ELSE (TO_CHAR(table21.Name) ) END) AS VC_Architect2R, [java] C_Project.VC_Technicianarchitect1, [java] (CASE WHEN C_Project.VC_Technicianarchitect1 IS NULL THEN '' ELSE (TO_CHAR(table22.Name) ) END) AS VC_Technicianarchitect1R, [java] C_Project.VC_Technicianarchitect2, [java] (CASE WHEN C_Project.VC_Technicianarchitect2 IS NULL THEN '' ELSE (TO_CHAR(table23.Name) ) END) AS VC_Technicianarchitect2R, [java] C_Project.VC_Ssauthor, [java] (CASE WHEN C_Project.VC_Ssauthor IS NULL THEN '' ELSE (TO_CHAR(table24.Name) ) END) AS VC_SsauthorR, [java] C_Project.VC_Sscoordinator, [java] (CASE WHEN C_Project.VC_Sscoordinator IS NULL THEN '' ELSE (TO_CHAR(table25.Name) ) END) AS VC_SscoordinatorR, [java] C_Project.VC_Ssasistcentre, [java] (CASE WHEN C_Project.VC_Ssasistcentre IS NULL THEN '' ELSE (TO_CHAR(table26.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 C_Tax_ID, Name from C_Tax) table1 on (C_Project.VC_Certificationtax = table1.C_Tax_ID) left join (select C_Tax_ID,AD_Language, Name from C_Tax_TRL) tableTRL1 on (table1.C_Tax_ID = tableTRL1.C_Tax_ID and tableTRL1.AD_Language = ?) left join (select AD_Client_ID, Name from AD_Client) table2 on (C_Project.AD_Client_ID = table2.AD_Client_ID) left join (select AD_Org_ID, Name from AD_Org) table3 on (C_Project.AD_Org_ID = table3.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) table4 on (C_Project.C_Location_ID = table4.C_Location_ID) left join (select C_Region_ID, Name from C_Region) table5 on (table4.C_Region_ID = table5.C_Region_ID) left join (select C_Country_ID, Name from C_Country) table6 on (table4.C_Country_ID = table6.C_Country_ID) left join (select C_Country_ID,AD_Language, Name from C_Country_TRL) tableTRL6 on (table6.C_Country_ID = tableTRL6.C_Country_ID and tableTRL6.AD_Language = ?) left join (select AD_User_ID, Name from AD_User) table7 on (C_Project.SalesRep_ID = table7.AD_User_ID) left join (select C_BPartner_ID, Name from C_BPartner) table8 on (C_Project.C_BPartner_ID = table8.C_BPartner_ID) left join (select C_BPartner_Location_ID, Name from C_BPartner_Location) table9 on (C_Project.C_BPartner_Location_ID = table9.C_BPartner_Location_ID) left join (select AD_User_ID, Name from AD_User) table10 on (C_Project.AD_User_ID = table10.AD_User_ID) left join (select C_BPartner_Location_ID, Name from C_BPartner_Location) table11 on (C_Project.BillTo_ID = table11.C_BPartner_Location_ID) left join (select M_PriceList_ID, Name from M_PriceList) table12 on (C_Project.M_PriceList_ID = table12.M_PriceList_ID) left join (select C_Currency_ID, ISO_Code from C_Currency) table13 on (C_Project.C_Currency_ID = table13.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) table14 on (C_Project.C_PaymentTerm_ID = table14.C_PaymentTerm_ID) left join (select C_PaymentTerm_ID,AD_Language, Name from C_PaymentTerm_TRL) tableTRL14 on (table14.C_PaymentTerm_ID = tableTRL14.C_PaymentTerm_ID and tableTRL14.AD_Language = ?) left join (select M_Warehouse_ID, Name from M_Warehouse) table15 on (C_Project.M_Warehouse_ID = table15.M_Warehouse_ID) left join (select C_BPartner_ID, Name from C_BPartner) table16 on (C_Project.VC_Constructor = table16.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table17 on (C_Project.VC_Promoter = table17.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table18 on (C_Project.VC_Head1 = table18.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table19 on (C_Project.VC_Head2 = table19.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table20 on (C_Project.VC_Architect1 = table20.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table21 on (C_Project.VC_Architect2 = table21.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table22 on (C_Project.VC_Technicianarchitect1 = table22.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table23 on (C_Project.VC_Technicianarchitect2 = table23.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table24 on (C_Project.VC_Ssauthor = table24.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table25 on (C_Project.VC_Sscoordinator = table25.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table26 on (C_Project.VC_Ssasistcentre = table26.C_BPartner_ID) [java] WHERE 2=2 [java] AND 1=1 [java] AND C_Project.AD_Client_ID IN ('1') [java] AND C_Project.AD_Org_ID IN ('1') [java] [java] ORDER BY 1, 1 [java] [java] Exception:java.sql.SQLException: ORA-00923: palabra clave FROM no encontrada donde se esperaba [java] [java] 694 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado [java] 694 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado [java] 697 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado [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.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] 700 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado [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] 709 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: [java] java.sql.SQLException: ORA-00923: palabra clave FROM no encontrada donde se esperaba [java] SELECT C_Project.VC_Certificationpercent , [java] [java] C_Project.VC_Certificationtax , [java] (CASE WHEN C_Project.VC_Certificationtax IS NULL THEN '' ELSE ( TO_CHAR((CASE WHEN tableTRL1.Name IS NULL THEN TO_CHAR(table1.Name) ELSE TO_CHAR(tableTRL1.Name) END)) ) END) AS VC_Certificationtax R, [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] COALESCE(C_Project.VC_Certificationretention , 'N') AS VC_Certificationretention , [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) [java] C_Project.AD_Client_ID, [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) [java] (CASE WHEN C_Project.AD_Client_ID IS NULL THEN '' ELSE (TO_CHAR(table2.Name) ) END) AS AD_Client_IDR, [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) [java] C_Project.AD_Org_ID, [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213) [java] (CASE WHEN C_Project.AD_Org_ID IS NULL THEN '' ELSE (TO_CHAR(table3.Name) ) END) AS AD_Org_IDR, [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796) [java] C_Project.Value, [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031) [java] C_Project.Name, [java] at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836) [java] COALESCE(C_Project.IsActive, 'N') AS IsActive, [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124) [java] C_Project.Description, [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285) [java] C_Project.Note, [java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329) [java] C_Project.Projectstatus, [java] at org.openbravo.data.Sqlc.query(Unknown Source) [java] (CASE WHEN C_Project.Projectstatus IS NULL THEN '' ELSE ( TO_CHAR(list1.name) ) END) AS ProjectstatusR, [java] at org.openbravo.data.Sqlc.endElement(Unknown Source) [java] C_Project.Projectphase, [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) [java] (CASE WHEN C_Project.Projectphase IS NULL THEN '' ELSE ( TO_CHAR(list2.name) ) END) AS ProjectphaseR, [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) [java] C_Project.Projectkind, [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(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.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) [java] C_Project.Publicprivate, [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) [java] (CASE WHEN C_Project.Publicprivate IS NULL THEN '' ELSE ( TO_CHAR(list4.name) ) END) AS PublicprivateR, [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) [java] C_Project.C_Location_ID, [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) [java] (CASE WHEN C_Project.C_Location_ID IS NULL THEN '' ELSE (TO_CHAR(table4.Address1) || ' - ' || TO_CHAR(table4.Address2) || ' - ' || TO_CHAR(table4.Postal) || ' - ' || TO_CHAR(table4.City) || ' - ' || TO_CHAR(table5.Name) || ' - ' || TO_CHAR((CASE WHEN tableTRL6.Name IS NULL THEN TO_CHAR(table6.Name) ELSE TO_CHAR(tableTRL6.Name) END)) ) END) AS C_Location_IDR, [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) [java] C_Project.SalesRep_ID, [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.printKeySequenceSql(Unknown Source) [java] (CASE WHEN C_Project.SalesRep_ID IS NULL THEN '' ELSE ( TO_CHAR(table7.Name) ) END) AS SalesRep_IDR, [java] at org.openbravo.data.Sqlc.printFunctionSql(Unknown Source) [java] C_Project.C_BPartner_ID, [java] at org.openbravo.data.Sqlc.endElement(Unknown Source) [java] (CASE WHEN C_Project.C_BPartner_ID IS NULL THEN '' ELSE (TO_CHAR(table8.Name) ) END) AS C_BPartner_IDR, [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) [java] C_Project.C_BPartner_Location_ID, [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) [java] (CASE WHEN C_Project.C_BPartner_Location_ID IS NULL THEN '' ELSE (TO_CHAR(table9.Name) ) END) AS C_BPartner_Location_IDR, [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) [java] C_Project.AD_User_ID, [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) [java] (CASE WHEN C_Project.AD_User_ID IS NULL THEN '' ELSE (TO_CHAR(table10.Name) ) END) AS AD_User_IDR, [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) [java] C_Project.BillTo_ID, [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) [java] (CASE WHEN C_Project.BillTo_ID IS NULL THEN '' ELSE ( TO_CHAR(table11.Name) ) END) AS BillTo_IDR, [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) [java] COALESCE(C_Project.Invoice_ToProject, 'N') AS Invoice_ToProject, [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) [java] at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source) [java] C_Project.M_PriceList_ID, [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] (CASE WHEN C_Project.M_PriceList_ID IS NULL THEN '' ELSE (TO_CHAR(table12.Name) ) END) AS M_PriceList_IDR, [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] C_Project.C_Currency_ID, [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.main(Unknown Source) [java] (CASE WHEN C_Project.C_Currency_ID IS NULL THEN '' ELSE (TO_CHAR(table13.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 tableTRL14.Name IS NULL THEN TO_CHAR(table14.Name) ELSE TO_CHAR(tableTRL14.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(table15.Name) ) END) AS M_Warehouse_IDR, [java] java.sql.SQLException: manejador de sentencias no ejecutado [java] C_Project.DateContract, [java] C_Project.DateFinish, [java] C_Project.PlannedAmt, [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) [java] C_Project.InvoicedAmt, [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) [java] C_Project.ChangeProjectStatus, [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) [java] C_Project.GenerateOrder, [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] C_Project.VC_Constructor, [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) [java] (CASE WHEN C_Project.VC_Constructor IS NULL THEN '' ELSE (TO_CHAR(table16.Name) ) END) AS VC_ConstructorR, [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) [java] C_Project.VC_Promoter, [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) [java] (CASE WHEN C_Project.VC_Promoter IS NULL THEN '' ELSE (TO_CHAR(table17.Name) ) END) AS VC_PromoterR, [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) [java] C_Project.VC_Datebudget, [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) [java] C_Project.VC_Datelicitation, [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) [java] C_Project.VC_Dateawarding, [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) [java] C_Project.VC_Datecontract, [java] at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source) [java] C_Project.VC_Datelicence, [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] C_Project.VC_Datefirstocupation, [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] C_Project.VC_Dateplanedstart, [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] C_Project.VC_Dateplanedend, [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] C_Project.VC_Daterealstart, [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.main(Unknown Source) [java] C_Project.VC_Daterealend, [java] C_Project.VC_Head1, [java] (CASE WHEN C_Project.VC_Head1 IS NULL THEN '' ELSE (TO_CHAR(table18.Name) ) END) AS VC_Head1R, [java] C_Project.VC_Head2, [java] (CASE WHEN C_Project.VC_Head2 IS NULL THEN '' ELSE (TO_CHAR(table19.Name) ) END) AS VC_Head2R, [java] C_Project.VC_Architect1, [java] (CASE WHEN C_Project.VC_Architect1 IS NULL THEN '' ELSE (TO_CHAR(table20.Name) ) END) AS VC_Architect1R, [java] C_Project.VC_Architect2, [java] (CASE WHEN C_Project.VC_Architect2 IS NULL THEN '' ELSE (TO_CHAR(table21.Name) ) END) AS VC_Architect2R, [java] C_Project.VC_Technicianarchitect1, [java] (CASE WHEN C_Project.VC_Technicianarchitect1 IS NULL THEN '' ELSE (TO_CHAR(table22.Name) ) END) AS VC_Technicianarchitect1R, [java] C_Project.VC_Technicianarchitect2, [java] (CASE WHEN C_Project.VC_Technicianarchitect2 IS NULL THEN '' ELSE (TO_CHAR(table23.Name) ) END) AS VC_Technicianarchitect2R, [java] C_Project.VC_Ssauthor, [java] (CASE WHEN C_Project.VC_Ssauthor IS NULL THEN '' ELSE (TO_CHAR(table24.Name) ) END) AS VC_SsauthorR, [java] C_Project.VC_Sscoordinator, [java] (CASE WHEN C_Project.VC_Sscoordinator IS NULL THEN '' ELSE (TO_CHAR(table25.Name) ) END) AS VC_SscoordinatorR, [java] C_Project.VC_Ssasistcentre, [java] (CASE WHEN C_Project.VC_Ssasistcentre IS NULL THEN '' ELSE (TO_CHAR(table26.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] C_Project.Created, [java] C_Project.CreatedBy, [java] C_Project.Updated, [java] C_Project.UpdatedBy, ? AS LANGUAGE [java] FROM C_Project left join (select C_Tax_ID, Name from C_Tax) table1 on (C_Project.VC_Certificationtax = table1.C_Tax_ID) left join (select C_Tax_ID,AD_Language, Name from C_Tax_TRL) tableTRL1 on (table1.C_Tax_ID = tableTRL1.C_Tax_ID and tableTRL1.AD_Language = ?) left join (select AD_Client_ID, Name from AD_Client) table2 on (C_Project.AD_Client_ID = table2.AD_Client_ID) left join (select AD_Org_ID, Name from AD_Org) table3 on (C_Project.AD_Org_ID = table3.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) table4 on (C_Project.C_Location_ID = table4.C_Location_ID) left join (select C_Region_ID, Name from C_Region) table5 on (table4.C_Region_ID = table5.C_Region_ID) left join (select C_Country_ID, Name from C_Country) table6 on (table4.C_Country_ID = table6.C_Country_ID) left join (select C_Country_ID,AD_Language, Name from C_Country_TRL) tableTRL6 on (table6.C_Country_ID = tableTRL6.C_Country_ID and tableTRL6.AD_Language = ?) left join (select AD_User_ID, Name from AD_User) table7 on (C_Project.SalesRep_ID = table7.AD_User_ID) left join (select C_BPartner_ID, Name from C_BPartner) table8 on (C_Project.C_BPartner_ID = table8.C_BPartner_ID) left join (select C_BPartner_Location_ID, Name from C_BPartner_Location) table9 on (C_Project.C_BPartner_Location_ID = table9.C_BPartner_Location_ID) left join (select AD_User_ID, Name from AD_User) table10 on (C_Project.AD_User_ID = table10.AD_User_ID) left join (select C_BPartner_Location_ID, Name from C_BPartner_Location) table11 on (C_Project.BillTo_ID = table11.C_BPartner_Location_ID) left join (select M_PriceList_ID, Name from M_PriceList) table12 on (C_Project.M_PriceList_ID = table12.M_PriceList_ID) left join (select C_Currency_ID, ISO_Code from C_Currency) table13 on (C_Project.C_Currency_ID = table13.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) table14 on (C_Project.C_PaymentTerm_ID = table14.C_PaymentTerm_ID) left join (select C_PaymentTerm_ID,AD_Language, Name from C_PaymentTerm_TRL) tableTRL14 on (table14.C_PaymentTerm_ID = tableTRL14.C_PaymentTerm_ID and tableTRL14.AD_Language = ?) left join (select M_Warehouse_ID, Name from M_Warehouse) table15 on (C_Project.M_Warehouse_ID = table15.M_Warehouse_ID) left join (select C_BPartner_ID, Name from C_BPartner) table16 on (C_Project.VC_Constructor = table16.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table17 on (C_Project.VC_Promoter = table17.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table18 on (C_Project.VC_Head1 = table18.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table19 on (C_Project.VC_Head2 = table19.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table20 on (C_Project.VC_Architect1 = table20.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table21 on (C_Project.VC_Architect2 = table21.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table22 on (C_Project.VC_Technicianarchitect1 = table22.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table23 on (C_Project.VC_Technicianarchitect2 = table23.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table24 on (C_Project.VC_Ssauthor = table24.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table25 on (C_Project.VC_Sscoordinator = table25.C_BPartner_ID) left join (select C_BPartner_ID, Name from C_BPartner) table26 on (C_Project.VC_Ssasistcentre = table26.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-00923: palabra clave FROM no encontrada donde se esperaba [java] [java] 713 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado [java] 717 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLException: manejador de sentencias no ejecutado [java] 723 [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.vcCertificationtax = vars.getStringParameter("inpvcCertificationtax "); data.vcCertificationtax r = vars.getStringParameter("inpvcCertificationtax _R"); data.vcCertificationretention = vars.getStringParameter("inpvcCertificationretention ", "N"); 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:436: cannot find symbol [javac] symbol : variable vcCertificationtax [javac] location: class org.openbravo.erpWindows.ConstructionProject.ConstructionSiteData [javac] data.vcCertificationpercent = vars.getStringParameter("inpvcCertificationpercent "); data.vcCertificationtax = vars.getStringParameter("inpvcCertificationtax "); data.vcCertificationtax r = vars.getStringParameter("inpvcCertificationtax _R"); data.vcCertificationretention = vars.getStringParameter("inpvcCertificationretention ", "N"); 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:436: package data does not exist [javac] data.vcCertificationpercent = vars.getStringParameter("inpvcCertificationpercent "); data.vcCertificationtax = vars.getStringParameter("inpvcCertificationtax "); data.vcCertificationtax r = vars.getStringParameter("inpvcCertificationtax _R"); data.vcCertificationretention = vars.getStringParameter("inpvcCertificationretention ", "N"); 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:436: cannot find symbol [javac] symbol : variable vcCertificationretention [javac] location: class org.openbravo.erpWindows.ConstructionProject.ConstructionSiteData [javac] data.vcCertificationpercent = vars.getStringParameter("inpvcCertificationpercent "); data.vcCertificationtax = vars.getStringParameter("inpvcCertificationtax "); data.vcCertificationtax r = vars.getStringParameter("inpvcCertificationtax _R"); data.vcCertificationretention = vars.getStringParameter("inpvcCertificationretention ", "N"); 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:452: cannot find symbol [javac] symbol : variable vcCertificationtax [javac] location: class org.openbravo.erpWindows.ConstructionProject.ConstructionSiteData [javac] for (int i=0;i