Monday, October 3, 2011

DataStage Director Client: Run-time error '13': Type mismatch

We went round and round with IBM on this for several months until they finally suggested the following which works beautifully and simply to get rid of this useful-to-no-one error message:
  1. Examine the file C:\IBM\InformationServer\Version.xml to determine the clientTagId (or this could be on your D: drive or wherever you have DataStage installed). Example: <InstallType client="true" clientTagId="0a045bd2-09cd-4b80-a158-ac1cb63c8268"
  2. Run "regedit"
  3. Navigate to "HKEY_CURRENT_USER\Software\IBM\InformationServer\DataStage Client," find the key that matches the name from step 1.
  4. Rename it to <key name>.bak
Run the Director client again. You should see that none of the previously defaulting information is filled in (host name, user name, etc). This indicates that a new key is being created. Once you authenticate, you should see that the run-time error is now gone.