-
1. Re: How to run infacmd command using command task in idq workflow?
Robert Whelan Jul 18, 2019 2:17 AM (in response to Shaikh Ahmed)Hi,
If you're getting no errors etc. I'd suggest updating the command task to it redirects the output to a text file e.g. ./infacmd.sh ... your command... > commandtask.log
I'm assuming you've tested the command in the command task directly from the command line and it works fine.
-
2. Re: How to run infacmd command using command task in idq workflow?
Shaikh Ahmed Jul 18, 2019 3:00 AM (in response to Robert Whelan)Hi Robert,
Thanks for replying.
I have tested the command and it runs perfectly fine in command line. My Informatica is installed in Windows server. I couldn't understand the command you suggested. Can you please elaborate? Where will this command task.log be saved?
Moreover I am using this command to run a profile from command task in workflow as I have to schedule the workflow at a particular time. How directing it to text file will help?
Thanks
Shaikh
-
3. Re: How to run infacmd command using command task in idq workflow?
Robert Whelan Jul 18, 2019 3:32 AM (in response to Shaikh Ahmed)It will be the same on Windows, just append "> c:\temp\commandtask.log" to the end of the infacmd command used to run the profile and any output from the command will be redirected to that file.
It may already be logged to the workflow log at INFA_HOME/logs/NodeName/services/DataIntegrationService/disLogs/workflow so you should check that as well.
-
4. Re: How to run infacmd command using command task in idq workflow?
Shaikh Ahmed Jul 18, 2019 4:41 AM (in response to Shaikh Ahmed)Hi Robert,
In log it is showing completed normally. But the profile is still not running. I have used the exact command line used in cmd in command task as well. Shall I do any kind of modifications? My command is:
infacmd ps execute -dn domain name -hp host:port -un user -pd pswrd -msn model repos name -dsn data integration name -ot profile -opn pathname
I tried ./infacmd.sh as well in start. But no use. Please guide me.
Thanks
Shaikh Muktar
-
5. Re: How to run infacmd command using command task in idq workflow?
Robert Whelan Jul 18, 2019 5:09 AM (in response to Shaikh Ahmed)You generated the c:\temp\commandtask.log and there were no errors?
-
6. Re: How to run infacmd command using command task in idq workflow?
Shaikh Ahmed Jul 18, 2019 5:40 AM (in response to Shaikh Ahmed)Hi Robert,
There was no error. But I achieved it now. I was missing the path in the beginning of the command.
Thanks
Shaikh Muktar
-
7. Re: How to run infacmd command using command task in idq workflow?
Juan Sebastian Jimenez Feb 1, 2021 7:47 AM (in response to Shaikh Ahmed)Hi Shaikh Ahmed,
can you give me an example of the command? I'm trying and it doesn't work.
-
8. Re: How to run infacmd command using command task in idq workflow?
Namratha Dhoolipalla Feb 2, 2021 8:55 AM (in response to Juan Sebastian Jimenez)Hi Juan,
The command to run the profile is as follows:
/infacmd.sh ps execute -dn domain name -hp host:port -un user -pd pswrd -msn model repos name -dsn data integration name -ot profile -opn pathname
Since the infacmd command is available in the $INFA_HOME/isp/bin, the same path needs to be appended to the beginning of the command when adding it to a command task.
Thanks,
Namratha
-
9. Re: How to run infacmd command using command task in idq workflow?
jyoti singh Feb 3, 2021 3:02 AM (in response to Shaikh Ahmed)Hi,
If the server is in windows, You can write command as <Absolute_INFA_HOME_path>\isp\bin\infacmd.bat ps execute -dn <Domain_name> -un username -pd password -msn MRS_NAME -dsn DIS_Name -ot profile -opn Project/sobfolder/profile_Name.
Attaching screenshot for reference.
You can also try to run the command first in command line and check if you are able to run the profile or hitting any issue. Share the output with us in case of failure.
Regards,
Jyoti
-
10. Re: How to run infacmd command using command task in idq workflow?
Juan Sebastian Jimenez Feb 8, 2021 5:21 AM (in response to Namratha Dhoolipalla)Hi Namratha
I tried adding the command in a task commmand and it works!
$INFA_HOME/isp/bin/infacmd.sh ps execute -dn domain name -hp host:port -un user -pd pswrd -msn model repos name -dsn data integration name -ot profile -opn pathname
Thanks