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.