Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005209Openbravo ERP09. Financial managementpublic2008-09-23 17:292008-12-11 14:09
Reporterrafaroda 
Assigned Torafaroda 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005209: '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
blocks defect 0005208 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:29rafarodaNew Issue
2008-09-23 17:29rafarodaAssigned To => rafaroda
2008-09-23 17:29rafarodaStatusnew => scheduled
2008-09-25 13:18rafarodaDescription Updated
2008-09-25 13:18rafarodaProposed Solution updated
2008-09-25 15:19svnbotCheckin
2008-09-25 15:19svnbotNote Added: 0009199
2008-09-25 15:19svnbotStatusscheduled => resolved
2008-09-25 15:19svnbotResolutionopen => fixed
2008-09-25 15:19svnbotsvn_revision => 7901
2008-12-11 14:09psarobeRegression testing => No
2008-12-11 14:09psarobeStatusresolved => closed

Notes
(0009199)
svnbot   
2008-09-25 15:19   
Repository: openbravo
Revision: 7901
Author: rafaroda
Date: 2008-09-25 15:19:03 +0200 (Thu, 25 Sep 2008)

Fixes bug 0005209 Added new sampledata inside AD_TREE and AD_TREENODE tables for BigBazaar.

---
U branches/r2.40/src-db/database/sampledata/AD_TREE.xml
U branches/r2.40/src-db/database/sampledata/AD_TREENODE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=7901&sc=1 [^]