IBM Support

Information Server Match Specification step fails to update Database.

Troubleshooting


Problem

Information Server Match Specification step fails to update Database. The following error may occur: Resource bundle corresponding to message key return code {0} from SQLConnect(handle, {1}, ****, {2}) with message {3} not found! Check that DSHOME or APT_RESPATH is set. ##F IIS-DSEE-TDOD-00004 14:00:06(002) Fatal Error: Could not connect to datasource?? (-1; DBO_IADB; Oracle_dev; [DataDirect][ODBC lib] Data source name not found and no default driver specified)

Symptom

Information Server Match Specification step fails to update Database.

Resolving The Problem

While testing with the Match Specification Database functionality and you encounter the above error, but you are still able to successfully "Test Connect", confirm the following in the environment you are testing in:

  • Confirm the .odbc.ini file has the dsn name included that is being referenced in the Match Designer configuration drop down tab.

[{"Product":{"code":"SSVSBF","label":"InfoSphere QualityStage"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF033","label":"Windows"}],"Version":"8.1;8.0","Edition":"Enterprise","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 June 2018

UID

swg21427575