Any or all of the nightly RiskFabric Processing job steps of type Operating system (CmdExec) fail and throw an error similar to the following:
The process could not be created for step n of job 0x9309FE9EE7E6794496873373CDCC1318 (reason: Access is denied). The step failed.
The job steps of type Operating system (CmdExec) and the executables they run are:
|Update DB Utility Versions||23||TaskRunner.exe||TaskRunner.Tasks.Custom.DBUtilitiesVersionUpdater|
|Send License Expiration Notifications||25||TaskRunner.exe||TaskRunner.Tasks.Custom.SecurityNewsletterEmailTask spExpiringLicenseNotificationCheck|
|Send Scenario Step Up Emails||26||TaskRunner.exe||TaskRunner.Tasks.Custom.SecurityNewsletterEmailTask spGetStepUpEmails "" "" spUpdateStepUpEmailSent|
|Send Email Notifications||27||TaskRunner.exe||TaskRunner.Tasks.Custom.SecurityNewsletterEmailTask spGetFailedEmailsForResending "" "" spUpdateFailedEmailsForResending|
Release : 6.x
Component : RiskFabric Processing
These job steps are executed by the SQL Server Agent using impersonation via the RiskFabric Nightly Processing proxy. The proxy uses the RiskFabric Nightly Processing credential, which runs under an identity that is typically the service account you have designated as the owner of the RiskFabric database. The error described in this article will occur if the service account does not have rights to either access the path or execute the command specified in the job step.
To resolve this error, ensure the RiskFabric Nightly Processing credential's identity account has rights to access the path specified in the failing job step(s), and confirm the path specified is valid.
To determine the account being used as the RiskFabric Nightly Processing credential's identity, follow this procedure:
For SQL Server Agent job steps of type Operating system (CmdExec), command names that contain spaces should be enclosed in quotation marks, with any switches or arguments placed outside the quotation marks:
"E:\Program Files\Bay Dynamics\Database Utilities\TaskRunner\TaskRunner.exe" TaskRunner.Tasks.Custom.DBUtilitiesVersionUpdater