0012707: Some triggers in the module do not compile

Description

src-db/database/model/triggers/OBUISEL_ELEMENT_TRL_TRG.xml
src-db/database/model/triggers/OBUISEL_SELECTOR_FIELD_TRG.xml

These two triggers do not compile, and this prevents users to be able to create new selectors but also prevents them to launch Syncronize terminology process once the module is installed in the system.

Proposed Solution

Find attached the diff file that fices the issue (Review the fix t ensure it does whatwas intended to)

Tags

No tags attached.

Attached Files

OBUISEL_triggers.diff [^] (2,079 bytes) 2010-03-17 12:55 [Show Content] [Hide Content]

diff -r 31c9369cd513 src-db/database/model/triggers/OBUISEL_ELEMENT_TRL_TRG.xml
--- a/src-db/database/model/triggers/OBUISEL_ELEMENT_TRL_TRG.xml	Thu Mar 11 03:49:09 2010 +0100
+++ b/src-db/database/model/triggers/OBUISEL_ELEMENT_TRL_TRG.xml	Wed Mar 17 12:55:08 2010 +0100
@@ -48,7 +48,7 @@
             Description = :NEW.Description,
             HELP = :NEW.HELP,
             IsTranslated = :NEW.IsTranslated
-        WHERE  AD_Language = :NEW.AD_Language
+        WHERE  AD_Language_ID = :NEW.AD_Language
             AND OBUISEL_Selector_Field_ID IN (
                 SELECT F.OBUISEL_Selector_Field_ID
                 FROM OBUISEL_Selector_Field F, AD_Column C, AD_Module M
@@ -71,7 +71,7 @@
                 AND M.aD_Module_id = f.ad_module_id
                 and m.AD_Language = :new.AD_Language)
             AND exists (SELECT 1 from ad_module m
-                where m.ad_module_id=ad_field.ad_module_id
+                where m.ad_module_id=OBUISEL_Selector_Field.ad_module_id
                 and m.isindevelopment='Y');
         END IF;
     END IF;
diff -r 31c9369cd513 src-db/database/model/triggers/OBUISEL_SELECTOR_FIELD_TRG.xml
--- a/src-db/database/model/triggers/OBUISEL_SELECTOR_FIELD_TRG.xml	Thu Mar 11 03:49:09 2010 +0100
+++ b/src-db/database/model/triggers/OBUISEL_SELECTOR_FIELD_TRG.xml	Wed Mar 17 12:55:08 2010 +0100
@@ -77,7 +77,7 @@
             COALESCE(:NEW.IsCentrallyMaintained , '.') != COALESCE(:OLD.IsCentrallyMaintained , '.') OR
             COALESCE(:NEW.Sort , '.') != COALESCE(:OLD.Sort , '.') OR
             COALESCE(:NEW.Filter , '.') != COALESCE(:OLD.Filter , '.') OR
-            COALESCE(:NEW.ShowInSuggestionBox , '.') != COALESCE(:OLD.ShowInSuggestionBox , '.') OR
+            COALESCE(:NEW.SearchInSuggestionBox , '.') != COALESCE(:OLD.SearchInSuggestionBox , '.') OR
             COALESCE(:NEW.ShowInGrid , '.') != COALESCE(:OLD.ShowInGrid , '.') OR
             COALESCE(:NEW.Sortno , 0) != COALESCE(:OLD.Sortno , 0) OR
             COALESCE(:NEW.OBUISEL_Selector_ID , '.') != COALESCE(:OLD.OBUISEL_Selector_ID , '.') OR

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0012694

closed

mtaal

Triggers in invalid status on oracle

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2010-03-17 12:55	eduardo_Argal	New Issue
2010-03-17 12:55	eduardo_Argal	Assigned To	=> shuehner
2010-03-17 12:55	eduardo_Argal	File Added: OBUISEL_triggers.diff
2010-03-17 12:55	eduardo_Argal	OBNetwork customer	=> No
2010-03-17 17:18	gorkaion	Relationship added	duplicate of 0012694
2010-03-17 17:18	gorkaion	Status	new => closed
2010-03-17 17:18	gorkaion	Resolution	open => duplicate
2010-12-09 15:59	anonymous	sf_bug_id	0 => 3133058