DSXchange

Code: Select all

Job Sequence compilation involves the pre-compiler in the Designer creating a temporary file containing XML on the client, in the C:\Program Files\Ascential\DataStage directory. It looks awfully like the next part of the process, that generates code from the XML instructions, cannot find or read that file for some reason. This might be because of your use of Citrix, but I'm not really sure. 

One thing you could try is - if you press & hold the CTRL key at the same time as you click the Compile button, AND HOLD IT DOWN ALL THE WAY THROUGH THE COMPILE SEQUENCE, the interim file gets left behind. Its name looks like: yourjobname_dsintermincodegen.xml. If you see one of those created in the above directory, it's being written OK and it's the reader that can't find it somehow. If you don't see it created, then the Designer for some reason can't write to that directory.

Code: Select all

Proper rights should be given to the folder C:\Program Files\Ascential\DataStage so that the xml file used for compilation can be written. It means all the users who need to work on DataStage should have write permissions to this folder. This situation arises when using a remote interface like Citrix to work on DataStage. In this case multiple users from offsite will connect using Citrix to the same m/c on which the DataStage client is installed. So, all these users should be given write permissions to C:\Program Files\Ascential\DataStage folder.