CEM encounters the CEMR202E error running subsequent reports

book

Article ID: 131302

calendar_today

Updated On:

Products

CA Compliance Event Manager

Issue/Introduction

After the first successful execution of a report in CEM all subsequent invocations fail with the error 'CEMR202E Cannot connect to the CA Compliance Event Manager web service'

Cause

The CEMETOM started task revealed the following error:
'ERROR c.c.s.cem.sqlquery.DBConnector - Error in run report query execution.
java.sql.SQLException: Missing parameter specification at ca.datacom.jdbc.DatacomPreparedStatement.executeQuery(Unknown Source) '

Environment

CEM 6.0 

Resolution

Application of the Datacom PTF RO93604 resolves the java.sql.SQLException: Missing parameter specification error
in turn, alleviating the 'CEMR202E Cannot connect to the CA Compliance Event Manager web service' error condition.