Run a report query against the job history database using the ESP Workstation Report Manager feature:
REPORT
SQL select jobname,rdrondate,applgen
from esp_jhr
where jobname=MYJOB
ENDR
Click on 'Generate Report', and the following error message is displayed:
ESPWSS Error:
ESPWSS6944E [jcc][10103][10941][3.68.76] Method executeQuery cannot be used for update. ERRORCODE=-4476, SQLSTATE=null
Component : ESP WORKLOAD AUTOMATION r12.0
ESP WORKLOAD AUTOMATION WORKSTATION r11.3
1. Add the following to the RSERENV parm for the Report Server:
_BPX_SHAREAS=MUST
2. Check if AHRFIELD & JHRFIELD DD names are defined in the Report Server started task proc.
3. Run CYBRS006 and CYBRS007 to create the views.