Monday, July 31, 2006

Informatica 7.1:Informatica Session terminated unexpectedly;LM_36401

In the troubleshooting guide it has been written like:

================================================================
LM_36401 Execution terminated unexpectedly
Cause: The DTM process did not stop,abort or fail properly.
Action: Contact Informatica Technical Support.

================================================================

Error Description:
You run a session.The session just failed without being picked up properly.And the log is also of very few lines telling the "Failed to fetch session instance properly".

I tried many times.The same thing happened.I tried in google and got a solution like this:

http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/error-code-36401-execution-terminated-unexpectedly-1087284

As per the solution told in above webpage:
1/
I removed the repositoryserver log.
I removed the pmserver log.
I removed the repagent log.

2/
I truncated log from repository manager console.

3/
I revalidated mapping and workflows associated with that session.

4/I shut down pmrepserver as well as pmserver and then again re-start.


But every single things I did of no help.

Lastly I got this beautiful scripts:

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)


If the above query returns more than one row in the result set then
apply the following update query.

CREATE TABLE OPB_WIDGET_FIELD_BACKUP AS SELECT * FORM OPB_WIDGET_FIELD;

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)


And yah,it solved that sticky problems.....:)

Labels:

1 Comments:

Anonymous Anonymous said...

Thanks.My session is running fine now.

3:16 PM  

Post a Comment

<< Home