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';]...
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.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.