ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 8222


Updated On:


CA 7 Workload Automation


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.


Release: ESPSEV99000-11.1-CA-7-Extended Support Plus


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.