DCDCONTL fails at startup with ERRORCODE=DCD0324E

book

Article ID: 210391

calendar_today

Updated On:

Products

CA Data Content Discovery

Issue/Introduction

DCDCONTL fails at startup 

with

 

2021-02-08 11:34:09,755 Error in getting table encoding                           
com.ca.security.dcd.exceptions.DatabaseException: Exception in getEncodingForTable


Exception Context:                                                                
1:ERRORCODE=DCD0324E.                                                           
2:ERROR=Database exception in TableEncoding DAO getEncodingForTable..           
3:STATUSCODE=.                                                                  
4:TRANSLATIONKEY=error_in_dbEncoding.                                           
5:table Name=CLASSIFIER.                                                        
6:Resolution=Contact CA Support..      

 

Environment

Release : 3.0

Component : CA DATA CONTENT DISCOVERY

Resolution

The DCDCONTL started task is executing an SQL statement to query SYSIBM.SYSTABLES under DCDADM userid to make sure that the DCD repository has been created with a correct encoding.

 

Verify that the DCDADM has the permissions to query SYSIBM.SYSTABLES in the DB2 subsystem specified in

dao.properties file in '/DCDRUNTIME/config' directory.

 

Perform the following:

1). Check the contents of '/DCDRUNTIME/config/dao.properties' and find

'jdbc.db2.dbUrl=jdbc:db2://host:port/location' definitions.

2). Check the DB2 subsystem configured in dao.properties for any security violations in either xxxxMSTR or xxxxDIST coming from DCDADM or DCDCONTL.

3). Check if DCDADM has permissions to issue query 'SELECT ENCODING_SCHEME FROM SYSIBM.SYSTABLES WHERE CREATOR='@[email protected]' AND  NAME = 'CLASSIFIER';'

Note: @[email protected] value has been configured during DCD Install/Configuration and can be found in the dao.properties as 'jdbc.db2.dbQualifier'.