CEM encounters the CEMR202E error running subsequent reports
book
Article ID: 131302
calendar_today
Updated On:
Products
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'
Environment
CEM 6.0
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) '
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.