When I start the ldap server for CEM, CEMELDAP, it fails to connect with error messages ETLDP43I CA LDAP Server connect to DB=CEMEDBU in process ETLDP45E CA LDAP Server connect to DB=CEMEDBU failed, return code=-1 How do I fix this problem?

Document ID : KB000004715
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When I start the CA LDAP Server that comes with Compliance Event Manager, I get the following error messages in the

Joblog ...

 

ETLDP43I CA LDAP Server connect to DB=CEMEDBU in process
ETLDP45E CA LDAP Server connect to DB=CEMEDBU failed, return code=-1

and in the STDERR file i see the following..

 

DSNT408I SQLCODE = -922, ERROR: AUTHORIZATION FAILURE: CONNECT ERROR. REASON 
00F30086 
DSNT418I SQLSTATE = 42505 SQLSTATE RETURN CODE 
DSNT415I SQLERRP = DSNXECNT SQL PROCEDURE DETECTING ERROR 
DSNT416I SQLERRD = -760 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION 
DSNT416I SQLERRD = X'FFFFFD08' X'00000000' X'00000000' X'FFFFFFFF' 
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION 
ERRLOC=5:10:2 (-922) 

 

 

 

Resolution:

The SQL error code -922 means that the user's password is expired.

Adjust the ESM security setup to ensure the password is correct and not expired.