DSXchange

Varchar fields are stored at their full size, from what I recall.

Me thinks the problem lies here. :wink: For ParamNum = 1 to ParamCount Param(ParamNum,1) = Field(Field(Params,'|',ParamNum),'=',1) Param(ParamNum,2) = Field(Field(Params,'|',ParamNum),'=',2) Next ParamNum You've specifically just pulled everything before the second equal sign and left the rest behin...

You've got single quotes in the parameter so you'd have to use double-quotes around it. Can you post your routine so we can see how you are passing this?

Is this from the command line using dsjob? Have you tried quoting the entire string?

Still unclear what the data type of your actual target field in the Oracle table was for this field. Are you saying you were able to load this to some kind of NUMBER field by calling it "unicode"?

XML files don't have "records" in the sense that a traditional flat file would. As noted, about all that makes sense are the number of records that you sent to the stage.

There are a number of optional plug-ins one can select when installing the server component, most of the database ones for example. I would check that branch in the Manager in the 7.x project and make sure anything you are using there is also installed in the 8.x project. If your only issue is with ...

So, in other words, the status flag needed to be reset - something you could have done right from the Director.

Marking as Resolved.

Actually, I randomly picked one of the two to delete, neither had replies when I did so... guess I picked the wrong one.

I quoted right from the supplied documentation, check out the XML Pack Guide pdf that is part of that suite.

Why have 'load options' when there is no loading going on?

If your Oracle stage's Execution Mode is parallel, try setting it to sequential.

OK... can you describe the job in more detail? For example, how many transformers does it include? I'm guessing... more than one.

It would be helpful if you answered the last question asked. Also, can you post a snippet of the actual xml and some full examples of your XPath Expressions? Thanks.

Then you've got a partitioning issue. Can you describe your job design - stages, partitioning settings per stage, etc?

By any chance were you replying to a post much like this one when it happened?