The DCDCONTL starts but UI gets HTTP 404 'The webpage cannot be found' DB2 SQL Error: SQLCODE=-551

Products

• Data Content Discovery

Issue/Introduction

The DCDCONTL starts but UI gets HTTP 404 'The webpage cannot be found' DB2 SQL Error: SQLCODE=-551, what needs to be done to correct these errors?

Symptoms:  

DCDCONTL log shows: 

 

DCD2511I DCD Controller - PC Services Initialization in progress 

DCD2511I DCD Controller - PC Services Initialization complete 

DCD2519I DCD Controller - Infrastructure build complete, initializing JVM 

Browser HTTP 404 More Information: 

This error (HTTP 404 Not Found) means that Internet Explorer was able to connect 

to the website, but the page you wanted was not found. It’s possible that the webpage 

is temporarily unavailable. Alternatively, the website might have changed or removed 

the webpage. 

Errors in DCDCONTL joblog: 

02016-05-18 19:24:45,906 Database exception in Category Dao 

selectAllCategoryorg.springframework.jdbc.BadSqlGrammarException: 

StatementCallback; bad SQL grammar Ýselect CATEGORY_ID, CATEGORY_NAME, 

SCHEMA_VERSION, CATEGORY_LEVEL, PARENT_ID, CATEGORY_VERSION from CATEGORY¨; 

nested exception is com.ibm.db2.jcc.am.SqlSyntaxErrorException: 

DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=DCDDB2 

;SELECT;DCDADM.CATEGORY, DRIVER=4.12.55 

2016-05-18 19:24:45,910 Exception in selectAllCategory 

2016-05-18 19:24:46,112 Received an exception and exiting Could not get categories 

com.ca.security.dcd.exceptions.DatabaseException: Exception in selectAllCategor 

at com.ca.security.dcd.dao.CategoryDaoImpl.selectAllCategory(CategoryServiceImpl.java:62) 

~ÝBatch-Client-Utility-2.0-SNAPSHOT.jar:na¨ 

at com.ca.security.dcd.service.CategoryServiceImpl.getAllCategories(CategoryServiceImpl.java:62) 

~ÝBatch-Client-Utility-2.0-SNAPSHOT.jar:na¨    

 

 

 

 

 

 

 

 

Environment

Release:
Component: DCD

DCD 2.0 New installation

Cause

The DCD User Interface fails(HTTP 400) because the DCDCONTL task cannot connect(DB2 SQL Error: SQLCODE=-551)

to the CA DCD DB2 DATABASE.

The SQLCODE -551 indicates the auth-id attempted to perform operation on object 

object-name without having been granted the proper authority to do so. 

 

Resolution

Problem caused by the CA DCD DB2 USERID that is used to access the CA DCD DB2 DATABASE

that is specified in the .CFEYJCL(FEYSQLJG) job GRANT statements is not the same USERID 

specified in the .CFEYJCL(FEYDCEKP) job which is specified as the donor userid that is used to

access the Data Content Discovery database.    

 

To resolve the problem insure that the same logonid is specified in both of the  .CFEYJCL(FEYSQLJG) and

.CFEYJCL(FEYDCEKP) configuration jobs.