Workflow Soluiton

Hi All,

 I am the beginer to  the AWF.

I need some help from you guys.

I  want monitor my oracle database server from  my application(informatica)  server.

for this requirement  i  wrote a shell script in my application server(informatica).  inside the shell script i am calling  oracle sql script.

this shell script  we are calling from AWF  with using plink , while calling  the shell script from AWF we are getting an error invalid command sql.

 this same script we are executed from Application server it is running successfully.

Is there any limitation with  AWf or we need to install any package or we need to run different way??.

please tell us any body know the solution to this.

Thanks in advance for you help:)

Thanks

Reddy

If the shell script is a batch file of some sort you can execute over the command line, you should be able to use the Execute Process/Execute Process and Wait component. It could be possible that the batch file depends on some external library that's not on the Workflow server.

Hi Recordo,

 Thanks for your help :)

As of  your suggestion,

by using execute batch process component we called the batch file its working fine.

only problem when we  running workflow   it showing command task popup if we close the popup  manually it it is going to next level and  calling the script.

 is there any way to close the command task  automatically .. 

Thanks

Reddy

I wrote a powershell script to call plink and answer "yes" to the ssh key prompt to close it.  I use the execute process for that.   Then I use the execute and wait to call my shell script using plink.   Not sure if this is the same thing you are talking about.