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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005071
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementtrivialalways2008-09-16 16:292008-12-03 13:49
ReportervmromanosView Statuspublic 
Assigned Toeduardo_Argal 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision7404
ProjectionnoneETAnoneTarget Versionpi
OSLinux 32 bitDatabaseOracleJava version1.5
OS VersionUbuntu 8.04Database versionSEAnt version1.7
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005071: Creating a new accounting report fails due to a trigger error

DescriptionWhen you try to save a new accounting report, the following error raises:

ORA-01403: no data found ORA-06512: at "TAD_TRUNK.AD_ACCOUNTINGRPT_ELEMENT_TRG", line 38 ORA-04088: error during execution of trigger 'TAD_TRUNK.AD_ACCOUNTINGRPT_ELEMENT_TRG'
Steps To ReproduceGo to Financial Management || Accounting || Analysis Tools || Accounting Report || Accounting Report, create a new record, check off the report field and try to save it
Proposed SolutionThe AD_TREENODE table now has a AD_TREENODE_ID column, so the insert into this table done inside the trigger must fill this column using the get_uuid() function.

Moreover, inside this insert, it is necessary to change:
CASE :NEW.IsSummary
          WHEN 'Y'
          THEN '100'
          ELSE '999'
        END
by
CASE :NEW.IsSummary
          WHEN 'Y'
          THEN 100
          ELSE 999
        END

because the seqno column is numeric and not varchar.
TagsUUID project
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0005207 closedrafaroda 'Tax Report Setup' does not work due to trigger fail 

-  Notes
(0009049)
svnbot (reporter)
2008-09-17 13:42

Repository: openbravo
Revision: 7404
Author: eduardoargal
Date: 2008-09-17 13:41:55 +0200 (Wed, 17 Sep 2008)

Fixes bug 0005071: Creating a new accounting report fails due to a trigger error

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

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

- Issue History
Date Modified Username Field Change
2008-09-16 16:29 vmromanos New Issue
2008-09-16 16:29 vmromanos Assigned To => eduardo_Argal
2008-09-16 16:29 vmromanos sf_bug_id 0 => 2114300
2008-09-16 16:29 vmromanos Regression testing => No
2008-09-16 16:29 vmromanos Tag Attached: UUID project
2008-09-17 13:42 svnbot Checkin
2008-09-17 13:42 svnbot Note Added: 0009049
2008-09-17 13:42 svnbot Status new => resolved
2008-09-17 13:42 svnbot Resolution open => fixed
2008-09-17 13:42 svnbot svn_revision => 7404
2008-09-23 16:34 rafaroda Relationship added related to 0005207
2008-12-03 13:49 krishna Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker