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

book

Article ID: 6793

calendar_today

Updated On:

Products

CA Workload Automation ESP Edition

Issue/Introduction

 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.

Environment

Release: ENCWLA00200-11.4-Workload Automation-Restart Option-EE
Component:

Resolution

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