search cancel

3025 Error in DBOpen connection processing in SQLConnect With CEM Job CEMMDCCU

book

Article ID: 242675

calendar_today

Updated On:

Products

Compliance Event Manager

Issue/Introduction

When running Compliance Event Manager job CEMMDCCU, the following errors occur: 

CEM DB CONNECT
 ODBC DEBUG message: Unable to connect to the server
 Õ08001þ ÕCAþÕODBC CA-DATACOM/DB DriverþÕCA-DATACOM/DBþCCI not in systemm - cci not allowed
          (-5065)
 Õ08001þ ÕCAþÕODBC CA-DATACOM/DB DriverþError: 3012 error during OPENP
          (-5065)
 Õ     þ ÕCAþÕODBC CA-DATACOM/DB DriverþÕCA-DATACOM/DBþCCI not in systemm - cci not allowed
          (0)
 Õ     þ ÕCAþÕODBC CA-DATACOM/DB DriverþError: 3025 Error in DBOpen connection processing in SQLConnect (0)
 Cannot allocate a statement handle

Environment

Release : 6.0

Component : COMPLIANCE EVENT MANAGER

Resolution

The DBSSID= in the member for the CEEVARS DD must match the ENF started task's CCI SYSID.

To find the CCI SYSID:
1) Go to the ENF proc and find the ENFPARMS DD.
2) Go to the dataset from the ENFPARMS DD and look for SYSID=.