DSXchange

Please start your own post, and stop asking U for help.

Answer the node question.

For the first question, I'd look into the dssearch command. For the second one, the various DSGet functions like DSGetJobInfo, DSGetStageInfo, etc, or their command line dsjob equivalents.

"xfm" would mean a transformer stage.

Right... that mention of a 'Computed blink' means corruption, typically from a massive amount of entries pushing it over the 32bit addressing 2GB barrier. It needs to be addressed.

What exactly is your target database?

Hmmm... stopped when I saw "Message: OCI_ERROR: Bad Oracle environment", which is why I asked about the dsenv file.

If one needed the stats one could, I assume, actually introduce a copy stage between the two and set the option in it to Force it to be kept in the flow. Yes?

That's correct, it logs the command executed (past tense) and the result, the 'output' of the command. Does that change your problem/issue? Are they actually working as desired?

My way didn't work out but yours did. Thanks.

$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/rdbms/lib32

This is overkill and it needs to see the 32bit libraries rather than the 64bit ones. For Oracle, all you should need is $ORACLE_HOME/lib32 in your LD_LIBRARY_PATH.

Can you post the contents of your dsenv file, please?

It's an environment variable. As noted, though, I doubt it would change your Server job's behaviour at all as it is a PX specific variable.

sshettar wrote:note: we also created a project with nls disabled

And Oracle jobs in that project throw the same error? Or work fine?