DSXchange

I don't know if this problem existed at v5, so it is hard to guess at what the root cause of your problem is. If you can open and compile the job then there ought to be no impact on runtime, but if you can't then it is likely the job won't run.

How long have you waited? Sometimes when the log file is huge it can take 10, 15 or more minutes to refresh the detail view. You can change to the directory and see if one of the RT_LOG<nnn> files is much bigger than all others.

This is a known issue at 7.1 and you need to request a patch for your client from your support provider.

Reindexing should not take a long time unless your project has many jobs and entities and your system is overloaded. Most likely you did not get rid of all users on the system and the reindex is waiting for some file lock. Are you certain that all users have exited the system and that no jobs are ru...

I took a look at the files and trobinson is correct, the config file that was used is embedded in the dataset along with the schema and file locations. But looking at the orchadmin options it seems that the locations listed as the paths to the data files override any config file inherited attributes...

If you write to a peek stage instead of the dataset does it work correctly?

Have you changed settings in your dataset (execution mode, partitioning, update policy)? Does the log file show that records were going into the dataset?

But what is not working? Are no rows being written to your data set? Are the values wrong? the row counts?

Hman,

what is the problem you are getting with parallel mode? All you've told us is that you are not getting entries in the log file.

I had a similar issue a while ago with 7.1 and I could never figure out the problem - the same sequence of keystrokes with my userid on another person's PC would work just fine, but on mine it could take 10 minutes before the screen refreshed. I finally got rid of the issue by doing a client reinsta...

rachelsu, it should not be that slow. Perhaps there is something wrong with the file itself. I'm not at a DataStage machine right now, but I seem to recall that this is not a dynamic file (it doesn't need to be, as it holds only a couple of records). I'll post the file name once I get to a machine (...

Anna, no, the CONVERT function is useless in this case since the poster wants to convert one character into a sequence of 4 characters. CONVERT('&','&AMP;',In.Column) will not do any changes at all to the value, It will replace "&" with "&" and the rest of the resulting to-conversion...

The reference hashed file needs to be updated from somewhere.
Can you not update your hashed lookup file in your main server job when you insert new rows? This is the most common method of keeping such a lookup file up-to-date.

Diya, there is no equivalent to the server ereplace function in a PX transform stage. You can find an occurrence with INDEX or replace one character with one other character using CONVERT but for more than that you would need to write your own short c++ routine.

Meena - the call to

Call DSU.GetParameter(STS, "STS", RefFile)

needs a job handle for the value of STS, this is returned from a call to DSAttachJOB(), which you don't have in your routine.