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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005207
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2008-09-23 16:342008-12-03 13:03
ReporterrafarodaView Statuspublic 
Assigned Torafaroda 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision7753
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 7.10Database version8.3Ant version1.7
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0005071pi closededuardo_Argal Creating a new accounting report fails due to a trigger error 
related to defect 0005340 closedDowid null constraint violated on creation of new organization 

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

- Issue History
Date Modified Username Field Change
2008-09-23 16:34 rafaroda New Issue
2008-09-23 16:34 rafaroda Assigned To => cromero
2008-09-23 16:34 rafaroda sf_bug_id 0 => 2124681
2008-09-23 16:34 rafaroda Regression testing => No
2008-09-23 16:34 rafaroda Assigned To cromero => rafaroda
2008-09-23 16:34 rafaroda Relationship added related to 0005071
2008-09-23 16:37 svnbot Checkin
2008-09-23 16:37 svnbot Note Added: 0009158
2008-09-23 16:37 svnbot Status new => resolved
2008-09-23 16:37 svnbot Resolution open => fixed
2008-09-23 16:37 svnbot svn_revision => 7753
2008-09-30 13:05 rafaroda Relationship added related to 0005340
2008-12-03 13:03 krishna Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker