DSXchange

What happens when you run the job? Are those last "-1" records processed or skipped? Skipped records indicate a metadata issue. Typically.

Then you need to address the root cause of the error. Do an exact search for "The modify operator keeps field" and see if any of the matched posts help.

So are you saying the that ".ds" descriptor file no longer exists? If so, you can remove the datasets manually and then rebuild everything by running the job again.

No, the monitor shows the number of requests sent to the database. Your job's log detail should show any issues it had fulfilling those requests.

Suggest you repost this in the proper (Enterprise) forum and... finish your sentence.

FALSETRUE?

Unless the data is sorted on the grouping keys and properly 'asserted' in the stage, the Server aggregator stage will fall over dead if you push 80M records into it.

If the UTF-8 approach runs successfully and properly handles your data, that sounds like a perfectly good/correct solution to me.

Are you're certain you've spelled the job name correctly, case and all? Can you do a simple "dsjob -jobinfo" on it?

I don't believe you can redirect any errors like that. From what I've seen, they'll go into the job's log. Be happy to be proven wrong, however.

Then tell us what exactly WORKDIR and SCRIPTDIR are. That should lead you to the answer.

eostic wrote:Data Elements are a concept whose usage was never fully appreciated and now they are like your appendix.....has a little bit of value, but goes mostly un-used.

Sad but true.

They're not supported but you may be able to CAST it to a varchar in your source sql. Or use the dbms_lob.substr function there. This may work better over OCI in a Server job than in PX.

No, he means your "timestamp" value doesn't map to "%yyyy-%mm-%dd %hh:%nn:%ss". Post examples of your input format and the derivation you are using.

How exactly are you 'parameterizing' the information? For instance, are these 'normal' job parameters or are they environment variable based? Parameter set? What?