ESPWSS6944E running a report query against the job history database through the ESP Workstation Report Manager feature

Products

• ESP Workload Automation

Issue/Introduction

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

Environment

Component : ESP WORKLOAD AUTOMATION r12.0

                     ESP WORKLOAD AUTOMATION WORKSTATION r11.3 

Resolution

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.