IBM Initiate MDS upgrade_instance failed

Technote (troubleshooting)


When applying a patch on the MDS engine, the madconfig upgrade_instance failed.


The error message is similar to the following:

Running ODBC SQL statement [select keyval from mpi_syskey where keyname = 'ALIGNDEX_VERSION';]...
Executing /opt/initiate/Engine9.0.0/bin/madsql

Return Code: 0, Time elapsed: 0.196 sec


java.lang.NumberFormatException: empty String BSF info: ant_condition at line: 0 column: columnNo


Record missing in mpi_syskey table

Diagnosing the problem

Run the following sql query : select * from mpi_syskey;

Verify that a record returns back. This error will occur if nothing is returned.

Resolving the problem

Insert a new row into the table that matches your current version.

insert into mpi_syskey values(1,1,'A','ALIGNDEX_VERSION','9.0');

You will need to replace '9.0' with your correct version.

Related information

A simplified Chinese translation is available

Document information

More support for:

Initiate Master Data Service

Software version:

Version Independent

Operating system(s):

Platform Independent

Reference #:


Modified date:


Translate my page

Content navigation