DSXchange

It was better when it as "too small" - now it's "too big".

When you did an "ls -l" on the environment variable, why did two files get listed? Echo that variable.

It is a "plain text file". However, it is a dump of your bad data so what you are seeing is what you were trying to load. Make sure you are viewing it with the correct characterset.

If you're certain it exists, check the permissions it has.

No, it's not. You cannot have "a file" that you "created for 2,4,8 nodes". Each combination of nodes requires a different file.

Or course there are many ways, that was only the opening salvo.

The whole point was to understand that you must process something to have any output. Or as noted, use a job that just handles the 'nothing to do today' part and run one or the other.

suneelchallagali wrote:Here is the config file i have created for 2,4,8 nodes

Now, if i want to update only the required columns, i think the only way is to use multiple oracle stages. which i dont want to do.. Want or don't want, doesn't matter. You'll need multiple stages. A Server job would support multiple links into a single stage but PX doesn't. Or as you've noted, you...

That is a "one node" config file.

What are you selecting? This issue could also be in your 'where' clause.

ORA-01426: You tried to evaluate an expression that resulted in a numeric overflow (or underflow).

You could also be looking at a 'range lookup' bug of which there were several, from what I recall. Time to involve your official support vendor, it seems.

So how are you 'trying to set the codepage' in the job? You can do it at the project level - set it to $ENV there, then add it to and override the value in your job.

I'm perfectly aware of the issues around trouble-shooting this error. :wink: You're talking about datastage instance ? No shutdown occurred. 'Instance' is an Oracle term rather than a DataStage term. I asked the DBA to investigate oracle logs. The DBA told me that in the Oracle log he found the TNS-...

Zero rows in equals zero rows out, I'm afraid. Can you union your input sql to include a 'dummy' row that you recognize as zero in your processing when that's all you see?

While the internal name is ORAOCI9, it's been called simply the "Oracle OCI" stage on the palette for quite some time now, well before the 8.x release. And, as noted, it officially supports 9i and 10g. Check your Connectivity Guide for Oracle pdf.