-4476 SQL ERROR Generating Report in CA Workload Automation Workstation.

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

 Set up a DB2 Report Server and I am trying to generate the report in the ESP WorkStation. I get the following SQL Errorcode=-4476. 

This Report SQL is from the Install and Config Guide in the Section on testing the report server. 


REPORT 
SQL select jobname,rdrondate 
from prod.esp_job_hist 
order by jobname 
ENDR 

Cause:

This basically says that this ErrorCode can be returned for an empty result set or DB2 does not understand request.

Resolution:

When using Workstation remove the Report and ENDR along with "SQL"