top button
Flag Notify
Site Registration

Complete discribtion of error codes in informatica

+2 votes
931 views

When I am running the Informatica workflow via shell script due to some problem, workflow fails and value of $? is coming as 3.

So can you please tell me when this type of error code is coming. Script is read-only and i am not able to see which type of error is coming.

Executed command :

pmcmd startworkflow -sv "CSA_DEV_INT" -d Domain_CSADevelopment -u Administrator -p Administrator -f PRACTICE_SV -wait wf_practice_1 > /dev/null

One more thing, the issue is not re-producible every time.

posted Oct 7, 2014 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Is the workflow running every time when you execute from Workflow Manager?
(2) Remove > /dev/null and run the command in command line - is there any error?

answer Oct 8, 2014 by Shweta Singh
Similar Questions
+2 votes

If work flow run on informatica level how to create the automatically file create error reocrds and rejected records in one file.

+1 vote

The command to convert from .xlsx to csv works in putty, but the same when given in informatica fails....I am getting exit error code 32512.

The workflowlog >>

Severity    Timestamp   Node    Thread  Message Code    Message
INFO    9/8/2016 5:28:20 PM Node_BIDEV  140284941813504 LM_36621    Command task instance [Convert_csv]: started command [convert], with pid [14121] on node [Node_BIDEV].
ERROR   9/8/2016 5:28:21 PM Node_BIDEV  140285390595840 LM_36623    Command task instance [Convert_csv]: execution of command [convert] did not complete successfully with exit code [32512]
WARNING 9/8/2016 5:28:21 PM Node_BIDEV  140285390595840 LM_36626    Command task instance [Convert_csv]: previous command [convert] failed and "run if previous command succeeded" option is set, the remaining commands will not be run.
ERROR   9/8/2016 5:28:21 PM Node_BIDEV  140285390595840 LM_36320    Command task instance [Convert_csv]: Execution failed.
WARNING 9/8/2016 5:28:21 PM Node_BIDEV  140285390595840 LM_36373    Workflow [wf_CUSTOMER_SURVEY_CORE_DailyFiles] is suspended.
INFO    9/8/2016 5:28:22 PM Node_BIDEV  140285390595840 LM_36375    Workflow [wf_CUSTOMER_SURVEY_CORE_DailyFiles]: Sent suspension email to email user 
WARNING 9/8/2016 5:28:27 PM Node_BIDEV  140284973283072 LM_36371    Workflow [wf_CUSTOMER_SURVEY_CORE_DailyFiles] is aborting.
WARNING 9/8/2016 5:28:27 PM Node_BIDEV  140284973283072 LM_36322    Workflow [wf_CUSTOMER_SURVEY_CORE_DailyFiles]: Execution aborted.

The command script I am using is

libreoffice --headless --convert-to csv:"Text - txt - csv (StarCalc)":"126,0,76,1,2" /var/opt/load/Sourcedata/CUSTOMER_SURVEY/2016Q2_ML_V1.xlsx

Please help me...

0 votes

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.

+1 vote

I am trying to install Informatica 8.6 server on my Windows 7 Home Edition Laptop with Oracle 11g. I am getting error message:

"Cannot start Informatica services" EXITCODE: S.

There is a long description which says:

"Use the error below and catalina.out and node.log in the server/tomcat/logs directory on the the current machine to get more information." .

When I checked catalina.out, the file is empty and node.log didn't exist in server/tomcat/logs.

Could you please let me know how to get rid of this error if have happened to come across and resolved that or know how to resolve the error?

...