CODEWITHSUNDEEP
informatica
Ishank Shah
Ishank Shah

Reputation: 33

Getting the session log error message in mail in informatica?

I am working in Informatica project, and we use to trigger the workflow from Autosys and if workflow fails we get the mail. After that we used to check the session log and find out the error message. Generally the error message is a Network error like failed to connect to Database. My Question is there any way to extract only the error message from the session log like "Failed to Connect to database" and send this in mail.

Upvotes: 0

Views: 3549

Answers (1)

JTeezee
JTeezee

Reputation: 38

... ---> Session ---> Email task

The email task will run if the session task fails. In subject or body of email task use $PMS1.firsterrorcode. It will then give the error code and simple reason why the session failed. Similar to the error you see in the workflow monitor.

Upvotes: 2

Related Questions