SQR CreateProcess Failed

When trying to run an SQR on an NT process scheduler, I received the following error:

Error! SQR Failed To Process
***
*** System Error Code 2
****** PS_StartProc: CreateProcess failed:
    cmd = C:\PT8.51\bin\sqr\ORA\binw\sqrw
    cwd = C:\oracle\instantclient11r2

***
*******************  Error ***********************

Somewhat cryptic! What's happened was that the %PS_HOME% directory had been changed, so the path it was using to run sqrw had changed. Going back to the process scheduler configuration and changing the SQRBIN parameter to the correct location, and restarting process scheduler resolved the issue.

A simple solution in the end (mis-configuraton) but I noticed when I did a quick google search for the problem, I got nowhere, especially with the main results being exactly-my-problem-but-no-useful solution posts in other forums.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License