CEM encounters the CEMR202E error running subsequent reports

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.