DSXchange

Various methods - try talking to your DBA regarding what is happening on the database side. I think that "truss" is installed as part of the MKS toolkit, so you should be able to use that on your process to see which system calls are being executed, if any.

Yes.

I can create a Windows ".exe" file from notepad, or save my Word document with an ".reg" extension; so why shouldn't I be able to save a fileset with a dataset extension? The names aren't important, just the contents. You can use the unix command "file {filename}" to have unix tell you what the file...

1. You can name the file however you wish with any ending.
2. No, lookup filesets cannot be viewed.

Craig - now Nigel from UK support no longer just thinks that I am an idiot, he knows it...

[edit]Darn, and I thought I wrote that into a PM, now it is here for all to see...[/edit]

How have you "cleared/unlocked" the processes? At V8 I would go through the IIS web page administration to identify and get rid of errant processes.

I haven't seen that on UNIX, though. I just closed a call I opened regarding DSParam file changes not showing up in the Administrator; it turns out to be a "customer error" since one needs to enter data in both the [EnvVarDefns] and [EnvVarValues] sections.

This isn't possible. Are you 100% certain that you chose ....../Projects/DEV/DSParams?

Could either of these two names be used as column names as well?

These variables are stored in the project directory in a file called "DSParams"

Can you export your column definitions to the metadata, then load them into your column generator stage? Usually the reason is that the column really are not in synch, so doing this would guarantee that the two input metadata definitions are identical. If the error is still there, then you will most...

Does "Code_Name" not occur anywhere in your job or just not in this lookup stage? What is your lookup reference stage (if it is a DataSet then check to see if the DataSet schema might contain a field of this name).

Are you using RCP (runtime column propagation) for this stage and any predecessors?

What StringToDecimal options did you try and what was the result?

The more information you supply, the better the response will be. Please post the Oracle error messages (in their entirety) to get a qualified answer.