I received an urgent note that a demo system a fellow consultant had created was having an issue running SQR’s in a recently created PeopleSoft environment running on Windows 2012 and SQL Server 2012.

Error! SQR Failed To Process
*** System Error Code 2
****** PS_StartProc: CreateProcess failed:
cmd = e:\psoft\pt853\bin\sqr\MSS\binw\sqrw

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

At first this looked like a pretty serious errors. The consultant was concerned it was a permissions error with Windows security. There were some big changes going from Windows Server 2003 to Windows Server 2008 and 2012. However, in this case, everything was actually installed correctly but instead was not configured correctly.

When the Process Scheduler Domain is built it defaults the SQRBIN parameter. After updating the SQRBIN parameter to: %PS_HOME%\bin\sqr\MSS\binw\sqr\ everything was looking good and SQRs were running successfully!

Note: If you are editing the .CFG directly rather than going through PSADMIN, don’t forget to stop/restart the process scheduler for this change to take effect.


Leave a Reply