Nonzero rc from sql driver RC= ffffd042 In the SCHSRVR task

Document ID : KB000008222
Last Modified Date : 14/02/2018
Show Technical Document Details

When attempting to "Retrieve Spool File" via the CA-7 Web Client, we receive the following error message: 

There are no items to satisfy the request. 


In the SCHSRVR started task, we see this error:

Nonzero rc from sql driver  RC= ffffd042 .




User does not have access to the resource required to retrieve spool data for agent jobs.


The security administrator would need to grant user access to resource L2AGX. Access to this resource will allow user to do the AGFILE command which is used to retrieve spool data. 

Additional Information:

For additional information, please see the CA 7 Security Guide.