DSXchange

Errors of that nature generally indicate a bug, best to contact your official support provider for assistance.

OK... let's start with the columns it called out: HEAD_DISCOUNT, QTY_INVOICED, PRICE, STD_COST. How are they defined in the job and in the actual source? Is there anything different about those three fields than any of the others in that regard?

abyss wrote:what's i want is to set BOTH end of line character AND pipeline (|) as finial delimiter.

Seems to me you might mean OR rather than AND.

If so, there is no OR in delimiters.

ps. You can't use BBCode (like code tags) in your post and expect it to work when you turn on the 'Disable BBCode in this post' option.

Fixed.

No-one here is sitting on a list like that. You'll get some tips from people on specific / general issues they've run into but there's no exhaustive list. As noted, go back to the source / vendor and the release documentation. You need to assume that any of them could be problematical and prepare fo...

You have no control over the filename other than you provide the 'base' name in the stage and it numbers them from there. You will need to script something to run afterwards to rename them according to your business rules.

Characterset issue.

What is the characterset of your target database?

Kind of hard to help without details or eyes on. Still wondering if this job does anything 'unusual' so details around what kind of UPSERT you are doing in the OCI stage, properties / settings / etc. I'm also curious if you're certain that is where the error is coming from - can you post the complet...

The only support for multiple clients installed on the same host is via the MCM which means only one can be operational at a time. As noted, you'll need another Citrix host.

From a quick search, it seems there's no database behind this at all - it is flat file index structures instead? And it looks like there's an official ODBC driver.

I wonder if it is related to the resolution I get to here. Granted, mine said "map" and yours says "open" but still... any chance there is a disparity in bit-ness of the two servers? Or the volume processed is higher in Dev than Test? I'm assuming from your statement this does wo...

That version is about as old as they come and far out of support.

Anything 'unusual' about the job design? Say, for example, are you processing a CLOB? Posting the details of your job design may help us help you.

Again with the repeating of everything. :? Ernie, we've already had the "you can't just split it" conversation since Joyce had previously confirmed they will be consumed individually. And I'm guessing that it really does fall into your "ridiculously primitive" camp of XML if the ...

You make one up if need be, it doesn't even have to be part of the output from what I recall by not giving it an XPath Expression. And do I understand correctly that you have two writers writing to the same sequential target simultaneously? If so, that's not going to work I'm afraid.

It's a documented option in the old 'XML Output' stage, when the value changes it switches to a new filename. If you are using the new XML stage then Ernie has spelled out how that works here.