DSXchange

Your error message says otherwise. Double-check.

Then it's time to contact your official support provider, it seems. Perhaps you are missing a patch... or the documentation is incorrect.

Please do not duplicate posts. You've should have simply put all of the detail in your new post into this one rather than start a brand new topic.

When I get some time later, I'll merge the two.

So you tested against a target table with no indexes but it has some in production? Hmmm...

As noted in the error you need to "Add an index option or drop indexes and rerun step", the "index option" is a property of the stage.

"Not getting correct data" isn't all that helpful. What exactly are you getting in your target?

No. Define "didn't work". Tell us what exactly you tried plus the output that you saw, then maybe someone can continue to try and help you.

Then some change has been made to your system and messed you up. Why is it looking for a 10g client? Sounds like a new version of Oracle may have been installed, talk to your DBAs and see.

The second table would actually be DS_JOBOBJECTS and in addition to simply querying them, you could also use LIST.DICT to see their structure. But, as noted, they are not officially documented. You could also use those tables in a Server job via the UV stage set either to localuv or by specifying a ...

There are several posts on that topic here, including this one which seems to have all of the relevant points in it.

Make sure your Hash partition makes sense for the data - typically it would be over the keys used in the update to identify the record - is that what you're doing?

No idea as I've always used either the 'column generated' option (but that would be in Server, pretty sure there is an equivalent in PX) or just gone user-defined. I think that Query Builder is there only to say they have it but found it combersome to use, from what I recall an update to the query r...

All jobs, just this job? Ever used the OCI stage before or is this the first time? Have you configured your dsenv file to add the Oracle variables?

There seems to be an echo in here.

So, is this truly resolved or not? If so, can you share that resolution with us please?

Ah, yes... thanks for the clarification on the exact spelling of the daemon and what "res" stands for. I remember it now but it has been awhile so the details were not forthcoming. I never saw a need to change that setting and honestly never really realized it wasn't relevant for DataStage.

Simplest answer is you change it so that "start" is a "1" for true rather than the zero that means false. The timer means it will check every 900 seconds - 15 minutes. Not sure about "res" (resident?) but log would allow you to override the default log file name/locatio...