Got ESPWSS6944E when run a report query against the job history database through the Report Manager feature of CA WA Workstation

book

Article ID: 186201

calendar_today

Updated On:

Products

CA Workload Automation ESP Edition

Issue/Introduction

Run a report query against the job history database through the Report Manager feature of CA WA Workstation with below:

REPORT
SQL select jobname,rdrondate,applgen
from esp_jhr
where jobname=AI925F03
ENDR

When I click 'Generate Report' I am receiving the following error message:

ESPWSS Error:
ESPWSS6944E [jcc][10103][10941][3.68.76] Method executeQuery cannot be used for update. ERRORCODE=-4476, SQLSTATE=null

Environment

Release : 12.0

Component : CA ESP WORKLOAD AUTOMATION and Workstation

Resolution

So firstly you will need to add below to RSERENV parm for Report Server:
_BPX_SHAREAS=MUST

Secondly check if AHRFIELD & JHRFIELD DD names are defined in the Report Server STC Proc.

Lastly the CYBRS006 and CYBRS007 should run to create the views.