Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005210
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementminoralways2008-09-23 17:292008-12-09 13:37
ReporterrafarodaView Statuspublic 
Assigned Torafaroda 
PrioritynormalResolutionfixedFixed in Version2.35MP10
StatusclosedFix in branch2.3xFixed in SCM revision7900
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 7.10Database version8.3Ant version1.7
Product VersionpiSCM revision7694 
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
Summary

0005210: '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/ [^]
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0005208 closedrafaroda 'Tax Report Setup'/'Tax Report' and 'User Defined Accounting Report Setup'/'Accounting Report' fail due to 'sampledata' issue 

-  Notes
(0009198)
svnbot (viewer)
2008-09-25 15:02

 Repository: openbravo
Revision: 7900
Author: rafaroda
Date: 2008-09-25 15:02:28 +0200 (Thu, 25 Sep 2008)

Fixes bug 0005210 Added new sampledata inside AD_TREE AND AD_TREENODE tables for BigBazaar.

---
U branches/r2.3x/database/sampledata/AD_TREE.xml
U branches/r2.3x/database/sampledata/AD_TREENODE.xml
---

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

- Issue History
Date Modified Username Field Change
2008-09-23 17:29 rafaroda New Issue
2008-09-23 17:29 rafaroda Assigned To => rafaroda
2008-09-23 17:29 rafaroda Status new => scheduled
2008-09-25 13:18 rafaroda OBNetwork customer => No
2008-09-25 13:18 rafaroda Description Updated
2008-09-25 13:18 rafaroda Proposed Solution updated
2008-09-25 15:02 svnbot Checkin
2008-09-25 15:02 svnbot Note Added: 0009198
2008-09-25 15:02 svnbot Status scheduled => resolved
2008-09-25 15:02 svnbot Resolution open => fixed
2008-09-25 15:02 svnbot svn_revision => 7900
2008-12-09 13:37 psarobe Regression testing => No
2008-12-09 13:37 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker