ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Startup of the DCD DCDCONTL task encounters the failure: bad SQL grammar sqlcode -204

book

Article ID: 187588

calendar_today

Updated On:

Products

Data Content Discovery

Issue/Introduction

Startup of the DCD controller encounters the failure for autodiscovery:

Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [DELETE FROM AUTOSCAN
                                     
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DCDADM.AUTOSCAN

Cause

Prescribed holddata steps were not performed. 

Environment

Release : 3.0

Component : CA DATA CONTENT DISCOVERY

Resolution

Performing the holddata steps for FEYADB21, FEYADB22, and FEYADB23 corrected the -204 error.