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

Technote (troubleshooting)


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.


...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


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.


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

Resolving the problem


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.

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.

  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:

Related information

DB2 Error Codes
1570572 - How to create a brand new blank DB2 database

Document information

More support for:

Cognos Controller

Software version:


Operating system(s):


Reference #:


Modified date:


Translate my page

Content navigation