Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005208Openbravo ERP09. Financial managementpublic2008-09-23 17:282008-12-16 12:23
Reporterrafaroda 
Assigned Torafaroda 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005208: 'Tax Report Setup'/'Tax Report' and 'User Defined Accounting Report Setup'/'Accounting Report' fail due to 'sampledata' issue
DescriptionUsing 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 ReproduceA (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 SolutionIt is a 'sampledata' [1] issue.

[1] https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/sampledata/ [^]
Additional Information
TagsNo tags attached.
Relationships
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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-23 17:28rafarodaNew Issue
2008-09-23 17:28rafarodaAssigned To => rafaroda
2008-09-23 17:28rafarodasf_bug_id0 => 2124781
2008-09-23 17:28rafarodaOBNetwork customer => No
2008-09-23 17:28rafarodaRegression testing => No
2008-09-23 17:29rafarodaStatusnew => scheduled
2008-09-23 17:29rafarodafix_in_branch => trunk
2008-09-25 13:18rafarodafix_in_branchtrunk =>
2008-09-25 13:18rafarodaProposed Solution updated
2008-09-25 15:34svnbotCheckin
2008-09-25 15:34svnbotNote Added: 0009200
2008-09-25 15:34svnbotStatusscheduled => resolved
2008-09-25 15:34svnbotResolutionopen => fixed
2008-09-25 15:34svnbotsvn_revision => 7903
2008-12-16 12:23psarobeStatusresolved => closed

Notes
(0009200)
svnbot   
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 [^]