Informatica 7.1:Informatica Session terminated unexpectedly;LM_36401
In the troubleshooting guide it has been written like:
================================================================
LM_36401
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: Technical_HowTo_Infa
1 Comments:
Thanks.My session is running fine now.
Post a Comment
<< Home