Informatica 7.1:Error LM_36526:signal 6- Unexpected Condition Detected

PROBLEM

Sometimes unexpectedly session terminates contained mapping having router in it.The error is:
LM_36526:signal 6- Unexpected Condition Detected

Warning: Unexpcted condition at: widgfld.cpp: 11


ERROR : LM_36526 [Wed May 11 15:12:40 2005] : (29532|36) Session task instance [s_Some_session]: DTM process [pid = 14102] exited due to signal [6].


SOLUTION

1/
Take the backup of INFA metadata.

2/
Run the following query on INFA metadata and check for results:

SELECT A.SUBJ_NAME ,B.MAPPING_NAME ,C.WIDGET_ID ,C.INSTANCE_NAME
FROM OPB_SUBJECT A ,OPB_MAPPING B ,OPB_WIDGET_INST C
WHERE A.SUBJ_ID=B.SUBJECT_ID AND B.MAPPING_ID =C.MAPPING_ID AND B.VERSION_NUMBER = C.VERSION_NUMBER AND C.WIDGET_TYPE=15 AND B.IS_VISIBLE > 0 AND C.WIDGET_ID IN
(select w.WIDGET_ID from opb_widget_field wf, opb_widget w
where w.widget_type = 15 and w.widget_id = wf.widget_id and w.version_number = wf.version_number and w.is_visible > 0
and wf.widget_fld_prop = 0 and wf.porttype = 2)

3/
If the query returns more than one row then...

4/
CREATE TABLE OPB_WIDGET_FIELD_BCKUP AS SELECT * FORM OPB_WIDGET_FIELD; --Taking bkup

5/
update opb_widget_field set widget_fld_prop =
(select f2.field_id from opb_widget_field f2, opb_widget w
where f2.widget_id = opb_widget_field.widget_id and f2.version_number = opb_widget_field.version_number and f2.widget_id = w.widget_id and f2.version_number = w.version_number and w.is_visible > 0 and w.widget_type = 15 and f2.field_name =
substr(opb_widget_field.field_name,1,length(opb_widget_field.field_name)-1))
where widget_fld_prop=0 and porttype = 2 and exists (select * from opb_widget w where w.widget_type = 15 and w.is_visible > 0 and w.widget_id = opb_widget_field.widget_id and w.version_number = opb_widget_field.version_number)

6/
Run the problematic session again.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com