Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005207Openbravo ERP09. Financial managementpublic2008-09-23 16:342008-12-03 13:03
Reporterrafaroda 
Assigned Torafaroda 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Version 
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
Summary0005207: 'Tax Report Setup' does not work due to trigger fail
DescriptionYou can not insert a record inside 'Tax Report Setup' due to an issue in trigger C_TAX_REPORT_TRG with error message (this only happens in the trunk, not in 2.40 branch nor 2.3x branch):
15:22:02 [http-8883-Processor21] ERROR org.openbravo.erpWindows.TaxReportSetup.TaxReportSetupData - 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 ((?), (?), (?), (?), (?), (?), (?), (?), (?), (?), (?), (?), now(), ?, now(), ?)Exception:org.postgresql.util.PSQLException: ERROR: null value in column "ad_treenode_id" violates not-null constraint
Steps To Reproduce1) Go to 'Financial Management || Accounting || Analysis Tools || Tax Report Setup' and try to insert a record.
Proposed SolutionSee https://issues.openbravo.com/view.php?id=5071 [^]
Additional Information
TagsNo tags attached.
Relationships
related to defect 0005071pi closed eduardo_Argal Creating a new accounting report fails due to a trigger error 
related to defect 0005340 closed Dowid null constraint violated on creation of new organization 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-23 16:34rafarodaNew Issue
2008-09-23 16:34rafarodaAssigned To => cromero
2008-09-23 16:34rafarodasf_bug_id0 => 2124681
2008-09-23 16:34rafarodaRegression testing => No
2008-09-23 16:34rafarodaAssigned Tocromero => rafaroda
2008-09-23 16:34rafarodaRelationship addedrelated to 0005071
2008-09-23 16:37svnbotCheckin
2008-09-23 16:37svnbotNote Added: 0009158
2008-09-23 16:37svnbotStatusnew => resolved
2008-09-23 16:37svnbotResolutionopen => fixed
2008-09-23 16:37svnbotsvn_revision => 7753
2008-09-30 13:05rafarodaRelationship addedrelated to 0005340
2008-12-03 13:03krishnaStatusresolved => closed

Notes
(0009158)
svnbot   
2008-09-23 16:37   
Repository: openbravo
Revision: 7753
Author: rafaroda
Date: 2008-09-23 16:37:21 +0200 (Tue, 23 Sep 2008)

Fixes issue 0005207 Added 'AD_TREE_NODE_ID' and 'GET_UUID()' to 'C_TAX_REPORT_TRG' trigger.

---
U trunk/src-db/database/model/triggers/C_TAX_REPORT_TRG.xml
---

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