IBM Support

"DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704" when connecting to new Controller DB

Troubleshooting


Problem

Administrator is attempting to connect to (or create a new) Controller database, which is based on DB2. Administrator launches Controller Configuration, and launches the 'Database Conversion Utility'. User clicks 'Create DB'. An error appears. throws an error that includes "DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=.USER_TABLES".

Symptom

When the 'Create DB' button is pressed:


    Creating new empty Database
    Running DB Step: initial
    Running script batch: script/db2_createDB.batch
    Running script: script/db2/sequence_xdbtrickle_seq.sql
    Running script: script/db2/table_xdb00.sql
    ** ERROR: com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=DECLARE
    sSql VARCHAR2(4000);
    BEGIN ;BEGIN-OF-STATEMENT;<create_proc>, DRIVER=3.57.82
    ** ERROR: com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=<UserID>.USER_TABLES, DRIVER=3.57.82

When the 'Connect' button is pressed:
    ** ERROR: com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=<UserID>.USER_TABLES, DRIVER=3.57.82
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3.1;10.3;10.2.1;10.2.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

link to actual document

Document Information

More support for:
IBM Cognos Controller

Software version:
10.3.1, 10.3, 10.2.1, 10.2.0

Operating system(s):
Windows

Document number:
480309

Modified date:
08 May 2025

UID

swg21613531

Manage My Notification Subscriptions

Page Feedback