0005208: 'Tax Report Setup'/'Tax Report' and 'User Defined Accounting Report Setup'/'Accounting Report' fail due to 'sampledata' issue

Description

Using BigBazaar client, two report setup windows crash due to 'sampledata' issues. With a fresh installation and a newly created client, there are no problems.

A) 'Tax Report Setup' (trunk) / 'Tax Report' (branches 2.40 and 2.3x) window does not work with error:

A.1) ORACLE
16:07:35 [ajp-8009-1] ERROR org.openbravo.erpWindows.TaxReport.TaxReportData - SQL error in query: INSERT INTO C_TAX_REPORT (AD_Client_ID, AD_Org_ID, IsActive, Name, Description, IsReport, C_Tax_ID, Isshown, IsSummary, IsSOTrx, Isnegative, C_Tax_Report_ID, created, createdby, updated, updatedBy) VALUES (TO_NUMBER(?), TO_NUMBER(?), (?), (?), (?), (?), TO_NUMBER(?), (?), (?), (?), (?), TO_NUMBER(?), now(), to_number(?), now(), to_number(?))Exception:java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "TAD_BRANCH_R240.C_TAX_REPORT_TRG", line 38
ORA-04088: error during execution of trigger 'TAD_BRANCH_R240.C_TAX_REPORT_TRG'

A.2) POSTGRESQL
17:11:51 [ajp-8009-9] ERROR org.openbravo.erpWindows.TaxReport.TaxReportData - SQL error in query: INSERT INTO C_TAX_REPORT (AD_Client_ID, AD_Org_ID, IsActive, Name, Description, IsReport, C_Tax_ID, Isshown, IsSummary, IsSOTrx, Isnegative, C_Tax_Report_ID, created, createdby, updated, updatedBy) VALUES (TO_NUMBER(?), TO_NUMBER(?), (?), (?), (?), (?), TO_NUMBER(?), (?), (?), (?), (?), TO_NUMBER(?), now(), to_number(?), now(), to_number(?))Exception:org.postgresql.util.PSQLException: ERROR: null value in column "ad_tree_id" violates not-null constraint

B) 'User Defined Accounting Report Setup'(trunk) / 'Accounting Report' (branches 2.40 and 2.3x) window does not work with error:

B.1) ORACLE
17:05:15 [ajp-8009-9] ERROR org.openbravo.erpWindows.AccountingReport.AccountingReportData - SQL error in query: INSERT INTO AD_AccountingRpt_Element (AD_Client_ID, AD_Org_ID, Name, Description, IsActive, IsReport, Isshown, IsSummary, Report_Type, Account_ID, C_AcctSchema_ID, TemporaryFilterType, Filteredbyorganization, AD_Accountingrpt_Element_ID, created, createdby, updated, updatedBy) VALUES (TO_NUMBER(?), TO_NUMBER(?), (?), (?), (?), (?), (?), (?), (?), TO_NUMBER(?), TO_NUMBER(?), (?), (?), TO_NUMBER(?), now(), to_number(?), now(), to_number(?))Exception:java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "TAD_BRANCH_R240.AD_ACCOUNTINGRPT_ELEMENT_TRG", line 38
ORA-04088: error during execution of trigger 'TAD_BRANCH_R240.AD_ACCOUNTINGRPT_ELEMENT_TRG'

B.2) POSTGRESQL
17:07:28 [ajp-8009-2] ERROR org.openbravo.erpWindows.AccountingReport.AccountingReportData - SQL error in query: INSERT INTO AD_AccountingRpt_Element (AD_Client_ID, AD_Org_ID, Name, Description, IsActive, IsReport, Isshown, IsSummary, Report_Type, Account_ID, C_AcctSchema_ID, TemporaryFilterType, Filteredbyorganization, AD_Accountingrpt_Element_ID, created, createdby, updated, updatedBy) VALUES (TO_NUMBER(?), TO_NUMBER(?), (?), (?), (?), (?), (?), (?), (?), TO_NUMBER(?), TO_NUMBER(?), (?), (?), TO_NUMBER(?), now(), to_number(?), now(), to_number(?))Exception:org.postgresql.util.PSQLException: ERROR: null value in column "ad_tree_id" violates not-null constraint

Steps To Reproduce

A (trunk) Go to 'Financial Management || Accounting || Analysis Tools || Tax Report Setup'
A (branches 2.40 and 2.3x) Go to 'Financial Management || Accounting || Analysis Tools || Tax Report'

B (trunk) Go to 'Financial Management || Accounting || Analysis Tools || User Defined Accounting Report Setup'
B (branches 2.40 and 2.3x) Go to 'Financial Management || Accounting || Analysis Tools || Accounting Report'

Proposed Solution

It is a 'sampledata' [1] issue.

[1] https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/sampledata/ [^]

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on	backport	0005209		closed	rafaroda	'Tax Report Setup'/'Tax Report' and 'User Defined Accounting Report Setup'/'Accounting Report' fail due to 'sampledata' issue
depends on	backport	0005210		closed	rafaroda	'Tax Report Setup'/'Tax Report' and 'User Defined Accounting Report Setup'/'Accounting Report' fail due to 'sampledata' issue

Notes
(0009200) svnbot (reporter) 2008-09-25 15:34	Repository: openbravo Revision: 7903 Author: rafaroda Date: 2008-09-25 15:34:11 +0200 (Thu, 25 Sep 2008) Fixes bug 0005208 Added new sampledata inside AD_TREE and AD_TREENODE tables for BigBazaar. --- U trunk/src-db/database/sampledata/AD_TREE.xml U trunk/src-db/database/sampledata/AD_TREENODE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=7903&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2008-09-23 17:28	rafaroda	New Issue
2008-09-23 17:28	rafaroda	Assigned To	=> rafaroda
2008-09-23 17:28	rafaroda	sf_bug_id	0 => 2124781
2008-09-23 17:28	rafaroda	Regression testing	=> No
2008-09-23 17:29	rafaroda	Status	new => scheduled
2008-09-23 17:29	rafaroda	fix_in_branch	=> trunk
2008-09-25 13:18	rafaroda	fix_in_branch	trunk =>
2008-09-25 13:18	rafaroda	Proposed Solution updated
2008-09-25 15:34	svnbot	Checkin
2008-09-25 15:34	svnbot	Note Added: 0009200
2008-09-25 15:34	svnbot	Status	scheduled => resolved
2008-09-25 15:34	svnbot	Resolution	open => fixed
2008-09-25 15:34	svnbot	svn_revision	=> 7903
2008-12-16 12:23	psarobe	Status	resolved => closed