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

Technote (troubleshooting)


Problem(Abstract)

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:

Related information

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

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Controller
Controller

Software version:

10.1

Operating system(s):

Windows

Reference #:

1579333

Modified date:

2012-10-18

Translate my page

Machine Translation

Content navigation