I invoked the Trial Balance report in GardenWorld, I got a 4-page report, with only header but no data. Below are the error messages found in "Preference":
-------------------------------
===========> DB.executeUpdate: Update=INSERT INTO T_TrialBalance (AD_PInstance_ID, Fact_Acct_ID, AD_Client_ID, AD_Org_ID, Created,CreatedBy, Updated,UpdatedBy, C_AcctSchema_ID, Account_ID, AccountValue, DateTrx, DateAcct, C_Period_ID, AD_Table_ID, Record_ID, Line_ID, GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType, C_Currency_ID, AmtSourceDr, AmtSourceCr, AmtSourceBalance, AmtAcctDr, AmtAcctCr, AmtAcctBalance, C_UOM_ID, Qty, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID, C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, A_Asset_ID, Description)SELECT 1075955,0,11,11, CURRENT_TIMESTAMP,100,CURRENT_TIMESTAMP,100,101,null,null,null,TO_TIMESTAMP('2006-01-01','YYYY-MM-DD'),1000028,null,null,null,null,null,null,null,'A',null,null,null,null, COALESCE(SUM(AmtAcctDr),0),COALESCE(SUM(AmtAcctCr),0),COALESCE(SUM(AmtAcctDr),0)-COALESCE(SUM(AmtAcctCr),0), null,COALESCE(SUM(Qty),0),null,null,null,null,null,null,null,null,null,null,null, null,null FROM Fact_Acct WHERE AD_Client_ID=11 AND C_AcctSchema_ID=101 AND AD_Org_ID=11 AND PostingType='A' AND DateAcct < TO_TIMESTAMP('2006-01-01','YYYY-MM-DD') [null] [468]
java.sql.SQLException: ERROR: relation "t_trialbalance" does not exist; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282)
at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
at $Proxy3.executeUpdate(Unknown Source)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:157)
at org.compiere.util.DB.executeUpdate(DB.java:691)
at org.compiere.util.DB.executeUpdate(DB.java:645)
at org.compiere.report.TrialBalance.createBalanceLine(TrialBalance.java:398)
at org.compiere.report.TrialBalance.doIt(TrialBalance.java:267)
at org.compiere.process.SvrProcess.process(SvrProcess.java:93)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:77)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:442)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:225)
-------------------------------
===========> DB.saveError: DBExecuteError - ERROR: relation "t_trialbalance" does not exist [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>INSERT INTO T_TrialBalance (AD_PInstance_ID, Fact_Acct_ID, AD_Client_ID, AD_Org_ID, Created,CreatedBy, Updated,UpdatedBy, C_AcctSchema_ID, Account_ID, AccountValue, DateTrx, DateAcct, C_Period_ID, AD_Table_ID, Record_ID, Line_ID, GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType, C_Currency_ID, AmtSourceDr, AmtSourceCr, AmtSourceBalance, AmtAcctDr, AmtAcctCr, AmtAcctBalance, C_UOM_ID, Qty, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID, C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, A_Asset_ID, Description)SELECT 1075955,Fact_Acct_ID,11,AD_Org_ID,Created,CreatedBy, Updated,UpdatedBy,C_AcctSchema_ID, Account_ID, null, DateTrx, DateAcct, C_Period_ID,AD_Table_ID, Record_ID, Line_ID,GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType,C_Currency_ID, AmtSourceDr,AmtSourceCr, AmtSourceDr-AmtSourceCr, AmtAcctDr,AmtAcctCr, AmtAcctDr-AmtAcctCr, C_UOM_ID,Qty,M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID,C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID,User1_ID, User2_ID, A_Asset_ID, Description FROM Fact_Acct WHERE AD_Client_ID=11 AND C_AcctSchema_ID=101 AND AD_Org_ID=11 AND PostingType='A' AND DateAcct >= TO_TIMESTAMP('2006-01-01','YYYY-MM-DD') AND DATE_Trunc('day',DateAcct) <= TO_TIMESTAMP('2006-01-31','YYYY-MM-DD')<= <INSERT INTO T_TrialBalance (AD_PInstance_ID, Fact_Acct_ID, AD_Client_ID, AD_Org_ID, Created,CreatedBy, Updated,UpdatedBy, C_AcctSchema_ID, Account_ID, AccountValue, DateTrx, DateAcct, C_Period_ID, AD_Table_ID, Record_ID, Line_ID, GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType, C_Currency_ID, AmtSourceDr, AmtSourceCr, AmtSourceBalance, AmtAcctDr, AmtAcctCr, AmtAcctBalance, C_UOM_ID, Qty, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID, C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, A_Asset_ID, Description)SELECT 1075955,Fact_Acct_ID,11,AD_Org_ID,Created,CreatedBy, Updated,UpdatedBy,C_AcctSchema_ID, Account_ID, null, DateTrx, DateAcct, C_Period_ID,AD_Table_ID, Record_ID, Line_ID,GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType,C_Currency_ID, AmtSourceDr,AmtSourceCr, AmtSourceDr-AmtSourceCr, AmtAcctDr,AmtAcctCr, AmtAcctDr-AmtAcctCr, C_UOM_ID,Qty,M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID,C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID,User1_ID, User2_ID, A_Asset_ID, Description FROM Fact_Acct WHERE AD_Client_ID=11 AND C_AcctSchema_ID=101 AND AD_Org_ID=11 AND PostingType='A' AND DateAcct >= TO_DATE('2006-01-01','YYYY-MM-DD') AND TRUNC(DateAcct) <= TO_DATE('2006-01-31','YYYY-MM-DD')> [468]
-------------------------------
===========> DB.executeUpdate: Update=INSERT INTO T_TrialBalance (AD_PInstance_ID, Fact_Acct_ID, AD_Client_ID, AD_Org_ID, Created,CreatedBy, Updated,UpdatedBy, C_AcctSchema_ID, Account_ID, AccountValue, DateTrx, DateAcct, C_Period_ID, AD_Table_ID, Record_ID, Line_ID, GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType, C_Currency_ID, AmtSourceDr, AmtSourceCr, AmtSourceBalance, AmtAcctDr, AmtAcctCr, AmtAcctBalance, C_UOM_ID, Qty, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID, C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, A_Asset_ID, Description)SELECT 1075955,Fact_Acct_ID,11,AD_Org_ID,Created,CreatedBy, Updated,UpdatedBy,C_AcctSchema_ID, Account_ID, null, DateTrx, DateAcct, C_Period_ID,AD_Table_ID, Record_ID, Line_ID,GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType,C_Currency_ID, AmtSourceDr,AmtSourceCr, AmtSourceDr-AmtSourceCr, AmtAcctDr,AmtAcctCr, AmtAcctDr-AmtAcctCr, C_UOM_ID,Qty,M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID,C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID,User1_ID, User2_ID, A_Asset_ID, Description FROM Fact_Acct WHERE AD_Client_ID=11 AND C_AcctSchema_ID=101 AND AD_Org_ID=11 AND PostingType='A' AND DateAcct >= TO_TIMESTAMP('2006-01-01','YYYY-MM-DD') AND DATE_Trunc('day',DateAcct) <= TO_TIMESTAMP('2006-01-31','YYYY-MM-DD') [null] [468]
java.sql.SQLException: ERROR: relation "t_trialbalance" does not exist; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282)
at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
at $Proxy3.executeUpdate(Unknown Source)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:157)
at org.compiere.util.DB.executeUpdate(DB.java:691)
at org.compiere.util.DB.executeUpdate(DB.java:645)
at org.compiere.report.TrialBalance.createDetailLines(TrialBalance.java:436)
at org.compiere.report.TrialBalance.doIt(TrialBalance.java:268)
at org.compiere.process.SvrProcess.process(SvrProcess.java:93)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:77)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:442)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:225)
-------------------------------
===========> DB.saveError: DBExecuteError - ERROR: relation "t_trialbalance" does not exist [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>UPDATE T_TrialBalance SET AccountValue = (SELECT Value FROM C_ElementValue ev WHERE ev.C_ElementValue_ID=T_TrialBalance.Account_ID) WHERE T_TrialBalance.Account_ID IS NOT NULL<= <UPDATE T_TrialBalance tb SET AccountValue = (SELECT Value FROM C_ElementValue ev WHERE ev.C_ElementValue_ID=tb.Account_ID) WHERE tb.Account_ID IS NOT NULL> [468]
-------------------------------
===========> DB.executeUpdate: Update=UPDATE T_TrialBalance SET AccountValue = (SELECT Value FROM C_ElementValue ev WHERE ev.C_ElementValue_ID=T_TrialBalance.Account_ID) WHERE T_TrialBalance.Account_ID IS NOT NULL [null] [468]
java.sql.SQLException: ERROR: relation "t_trialbalance" does not exist; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282)
at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
at $Proxy3.executeUpdate(Unknown Source)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:157)
at org.compiere.util.DB.executeUpdate(DB.java:691)
at org.compiere.util.DB.executeUpdate(DB.java:645)
at org.compiere.report.TrialBalance.createDetailLines(TrialBalance.java:445)
at org.compiere.report.TrialBalance.doIt(TrialBalance.java:268)
at org.compiere.process.SvrProcess.process(SvrProcess.java:93)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:77)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:442)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:225)
-------------------------------
===========> DB.saveError: DBExecuteError - ERROR: relation "t_trialbalance" does not exist [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>UPDATE AD_PInstance SET ErrorMsg=NULL, Result=0, IsProcessing='N',Updated=TO_TIMESTAMP('2006-01-26 17:15:53','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_PInstance_ID=1075955<= <UPDATE AD_PInstance SET ErrorMsg=NULL, Result=0, IsProcessing='N',Updated=TO_DATE('2006-01-26 17:15:53','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_PInstance_ID=1075955> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'<= <SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'<= <SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>INSERT INTO AD_ChangeLog (NewValue,AD_Client_ID,CreatedBy,AD_Org_ID,UpdatedBy,AD_Table_ID,IsActive,Updated,AD_ChangeLog_ID,AD_Session_ID,Record_ID,Created,AD_Column_ID,OldValue) VALUES ('66',0,100,0,100,284,'Y',TO_TIMESTAMP('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),1004830,1013427,310,TO_TIMESTAMP('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),6652,'65')<= <INSERT INTO AD_ChangeLog (NewValue,AD_Client_ID,CreatedBy,AD_Org_ID,UpdatedBy,AD_Table_ID,IsActive,Updated,AD_ChangeLog_ID,AD_Session_ID,Record_ID,Created,AD_Column_ID,OldValue) VALUES ('66',0,100,0,100,284,'Y',TO_DATE('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),1004830,1013427,310,TO_DATE('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),6652,'65')> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>INSERT INTO AD_ChangeLog (NewValue,AD_Client_ID,CreatedBy,AD_Org_ID,UpdatedBy,AD_Table_ID,IsActive,Updated,AD_ChangeLog_ID,AD_Session_ID,Record_ID,Created,AD_Column_ID,OldValue) VALUES ('-8084',0,100,0,100,284,'Y',TO_TIMESTAMP('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),1004830,1013427,310,TO_TIMESTAMP('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),6653,'-8157')<= <INSERT INTO AD_ChangeLog (NewValue,AD_Client_ID,CreatedBy,AD_Org_ID,UpdatedBy,AD_Table_ID,IsActive,Updated,AD_ChangeLog_ID,AD_Session_ID,Record_ID,Created,AD_Column_ID,OldValue) VALUES ('-8084',0,100,0,100,284,'Y',TO_DATE('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),1004830,1013427,310,TO_DATE('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),6653,'-8157')> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>UPDATE AD_Process SET Statistic_Count=66, Statistic_Seconds=-8084,Updated=TO_TIMESTAMP('2006-01-26 17:15:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Process_ID=310<= <UPDATE AD_Process SET Statistic_Count=66, Statistic_Seconds=-8084,Updated=TO_DATE('2006-01-26 17:15:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Process_ID=310> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>UPDATE AD_PInstance SET ErrorMsg=NULL, Result=0, IsProcessing='N',Updated=TO_TIMESTAMP('2006-01-26 17:15:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_PInstance_ID=1075955<= <UPDATE AD_PInstance SET ErrorMsg=NULL, Result=0, IsProcessing='N',Updated=TO_DATE('2006-01-26 17:15:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_PInstance_ID=1075955> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'<= <SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'<= <SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'> [468]
-------------------------------
===========> DataEngine.loadPrintData: null - ERROR: relation "t_trialbalance" does not exist
SQL=SELECT A.Value||'-'||A.Name AS AName,T_TrialBalance.Account_ID,T_TrialBalance.DateAcct,T_TrialBalance.AmtAcctBalance,T_TrialBalance.AmtAcctCr,T_TrialBalance.AmtAcctDr,(SELECT C_AcctSchema.Name FROM C_AcctSchema WHERE T_TrialBalance.C_AcctSchema_ID=C_AcctSchema.C_AcctSchema_ID) AS BC_AcctSchema_ID,T_TrialBalance.C_AcctSchema_ID,T_TrialBalance.AccountValue,(SELECT C_Activity.Name FROM C_Activity WHERE T_TrialBalance.C_Activity_ID=C_Activity.C_Activity_ID) AS CC_Activity_ID,T_TrialBalance.C_Activity_ID,(SELECT A_Asset.Name FROM A_Asset WHERE T_TrialBalance.A_Asset_ID=A_Asset.A_Asset_ID) AS DA_Asset_ID,T_TrialBalance.A_Asset_ID,(SELECT GL_Budget.Name FROM GL_Budget WHERE T_TrialBalance.GL_Budget_ID=GL_Budget.GL_Budget_ID) AS EGL_Budget_ID,T_TrialBalance.GL_Budget_ID,(SELECT C_BPartner.Name FROM C_BPartner WHERE T_TrialBalance.C_BPartner_ID=C_BPartner.C_BPartner_ID) AS FC_BPartner_ID,T_TrialBalance.C_BPartner_ID,(SELECT C_Campaign.Name FROM C_Campaign WHERE T_TrialBalance.C_Campaign_ID=C_Campaign.C_Campaign_ID) AS GC_Campaign_ID,T_TrialBalance.C_Campaign_ID,(SELECT C_Currency.ISO_Code FROM C_Currency WHERE T_TrialBalance.C_Currency_ID=C_Currency.C_Currency_ID) AS HC_Currency_ID,T_TrialBalance.C_Currency_ID,T_TrialBalance.Description,(SELECT GL_Category.Name FROM GL_Category WHERE T_TrialBalance.GL_Category_ID=GL_Category.GL_Category_ID) AS IGL_Category_ID,T_TrialBalance.GL_Category_ID,J.City AS JCity,T_TrialBalance.C_LocFrom_ID,K.City AS KCity,T_TrialBalance.C_LocTo_ID,(SELECT M_Locator.Value FROM M_Locator WHERE T_TrialBalance.M_Locator_ID=M_Locator.M_Locator_ID) AS LM_Locator_ID,T_TrialBalance.M_Locator_ID,(SELECT C_Period.Name FROM C_Period WHERE T_TrialBalance.C_Period_ID=C_Period.C_Period_ID) AS MC_Period_ID,T_TrialBalance.C_Period_ID,N.Name AS NName,T_TrialBalance.PostingType,(SELECT AD_PInstance.AD_PInstance_ID||' - '||(SELECT AD_Process.Value FROM AD_Process WHERE AD_PInstance.AD_Process_ID=AD_Process.AD_Process_ID) FROM AD_PInstance WHERE T_TrialBalance.AD_PInstance_ID=AD_PInstance.AD_PInstance_ID) AS OAD_PInstance_ID,T_TrialBalance.AD_PInstance_ID,(SELECT M_Product.Name FROM M_Product WHERE T_TrialBalance.M_Product_ID=M_Product.M_Product_ID) AS PM_Product_ID,T_TrialBalance.M_Product_ID,(SELECT C_Project.Value||' - '||C_Project.Name FROM C_Project WHERE T_TrialBalance.C_Project_ID=C_Project.C_Project_ID) AS QC_Project_ID,T_TrialBalance.C_Project_ID,T_TrialBalance.Qty,(SELECT C_SalesRegion.Name FROM C_SalesRegion WHERE T_TrialBalance.C_SalesRegion_ID=C_SalesRegion.C_SalesRegion_ID) AS RC_SalesRegion_ID,T_TrialBalance.C_SalesRegion_ID,T_TrialBalance.AmtSourceBalance,T_TrialBalance.AmtSourceCr,T_TrialBalance.AmtSourceDr,(SELECT AD_Table.TableName||' - '||AD_Table.Name FROM AD_Table WHERE T_TrialBalance.AD_Table_ID=AD_Table.AD_Table_ID) AS SAD_Table_ID,T_TrialBalance.AD_Table_ID,(SELECT C_Tax.Name FROM C_Tax WHERE T_TrialBalance.C_Tax_ID=C_Tax.C_Tax_ID) AS TC_Tax_ID,T_TrialBalance.C_Tax_ID,T_TrialBalance.DateTrx,U.Value||'-'||U.Name AS UName,T_TrialBalance.AD_OrgTrx_ID,(SELECT C_UOM.Name FROM C_UOM WHERE T_TrialBalance.C_UOM_ID=C_UOM.C_UOM_ID) AS VC_UOM_ID,T_TrialBalance.C_UOM_ID,W.Value||'-'||W.Name AS WName,T_TrialBalance.User1_ID,X.Value||'-'||X.Name AS XName,T_TrialBalance.User2_ID FROM T_TrialBalance LEFT OUTER JOIN C_ElementValue A ON (T_TrialBalance.Account_ID=A.C_ElementValue_ID) LEFT OUTER JOIN C_Location J ON (T_TrialBalance.C_LocFrom_ID=J.C_Location_ID) LEFT OUTER JOIN C_Location K ON (T_TrialBalance.C_LocTo_ID=K.C_Location_ID) INNER JOIN AD_Ref_List N ON (T_TrialBalance.PostingType=N.Value AND N.AD_Reference_ID=125) LEFT OUTER JOIN AD_Org U ON (T_TrialBalance.AD_OrgTrx_ID=U.AD_Org_ID) LEFT OUTER JOIN C_ElementValue W ON (T_TrialBalance.User1_ID=W.C_ElementValue_ID) LEFT OUTER JOIN C_ElementValue X ON (T_TrialBalance.User2_ID=X.C_ElementValue_ID) WHERE T_TrialBalance.AD_PInstance_ID=1075955 AND T_TrialBalance.C_AcctSchema_ID=101.0 AND T_TrialBalance.C_Period_ID=1000028.0 AND T_TrialBalance.AD_Org_ID=11.0 AND T_TrialBalance.PostingType='A' AND T_TrialBalance.AD_Client_ID IN (0,11) [468]
-------------------------------
-----------> DataEngine.loadPrintData: NO Rows - ms=4126 [468]
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.AD_Table_ID, t.TableName, e.PrintName, NULLIF(e.PO_PrintName,e.PrintName) FROM AD_Column c INNER JOIN AD_Column used ON (c.ColumnName=used.ColumnName) INNER JOIN AD_Table t ON (used.AD_Table_ID=t.AD_Table_ID AND t.IsView='N' AND t.AD_Table_ID <> c.AD_Table_ID) INNER JOIN AD_Column cKey ON (t.AD_Table_ID=cKey.AD_Table_ID AND cKey.IsKey='Y') INNER JOIN AD_Element e ON (cKey.ColumnName=e.ColumnName) WHERE c.AD_Table_ID=? AND c.IsKey='Y' ORDER BY 3<= <SELECT t.AD_Table_ID, t.TableName, e.PrintName, NULLIF(e.PO_PrintName,e.PrintName) FROM AD_Column c INNER JOIN AD_Column used ON (c.ColumnName=used.ColumnName) INNER JOIN AD_Table t ON (used.AD_Table_ID=t.AD_Table_ID AND t.IsView='N' AND t.AD_Table_ID <> c.AD_Table_ID) INNER JOIN AD_Column cKey ON (t.AD_Table_ID=cKey.AD_Table_ID AND cKey.IsKey='Y') INNER JOIN AD_Element e ON (cKey.ColumnName=e.ColumnName) WHERE c.AD_Table_ID=? AND c.IsKey='Y' ORDER BY 3> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'<= <SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'>
Please tell me what went wrong. Thanks.
Regards,
Lassen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, maybe you got problems , when you restore your databese, please try to restore it again, or create the table at your actual database, here is the table sql.
CREATE TABLE t_trialbalance
(
ad_pinstance_id numeric(10) NOT NULL,
fact_acct_id numeric(10) NOT NULL,
ad_client_id numeric(10) NOT NULL,
ad_org_id numeric(10),
created date NOT NULL,
createdby numeric(10) NOT NULL,
updated date NOT NULL,
updatedby numeric(10) NOT NULL,
c_acctschema_id numeric(10) NOT NULL,
account_id numeric(10),
datetrx date,
dateacct date NOT NULL,
c_period_id numeric(10),
ad_table_id numeric(10),
record_id numeric(10),
line_id numeric(10),
gl_category_id numeric(10),
gl_budget_id numeric(10),
c_tax_id numeric(10),
m_locator_id numeric(10),
postingtype char(1) NOT NULL,
c_currency_id numeric(10),
amtsourcedr numeric(22),
amtsourcecr numeric(22),
amtsourcebalance numeric(22),
amtacctdr numeric(22) NOT NULL,
amtacctcr numeric(22) NOT NULL,
amtacctbalance numeric(22) NOT NULL,
c_uom_id numeric(10),
qty numeric(22),
m_product_id numeric(10),
c_bpartner_id numeric(10),
ad_orgtrx_id numeric(10),
c_locfrom_id numeric(10),
c_locto_id numeric(10),
c_salesregion_id numeric(10),
c_project_id numeric(10),
c_campaign_id numeric(10),
c_activity_id numeric(10),
user1_id numeric(10),
user2_id numeric(10),
a_asset_id numeric(10),
description varchar(510),
accountvalue varchar(80),
CONSTRAINT t_trialbalance_pkey PRIMARY KEY (ad_pinstance_id, fact_acct_id)
)
WITH OIDS;
ALTER TABLE t_trialbalance OWNER TO compiere;
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I invoked the Trial Balance report in GardenWorld, I got a 4-page report, with only header but no data. Below are the error messages found in "Preference":
-------------------------------
===========> DB.executeUpdate: Update=INSERT INTO T_TrialBalance (AD_PInstance_ID, Fact_Acct_ID, AD_Client_ID, AD_Org_ID, Created,CreatedBy, Updated,UpdatedBy, C_AcctSchema_ID, Account_ID, AccountValue, DateTrx, DateAcct, C_Period_ID, AD_Table_ID, Record_ID, Line_ID, GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType, C_Currency_ID, AmtSourceDr, AmtSourceCr, AmtSourceBalance, AmtAcctDr, AmtAcctCr, AmtAcctBalance, C_UOM_ID, Qty, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID, C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, A_Asset_ID, Description)SELECT 1075955,0,11,11, CURRENT_TIMESTAMP,100,CURRENT_TIMESTAMP,100,101,null,null,null,TO_TIMESTAMP('2006-01-01','YYYY-MM-DD'),1000028,null,null,null,null,null,null,null,'A',null,null,null,null, COALESCE(SUM(AmtAcctDr),0),COALESCE(SUM(AmtAcctCr),0),COALESCE(SUM(AmtAcctDr),0)-COALESCE(SUM(AmtAcctCr),0), null,COALESCE(SUM(Qty),0),null,null,null,null,null,null,null,null,null,null,null, null,null FROM Fact_Acct WHERE AD_Client_ID=11 AND C_AcctSchema_ID=101 AND AD_Org_ID=11 AND PostingType='A' AND DateAcct < TO_TIMESTAMP('2006-01-01','YYYY-MM-DD') [null] [468]
java.sql.SQLException: ERROR: relation "t_trialbalance" does not exist; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282)
at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
at $Proxy3.executeUpdate(Unknown Source)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:157)
at org.compiere.util.DB.executeUpdate(DB.java:691)
at org.compiere.util.DB.executeUpdate(DB.java:645)
at org.compiere.report.TrialBalance.createBalanceLine(TrialBalance.java:398)
at org.compiere.report.TrialBalance.doIt(TrialBalance.java:267)
at org.compiere.process.SvrProcess.process(SvrProcess.java:93)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:77)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:442)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:225)
-------------------------------
===========> DB.saveError: DBExecuteError - ERROR: relation "t_trialbalance" does not exist [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>INSERT INTO T_TrialBalance (AD_PInstance_ID, Fact_Acct_ID, AD_Client_ID, AD_Org_ID, Created,CreatedBy, Updated,UpdatedBy, C_AcctSchema_ID, Account_ID, AccountValue, DateTrx, DateAcct, C_Period_ID, AD_Table_ID, Record_ID, Line_ID, GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType, C_Currency_ID, AmtSourceDr, AmtSourceCr, AmtSourceBalance, AmtAcctDr, AmtAcctCr, AmtAcctBalance, C_UOM_ID, Qty, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID, C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, A_Asset_ID, Description)SELECT 1075955,Fact_Acct_ID,11,AD_Org_ID,Created,CreatedBy, Updated,UpdatedBy,C_AcctSchema_ID, Account_ID, null, DateTrx, DateAcct, C_Period_ID,AD_Table_ID, Record_ID, Line_ID,GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType,C_Currency_ID, AmtSourceDr,AmtSourceCr, AmtSourceDr-AmtSourceCr, AmtAcctDr,AmtAcctCr, AmtAcctDr-AmtAcctCr, C_UOM_ID,Qty,M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID,C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID,User1_ID, User2_ID, A_Asset_ID, Description FROM Fact_Acct WHERE AD_Client_ID=11 AND C_AcctSchema_ID=101 AND AD_Org_ID=11 AND PostingType='A' AND DateAcct >= TO_TIMESTAMP('2006-01-01','YYYY-MM-DD') AND DATE_Trunc('day',DateAcct) <= TO_TIMESTAMP('2006-01-31','YYYY-MM-DD')<= <INSERT INTO T_TrialBalance (AD_PInstance_ID, Fact_Acct_ID, AD_Client_ID, AD_Org_ID, Created,CreatedBy, Updated,UpdatedBy, C_AcctSchema_ID, Account_ID, AccountValue, DateTrx, DateAcct, C_Period_ID, AD_Table_ID, Record_ID, Line_ID, GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType, C_Currency_ID, AmtSourceDr, AmtSourceCr, AmtSourceBalance, AmtAcctDr, AmtAcctCr, AmtAcctBalance, C_UOM_ID, Qty, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID, C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, A_Asset_ID, Description)SELECT 1075955,Fact_Acct_ID,11,AD_Org_ID,Created,CreatedBy, Updated,UpdatedBy,C_AcctSchema_ID, Account_ID, null, DateTrx, DateAcct, C_Period_ID,AD_Table_ID, Record_ID, Line_ID,GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType,C_Currency_ID, AmtSourceDr,AmtSourceCr, AmtSourceDr-AmtSourceCr, AmtAcctDr,AmtAcctCr, AmtAcctDr-AmtAcctCr, C_UOM_ID,Qty,M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID,C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID,User1_ID, User2_ID, A_Asset_ID, Description FROM Fact_Acct WHERE AD_Client_ID=11 AND C_AcctSchema_ID=101 AND AD_Org_ID=11 AND PostingType='A' AND DateAcct >= TO_DATE('2006-01-01','YYYY-MM-DD') AND TRUNC(DateAcct) <= TO_DATE('2006-01-31','YYYY-MM-DD')> [468]
-------------------------------
===========> DB.executeUpdate: Update=INSERT INTO T_TrialBalance (AD_PInstance_ID, Fact_Acct_ID, AD_Client_ID, AD_Org_ID, Created,CreatedBy, Updated,UpdatedBy, C_AcctSchema_ID, Account_ID, AccountValue, DateTrx, DateAcct, C_Period_ID, AD_Table_ID, Record_ID, Line_ID, GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType, C_Currency_ID, AmtSourceDr, AmtSourceCr, AmtSourceBalance, AmtAcctDr, AmtAcctCr, AmtAcctBalance, C_UOM_ID, Qty, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID, C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, A_Asset_ID, Description)SELECT 1075955,Fact_Acct_ID,11,AD_Org_ID,Created,CreatedBy, Updated,UpdatedBy,C_AcctSchema_ID, Account_ID, null, DateTrx, DateAcct, C_Period_ID,AD_Table_ID, Record_ID, Line_ID,GL_Category_ID, GL_Budget_ID, C_Tax_ID, M_Locator_ID, PostingType,C_Currency_ID, AmtSourceDr,AmtSourceCr, AmtSourceDr-AmtSourceCr, AmtAcctDr,AmtAcctCr, AmtAcctDr-AmtAcctCr, C_UOM_ID,Qty,M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID,C_LocTo_ID,C_SalesRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID,User1_ID, User2_ID, A_Asset_ID, Description FROM Fact_Acct WHERE AD_Client_ID=11 AND C_AcctSchema_ID=101 AND AD_Org_ID=11 AND PostingType='A' AND DateAcct >= TO_TIMESTAMP('2006-01-01','YYYY-MM-DD') AND DATE_Trunc('day',DateAcct) <= TO_TIMESTAMP('2006-01-31','YYYY-MM-DD') [null] [468]
java.sql.SQLException: ERROR: relation "t_trialbalance" does not exist; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282)
at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
at $Proxy3.executeUpdate(Unknown Source)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:157)
at org.compiere.util.DB.executeUpdate(DB.java:691)
at org.compiere.util.DB.executeUpdate(DB.java:645)
at org.compiere.report.TrialBalance.createDetailLines(TrialBalance.java:436)
at org.compiere.report.TrialBalance.doIt(TrialBalance.java:268)
at org.compiere.process.SvrProcess.process(SvrProcess.java:93)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:77)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:442)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:225)
-------------------------------
===========> DB.saveError: DBExecuteError - ERROR: relation "t_trialbalance" does not exist [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>UPDATE T_TrialBalance SET AccountValue = (SELECT Value FROM C_ElementValue ev WHERE ev.C_ElementValue_ID=T_TrialBalance.Account_ID) WHERE T_TrialBalance.Account_ID IS NOT NULL<= <UPDATE T_TrialBalance tb SET AccountValue = (SELECT Value FROM C_ElementValue ev WHERE ev.C_ElementValue_ID=tb.Account_ID) WHERE tb.Account_ID IS NOT NULL> [468]
-------------------------------
===========> DB.executeUpdate: Update=UPDATE T_TrialBalance SET AccountValue = (SELECT Value FROM C_ElementValue ev WHERE ev.C_ElementValue_ID=T_TrialBalance.Account_ID) WHERE T_TrialBalance.Account_ID IS NOT NULL [null] [468]
java.sql.SQLException: ERROR: relation "t_trialbalance" does not exist; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282)
at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
at $Proxy3.executeUpdate(Unknown Source)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:157)
at org.compiere.util.DB.executeUpdate(DB.java:691)
at org.compiere.util.DB.executeUpdate(DB.java:645)
at org.compiere.report.TrialBalance.createDetailLines(TrialBalance.java:445)
at org.compiere.report.TrialBalance.doIt(TrialBalance.java:268)
at org.compiere.process.SvrProcess.process(SvrProcess.java:93)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:77)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:442)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:225)
-------------------------------
===========> DB.saveError: DBExecuteError - ERROR: relation "t_trialbalance" does not exist [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>UPDATE AD_PInstance SET ErrorMsg=NULL, Result=0, IsProcessing='N',Updated=TO_TIMESTAMP('2006-01-26 17:15:53','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_PInstance_ID=1075955<= <UPDATE AD_PInstance SET ErrorMsg=NULL, Result=0, IsProcessing='N',Updated=TO_DATE('2006-01-26 17:15:53','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_PInstance_ID=1075955> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'<= <SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'<= <SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>INSERT INTO AD_ChangeLog (NewValue,AD_Client_ID,CreatedBy,AD_Org_ID,UpdatedBy,AD_Table_ID,IsActive,Updated,AD_ChangeLog_ID,AD_Session_ID,Record_ID,Created,AD_Column_ID,OldValue) VALUES ('66',0,100,0,100,284,'Y',TO_TIMESTAMP('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),1004830,1013427,310,TO_TIMESTAMP('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),6652,'65')<= <INSERT INTO AD_ChangeLog (NewValue,AD_Client_ID,CreatedBy,AD_Org_ID,UpdatedBy,AD_Table_ID,IsActive,Updated,AD_ChangeLog_ID,AD_Session_ID,Record_ID,Created,AD_Column_ID,OldValue) VALUES ('66',0,100,0,100,284,'Y',TO_DATE('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),1004830,1013427,310,TO_DATE('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),6652,'65')> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>INSERT INTO AD_ChangeLog (NewValue,AD_Client_ID,CreatedBy,AD_Org_ID,UpdatedBy,AD_Table_ID,IsActive,Updated,AD_ChangeLog_ID,AD_Session_ID,Record_ID,Created,AD_Column_ID,OldValue) VALUES ('-8084',0,100,0,100,284,'Y',TO_TIMESTAMP('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),1004830,1013427,310,TO_TIMESTAMP('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),6653,'-8157')<= <INSERT INTO AD_ChangeLog (NewValue,AD_Client_ID,CreatedBy,AD_Org_ID,UpdatedBy,AD_Table_ID,IsActive,Updated,AD_ChangeLog_ID,AD_Session_ID,Record_ID,Created,AD_Column_ID,OldValue) VALUES ('-8084',0,100,0,100,284,'Y',TO_DATE('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),1004830,1013427,310,TO_DATE('2006-01-26 17:15:54','YYYY-MM-DD HH24:MI:SS'),6653,'-8157')> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>UPDATE AD_Process SET Statistic_Count=66, Statistic_Seconds=-8084,Updated=TO_TIMESTAMP('2006-01-26 17:15:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Process_ID=310<= <UPDATE AD_Process SET Statistic_Count=66, Statistic_Seconds=-8084,Updated=TO_DATE('2006-01-26 17:15:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Process_ID=310> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>UPDATE AD_PInstance SET ErrorMsg=NULL, Result=0, IsProcessing='N',Updated=TO_TIMESTAMP('2006-01-26 17:15:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_PInstance_ID=1075955<= <UPDATE AD_PInstance SET ErrorMsg=NULL, Result=0, IsProcessing='N',Updated=TO_DATE('2006-01-26 17:15:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_PInstance_ID=1075955> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'<= <SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'<= <SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'> [468]
-------------------------------
===========> DataEngine.loadPrintData: null - ERROR: relation "t_trialbalance" does not exist
SQL=SELECT A.Value||'-'||A.Name AS AName,T_TrialBalance.Account_ID,T_TrialBalance.DateAcct,T_TrialBalance.AmtAcctBalance,T_TrialBalance.AmtAcctCr,T_TrialBalance.AmtAcctDr,(SELECT C_AcctSchema.Name FROM C_AcctSchema WHERE T_TrialBalance.C_AcctSchema_ID=C_AcctSchema.C_AcctSchema_ID) AS BC_AcctSchema_ID,T_TrialBalance.C_AcctSchema_ID,T_TrialBalance.AccountValue,(SELECT C_Activity.Name FROM C_Activity WHERE T_TrialBalance.C_Activity_ID=C_Activity.C_Activity_ID) AS CC_Activity_ID,T_TrialBalance.C_Activity_ID,(SELECT A_Asset.Name FROM A_Asset WHERE T_TrialBalance.A_Asset_ID=A_Asset.A_Asset_ID) AS DA_Asset_ID,T_TrialBalance.A_Asset_ID,(SELECT GL_Budget.Name FROM GL_Budget WHERE T_TrialBalance.GL_Budget_ID=GL_Budget.GL_Budget_ID) AS EGL_Budget_ID,T_TrialBalance.GL_Budget_ID,(SELECT C_BPartner.Name FROM C_BPartner WHERE T_TrialBalance.C_BPartner_ID=C_BPartner.C_BPartner_ID) AS FC_BPartner_ID,T_TrialBalance.C_BPartner_ID,(SELECT C_Campaign.Name FROM C_Campaign WHERE T_TrialBalance.C_Campaign_ID=C_Campaign.C_Campaign_ID) AS GC_Campaign_ID,T_TrialBalance.C_Campaign_ID,(SELECT C_Currency.ISO_Code FROM C_Currency WHERE T_TrialBalance.C_Currency_ID=C_Currency.C_Currency_ID) AS HC_Currency_ID,T_TrialBalance.C_Currency_ID,T_TrialBalance.Description,(SELECT GL_Category.Name FROM GL_Category WHERE T_TrialBalance.GL_Category_ID=GL_Category.GL_Category_ID) AS IGL_Category_ID,T_TrialBalance.GL_Category_ID,J.City AS JCity,T_TrialBalance.C_LocFrom_ID,K.City AS KCity,T_TrialBalance.C_LocTo_ID,(SELECT M_Locator.Value FROM M_Locator WHERE T_TrialBalance.M_Locator_ID=M_Locator.M_Locator_ID) AS LM_Locator_ID,T_TrialBalance.M_Locator_ID,(SELECT C_Period.Name FROM C_Period WHERE T_TrialBalance.C_Period_ID=C_Period.C_Period_ID) AS MC_Period_ID,T_TrialBalance.C_Period_ID,N.Name AS NName,T_TrialBalance.PostingType,(SELECT AD_PInstance.AD_PInstance_ID||' - '||(SELECT AD_Process.Value FROM AD_Process WHERE AD_PInstance.AD_Process_ID=AD_Process.AD_Process_ID) FROM AD_PInstance WHERE T_TrialBalance.AD_PInstance_ID=AD_PInstance.AD_PInstance_ID) AS OAD_PInstance_ID,T_TrialBalance.AD_PInstance_ID,(SELECT M_Product.Name FROM M_Product WHERE T_TrialBalance.M_Product_ID=M_Product.M_Product_ID) AS PM_Product_ID,T_TrialBalance.M_Product_ID,(SELECT C_Project.Value||' - '||C_Project.Name FROM C_Project WHERE T_TrialBalance.C_Project_ID=C_Project.C_Project_ID) AS QC_Project_ID,T_TrialBalance.C_Project_ID,T_TrialBalance.Qty,(SELECT C_SalesRegion.Name FROM C_SalesRegion WHERE T_TrialBalance.C_SalesRegion_ID=C_SalesRegion.C_SalesRegion_ID) AS RC_SalesRegion_ID,T_TrialBalance.C_SalesRegion_ID,T_TrialBalance.AmtSourceBalance,T_TrialBalance.AmtSourceCr,T_TrialBalance.AmtSourceDr,(SELECT AD_Table.TableName||' - '||AD_Table.Name FROM AD_Table WHERE T_TrialBalance.AD_Table_ID=AD_Table.AD_Table_ID) AS SAD_Table_ID,T_TrialBalance.AD_Table_ID,(SELECT C_Tax.Name FROM C_Tax WHERE T_TrialBalance.C_Tax_ID=C_Tax.C_Tax_ID) AS TC_Tax_ID,T_TrialBalance.C_Tax_ID,T_TrialBalance.DateTrx,U.Value||'-'||U.Name AS UName,T_TrialBalance.AD_OrgTrx_ID,(SELECT C_UOM.Name FROM C_UOM WHERE T_TrialBalance.C_UOM_ID=C_UOM.C_UOM_ID) AS VC_UOM_ID,T_TrialBalance.C_UOM_ID,W.Value||'-'||W.Name AS WName,T_TrialBalance.User1_ID,X.Value||'-'||X.Name AS XName,T_TrialBalance.User2_ID FROM T_TrialBalance LEFT OUTER JOIN C_ElementValue A ON (T_TrialBalance.Account_ID=A.C_ElementValue_ID) LEFT OUTER JOIN C_Location J ON (T_TrialBalance.C_LocFrom_ID=J.C_Location_ID) LEFT OUTER JOIN C_Location K ON (T_TrialBalance.C_LocTo_ID=K.C_Location_ID) INNER JOIN AD_Ref_List N ON (T_TrialBalance.PostingType=N.Value AND N.AD_Reference_ID=125) LEFT OUTER JOIN AD_Org U ON (T_TrialBalance.AD_OrgTrx_ID=U.AD_Org_ID) LEFT OUTER JOIN C_ElementValue W ON (T_TrialBalance.User1_ID=W.C_ElementValue_ID) LEFT OUTER JOIN C_ElementValue X ON (T_TrialBalance.User2_ID=X.C_ElementValue_ID) WHERE T_TrialBalance.AD_PInstance_ID=1075955 AND T_TrialBalance.C_AcctSchema_ID=101.0 AND T_TrialBalance.C_Period_ID=1000028.0 AND T_TrialBalance.AD_Org_ID=11.0 AND T_TrialBalance.PostingType='A' AND T_TrialBalance.AD_Client_ID IN (0,11) [468]
-------------------------------
-----------> DataEngine.loadPrintData: NO Rows - ms=4126 [468]
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.AD_Table_ID, t.TableName, e.PrintName, NULLIF(e.PO_PrintName,e.PrintName) FROM AD_Column c INNER JOIN AD_Column used ON (c.ColumnName=used.ColumnName) INNER JOIN AD_Table t ON (used.AD_Table_ID=t.AD_Table_ID AND t.IsView='N' AND t.AD_Table_ID <> c.AD_Table_ID) INNER JOIN AD_Column cKey ON (t.AD_Table_ID=cKey.AD_Table_ID AND cKey.IsKey='Y') INNER JOIN AD_Element e ON (cKey.ColumnName=e.ColumnName) WHERE c.AD_Table_ID=? AND c.IsKey='Y' ORDER BY 3<= <SELECT t.AD_Table_ID, t.TableName, e.PrintName, NULLIF(e.PO_PrintName,e.PrintName) FROM AD_Column c INNER JOIN AD_Column used ON (c.ColumnName=used.ColumnName) INNER JOIN AD_Table t ON (used.AD_Table_ID=t.AD_Table_ID AND t.IsView='N' AND t.AD_Table_ID <> c.AD_Table_ID) INNER JOIN AD_Column cKey ON (t.AD_Table_ID=cKey.AD_Table_ID AND cKey.IsKey='Y') INNER JOIN AD_Element e ON (cKey.ColumnName=e.ColumnName) WHERE c.AD_Table_ID=? AND c.IsKey='Y' ORDER BY 3> [468]
-------------------------------
===========> DB_PostgreSQL.convertStatement: PostgreSQL =>SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'<= <SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'>
Please tell me what went wrong. Thanks.
Regards,
Lassen
Hi, maybe you got problems , when you restore your databese, please try to restore it again, or create the table at your actual database, here is the table sql.
CREATE TABLE t_trialbalance
(
ad_pinstance_id numeric(10) NOT NULL,
fact_acct_id numeric(10) NOT NULL,
ad_client_id numeric(10) NOT NULL,
ad_org_id numeric(10),
created date NOT NULL,
createdby numeric(10) NOT NULL,
updated date NOT NULL,
updatedby numeric(10) NOT NULL,
c_acctschema_id numeric(10) NOT NULL,
account_id numeric(10),
datetrx date,
dateacct date NOT NULL,
c_period_id numeric(10),
ad_table_id numeric(10),
record_id numeric(10),
line_id numeric(10),
gl_category_id numeric(10),
gl_budget_id numeric(10),
c_tax_id numeric(10),
m_locator_id numeric(10),
postingtype char(1) NOT NULL,
c_currency_id numeric(10),
amtsourcedr numeric(22),
amtsourcecr numeric(22),
amtsourcebalance numeric(22),
amtacctdr numeric(22) NOT NULL,
amtacctcr numeric(22) NOT NULL,
amtacctbalance numeric(22) NOT NULL,
c_uom_id numeric(10),
qty numeric(22),
m_product_id numeric(10),
c_bpartner_id numeric(10),
ad_orgtrx_id numeric(10),
c_locfrom_id numeric(10),
c_locto_id numeric(10),
c_salesregion_id numeric(10),
c_project_id numeric(10),
c_campaign_id numeric(10),
c_activity_id numeric(10),
user1_id numeric(10),
user2_id numeric(10),
a_asset_id numeric(10),
description varchar(510),
accountvalue varchar(80),
CONSTRAINT t_trialbalance_pkey PRIMARY KEY (ad_pinstance_id, fact_acct_id)
)
WITH OIDS;
ALTER TABLE t_trialbalance OWNER TO compiere;