Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005340Openbravo ERP01. General setuppublic2008-09-30 12:502008-11-25 22:08
ReporterCrosiarCM 
Assigned ToDowid 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionDebian Unstable
Product Versionpi 
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
Summary0005340: null constraint violated on creation of new organization
DescriptionThis is a bug in the ad_org_trg function and is related to the changes to switch to UUIDs. The trigger attempts to add a row into the table AD_Role_OrgAccess but does not set the primary key.
Steps To ReproduceGeneral Setup || Organization || Organization || Organization

New and then save
Proposed SolutionSee attached patch.
Additional Information
TagsUUID project
Relationships
related to defect 0005207 closed rafaroda 'Tax Report Setup' does not work due to trigger fail 
depends on backport 0005433 closed Dowid null constraint violated on creation of new organization 
Attached Filesdiff org_patch.diff (714) 2008-09-30 12:50
https://issues.openbravo.com/file_download.php?file_id=291&type=bug
Issue History
Date ModifiedUsernameFieldChange
2008-09-30 12:50CrosiarCMNew Issue
2008-09-30 12:50CrosiarCMAssigned To => cromero
2008-09-30 12:50CrosiarCMsf_bug_id0 => 2137994
2008-09-30 12:50CrosiarCMFile Added: org_patch.diff
2008-09-30 12:51CrosiarCMIssue Monitored: CrosiarCM
2008-09-30 13:05rafarodaTag Attached: UUID project
2008-09-30 13:05rafarodaRelationship addedrelated to 0005207
2008-10-06 12:07cromeroStatusnew => scheduled
2008-10-06 12:07cromeroAssigned Tocromero => Dowid
2008-10-06 12:07cromerofix_in_branch => trunk
2008-10-08 18:22svnbotCheckin
2008-10-08 18:22svnbotNote Added: 0009454
2008-10-08 18:22svnbotStatusscheduled => resolved
2008-10-08 18:22svnbotResolutionopen => fixed
2008-10-08 18:22svnbotsvn_revision => 8414
2008-11-25 22:08psarobeRegression testing => No
2008-11-25 22:08psarobeStatusresolved => closed

Notes
(0009454)
svnbot   
2008-10-08 18:22   
Repository: openbravo
Revision: 8414
Author: dowid
Date: 2008-10-08 18:21:57 +0200 (Wed, 08 Oct 2008)

Fixed bug 0005340: null constraint violated on creation of new organization

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

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