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¨
Release:
Component: DCD
DCD 2.0 New installation
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.
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.