Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005071Openbravo ERP09. Financial managementpublic2008-09-16 16:292008-12-03 13:49
Reportervmromanos 
Assigned Toeduardo_Argal 
PrioritynormalSeveritytrivialReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 8.04
Product Versionpi 
Target VersionpiFixed in Version 
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
Summary0005071: 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.
Additional Information
TagsUUID project
Relationships
related to defect 0005207 closed rafaroda 'Tax Report Setup' does not work due to trigger fail 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-16 16:29vmromanosNew Issue
2008-09-16 16:29vmromanosAssigned To => eduardo_Argal
2008-09-16 16:29vmromanossf_bug_id0 => 2114300
2008-09-16 16:29vmromanosOBNetwork customer => No
2008-09-16 16:29vmromanosRegression testing => No
2008-09-16 16:29vmromanosTag Attached: UUID project
2008-09-17 13:42svnbotCheckin
2008-09-17 13:42svnbotNote Added: 0009049
2008-09-17 13:42svnbotStatusnew => resolved
2008-09-17 13:42svnbotResolutionopen => fixed
2008-09-17 13:42svnbotsvn_revision => 7404
2008-09-23 16:34rafarodaRelationship addedrelated to 0005207
2008-12-03 13:49krishnaStatusresolved => closed

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