IBM Initiate MDS upgrade_instance failed

Technote (troubleshooting)


Problem(Abstract)

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

Symptom

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

BUILD FAILED

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


Cause

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

Rate this page:

(0 users)Average rating

Document information


More support for:

Initiate Master Data Service

Software version:

Version Independent

Operating system(s):

Platform Independent

Reference #:

1617953

Modified date:

2013-02-06

Translate my page

Machine Translation

Content navigation