0005340: null constraint violated on creation of new organization

Description

This 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 Reproduce

General Setup || Organization || Organization || Organization

New and then save

Proposed Solution

See attached patch.

Tags

UUID project

Attached Files

org_patch.diff [^] (714 bytes) 2008-09-30 12:50 [Show Content] [Hide Content]

=== src-db/database/model/triggers/AD_ORG_TRG.xml
==================================================================
--- src-db/database/model/triggers/AD_ORG_TRG.xml	(revision 8052)
+++ src-db/database/model/triggers/AD_ORG_TRG.xml	(local)
@@ -30,11 +30,11 @@
     INSERT
     INTO AD_Role_OrgAccess
       (
-        AD_Role_ID, AD_Client_ID, AD_Org_ID,
+        AD_Role_OrgAccess_ID, AD_Role_ID, AD_Client_ID, AD_Org_ID,
         IsActive, Created, CreatedBy,
         Updated, UpdatedBy
       )
-    SELECT AD_Role_ID, :new.AD_Client_ID, :new.AD_Org_ID,
+    SELECT get_uuid(), AD_Role_ID, :new.AD_Client_ID, :new.AD_Org_ID,
        'Y', now(), :new.CreatedBy,
       now(), :new.CreatedBy
     FROM AD_Role

Relationships [ Relation Graph ] [ Dependency Graph ]

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

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

Issue History
Date Modified	Username	Field	Change
2008-09-30 12:50	CrosiarCM	New Issue
2008-09-30 12:50	CrosiarCM	Assigned To	=> cromero
2008-09-30 12:50	CrosiarCM	sf_bug_id	0 => 2137994
2008-09-30 12:50	CrosiarCM	File Added: org_patch.diff
2008-09-30 12:51	CrosiarCM	Issue Monitored: CrosiarCM
2008-09-30 13:05	rafaroda	Tag Attached: UUID project
2008-09-30 13:05	rafaroda	Relationship added	related to 0005207
2008-10-06 12:07	cromero	Status	new => scheduled
2008-10-06 12:07	cromero	Assigned To	cromero => Dowid
2008-10-06 12:07	cromero	fix_in_branch	=> trunk
2008-10-08 18:22	svnbot	Checkin
2008-10-08 18:22	svnbot	Note Added: 0009454
2008-10-08 18:22	svnbot	Status	scheduled => resolved
2008-10-08 18:22	svnbot	Resolution	open => fixed
2008-10-08 18:22	svnbot	svn_revision	=> 8414
2008-11-25 22:08	psarobe	Regression testing	=> No
2008-11-25 22:08	psarobe	Status	resolved => closed