top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to Auto rerun failed session in Informatica?

0 votes
633 views

I want to auto run the failed session. How can I achieve this? I tried it by enabling Auto recover terminated task property in workflow. But it is not working. It is not being rerun on failure.

Any suggestion will be helpful?

posted Jun 20, 2014 by anonymous

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

1 Answer

0 votes

There's no such out-of-the box feature. But there can be many solutions:

Ideally you'd use a separate tool / script to run the workflow, check it's state and re-run if failed. This can be achieved using second workflow with a command task, for example, but:

Why don't you try to resolve all the issues and make sure the workflow runs successfully?

Yet another option would be to have a touch command executed in case any session in the workflow fails, and have a second continuously running workflow with event-wait that executes the first workflow if the specified file shows up.

answer Jun 26, 2014 by Shweta Singh
Similar Questions
+2 votes

My question is very similar to the one below, but on a informatica environment:

Retrieving the index of an inserted row

Here is a brief summary of the issue: I'm trying to figure out how I can insert a row into a table and then find out what the value of the auto_incremented id column was set to so that I can insert additional data into another table. Our target is SQL server 2008. We have a table which has to be populated by informatica ETLs and the application is also using the same table - so, we can't use informatica sequence generator.

In the past when I have used Oracle database, there was a Oracle sequence generator transformation available in Informatica - but for SQL server, I am not sure.

Any solutions please?

0 votes

While Installing Informatica i am getting this ERROR....

The command to create the domain failed. Select OK to correct the domain information and try the command again. Select Continue to continue the installation without creating the domain. You can run the command to create the domain after installation. Review the log files for more information.

Informatica_9.0.1_Services_HotFix2.log [LOG FILES SAY'S]

Domain name: : Domain_SONY 
Node host name: : SONY 
Node name: : node01_SONY 
Node port number: : 6005 
NODE_ADDRESS : SONY:6005
LOGS_DIRECTORY : C:\Informatica\9.0.1\isp\logs 
BACKUP_DIRECTORY : C:\Informatica\9.0.1\server\infa_shared\Backup 
DOMAIN_USER : Administrator 
  DOMAIN_PSSWD : ***** 
    NODEOPTIONS_XML : C:\Informatica\9.0.1\isp\bin\nodeoptions.xml 
Exit Code : -1

OutPut : [ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002} Cannot create domain, operation failed with error: [INFASETUP_10000] C:\Informatica\9.0.1\tomcat\conf\server.xml (The system cannot find the file specified).]. Error :

I Think i need to fix server.xml file but HOW?
ANY HELP WOULD BE APPRECIATED..

+1 vote

While Installing Informatica i am getting this ERROR....

The command to create the domain failed. Select OK to correct the domain information and try the command again. Select Continue to continue the installation without creating the domain. You can run the command to create the domain after installation. Review the log files for more information.

Informatica_9.0.1_Services_HotFix2.log [LOG FILES SAY'S]
Domain name: : Domain_SONY 
Node host name: : SONY 
Node name: : node01_SONY 
Node port number: : 6005 
NODE_ADDRESS : SONY:6005
LOGS_DIRECTORY : C:\Informatica\9.0.1\isp\logs 
BACKUP_DIRECTORY : C:\Informatica\9.0.1\server\infa_shared\Backup 
DOMAIN_USER : Administrator 
  DOMAIN_PSSWD : ***** 
    NODEOPTIONS_XML : C:\Informatica\9.0.1\isp\bin\nodeoptions.xml 

 Exit Code : -1 

OutPut : [ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002} Cannot create domain, operation failed with error: [INFASETUP_10000] C:\Informatica\9.0.1\tomcat\conf\server.xml (The system cannot find the file specified).]. Error :

 I Think i need to fix server.xml file but HOW?  

ANY HELP WOULD BE APPRECIATED..

+3 votes

I am working with Informatica Developer - Power-Center. I have it installed on 2 computers: my local PC and the MS Server where the Informatica Server is also installed.

I defined a new connection and tested it by clicking Test Connection. On my PC the test works fine but when I test the connection on the server the test fails with the following error: "[REL_10611] Error returned during ODBC access. ErrorCode=[-1]. Reason=[[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]."

Another strange thing is that the mapping that includes a relational data object that uses this connection works even on the server and adds row to the DB. Does anybody know why this could be happening? Is this a bug in the Informatica Developer?

+1 vote

I hav a source structure in informatica like

col1 number   col2 varchar(40)   col3 DATE   col4 varchar(50)   col5 number

and my target definition is like

col4 varchar(50)   col1 number  col5 number  col3 varchar(40)  col3 DATE

If i want to load the source records into target i will map the columns appropriately from source to target in a zig zag way

I just want to know that if there is any concept like informatica will automap fields from source to target based on column names i.e if the target columns are shuffled but the column names are the same ...

any suggestions regarding the same would be helpful ..

...