SqlQuery workflow fails in viewer, but works in simulator

Permanently deleted user

October 24, 2018 16:51

I have created a workflow and using SqlQuery activity in it. This works great in workflow simulator. But when I use the same workflow from a tool in the html viewer, it throws error ORA-12154: TNS: could not resolve the connect identifier specified. How can I resolve the issue?

 

Thanks

 

Swaroop

0

• 

  Berend Veldkamp

  October 31, 2018 15:58

  One possible reason could be that the application pool user can't find the connection info (tnsnames.ora), or that it does not have read access to it.

   

  If you have the TNS_NAMES environment variable set, make sure it's set for All Users, and not just the current user. After that, run 'iisreset' to reload IIS.

  0
• 

  Permanently deleted user

  November 22, 2018 22:00

  Hi Shantaswaroop,

   

  Another thing to check is that your server has the 64-bit Oracle driver available.  The Workflow Designer (and thus the simulator) are 32-bit applications that would load the 32-bit driver.  If the 64-bit driver has a different home then it may use a different tnsnames.ora file.  You may just have to update the file that the 64-bit driver loads, or you may be able to specify more connection info in the connection string to let it work.

   

  Regards,

   

  -Malcolm

  0

Please sign in to leave a comment.