CEM encounters the CEMR202E error running subsequent reports

Article Id: 131302

Status: Published

Updated On: 24-04-2019 12:37

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.