IBM Support

"SQLCODE=-109, SQLSTATE=42601, SQLERRMC=IN" error when creating new database inside Controller Configuration,

Troubleshooting


Problem

Customer is trying to create a brand new (blank) Controller database. DB2 DBA creates new database, and runs scripts to prepare it for Controller use. Afterwards, administrative user launches "Controller Configuration" and selects a database connection. User starts the standard (Java-based) "Database Conversion Utility", and chooses "Controller DB". User clicks "Connect" and chooses "Create DB". After a while, an error appears.

Symptom

...Running script: script/db2/table_disabled_triggers.sql
Running script: script/db2/index_unc_xdb00_ino.sql
** ERROR: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-109, SQLSTATE=42601, SQLERRMC=IN, DRIVER=3.59.81
** ERROR: Invalid datbase, XFRANGO is empty

Cause

DB2 database was created incorrectly.

More Information
It is important that the DB2 database is created with the correct parameters for Controller.

  • TIP: For an example of a correct script, see separate IBM Technote #1570572.

Environment

Controller database hosted on DB2.

Diagnosing The Problem

The message "Invalid datbase, XFRANGO is empty" is generic. Instead, the important factors are the DB2 errors:

  • SQLCODE=-109
  • SQLSTATE=42601
  • SQLERRMC=IN

Resolving The Problem

Fix:
Delete the DB2 database, and create a new one with the correct parameters.

  • TIP: For an example of a correct script, see separate IBM Technote #1570572.

Workaround:
Depending on the original script (that created the DB2 database) it may be possible to successfully use the 'legacy' version of the Database Conversion utility instead.

Steps:
  1. Logon to Controller application server as a Windows administrator
  2. Launch Windows Explorer, and double-click on the 'legacy' version of DbConv. TIP: By default, this is located here: C:\Program Files\IBM\cognos\c10\legacy\DbConv.exe
  3. Browse to the UDL file (e.g. C:\Program Files\IBM\cognos\c10\data\myconnection.UDL)
  4. Click "Create Db"
  5. When this stage is finished, click "Run Steps"
  6. When this stage is finished, close the legacy database conversion utility
  7. Now launch "Controller Configuration" and launch the 'standard' Database Conversion utility (in the 'normal' way)
  8. Notice that the 'Current Version' (e.g. 833) is less than then "Upgrade to" version (e.g. 874)
  9. Click "Upgrade" to finish the upgrade process:

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21579333

Page Feedback