DSXchange

If you've been searching, then what you should have found is that whenever anyone mentions "special characters" the first question is to ask what "special" means to the poster. :? You need to let us know that before people go off on tangents and give inappropriate suggestions. Me...

So... these errors come when you try to write to Oracle? You need to answer the NLS question - what is the NLS_LANG setting for your Oracle database?

Two links from the job, one "OK" one "Otherwise", to a Sequencer set to "Any" is considered handled. Per the documentation.

My days were the same days, so bear that in mind...

Wouldn't you just read one byte at a time and transfer it to an output buffer as long as it's not 0a and when it is, flush the buffer? Something like that?

Still... did you try other values?

No, as they're not stages that 'fail' like a Job or Routine Activity could. Best to read the docs and understand the option rather than just turn it on or off.

So... we're good? Switching to convert worked for you? Ah, yes - "Thanks....its solved ...i have used convert instead of trim" - messages in subjects only show up when someone replies - something to keep in mind. Please mark the thread as Resolved using the button at the top of the screen!...

Seems... high. What is your ARL, average record length? Does it help if you drop it down to a smaller number, say like 500 or 1000?

Thanks, always best to search first as (more than likely) you're not the first to encounter the problem.

Well... that's how that "automatically handle" option works - it handles ones you don't and 'unconditional' doesn't count as 'handled'. Read the docs for that option, it explains how it works.

If you are going to suggest something, please break the Magician's Code and explain how to make the 'trick' work at the same time.

Okay... Array Size?

Are you doing the upserts in the 'right' order, meaning whichever action has the best chance of succeeding first? For any updates, are you updating on indexed columns?

Can you share the actual errors, please? Not that I can help but it would be useful information for someone who could.

Is 'upsert' really necessary? Can you use a native Enterprise stage instead? Would help to mention the target db as well.