DataServices 3.1 AIX/DB2 problem with CountryID Cleanse transform

[Former Member]

This is a brand new installation of DS 3.1. Created a simple Data Cleansing job to test DQ part of DS. Country_Id transform returns error about missing xml files on local computer.The path shown in error log is c:\...(etc. Windows path). The xml file does exist in the same location but on the server, where it should be looked up. Is this is a licencing issue, we have temporary licenses.

[NielsWeigel · Accepted solution]

Hi Mahir,

the CID transform uses by default the Substitution Parameter [$$RefFilesAddressCleanse] to search for the necessary directory information.

You see this if you open the transform configuration and take a look at the options panel.

It sounds like on your installation you have the Data Services installed on your IBM AIX system and use the designer from the Windows based Client and during installation this Substitution parameter has been set to point to a local directory on you windows system instead to the server side installed directory (...\DataQuality\referencedata).

Can you check in your Substitution Parameter Editor (in DS Designer under Tools--> Substitution Parameters Configuration...) if all of your Substitution Parameters are set to the local machine?

Niels