DSXchange

Search for those messages here, you're not the first person to ask about them.

Try an exact search on "JNIWrapper: load library failed".

I don't know... perhaps one of your input datasets does not have the field "sstatus"?

I don't think that DecimalToDecimal function would help here, that rtype argument is all about rounding: floor, ceil, trunc_zero, etc.

There's no "rollback" for any kind of Oracle direct path load, they're not transactional. You'd have to force the slower (transactional) "conventional" load with DIRECT=FALSE to have any hope of this.

Right, you're talking about an implied decimal here so you have to help out and divide appropriately.

We've discusses this a few times lately. Since there's no background activity for commands, they are blocking operations. From what I recall, you may be able to build three other Sequence jobs that each have a single Execute Command stage in them and run those just after the Sequencer. Or a single s...

Is your issue the same as this issue? Sure seemed like it, which is why all of the replies went into one thread rather than both.

viewtopic.php?t=131059

I don't believe so.

There should be three stars after the resize, not sure what difference it makes however. Please mark this as Resolved using the button at the top of the page.

Explain exactly what you mean by "i have attached 3 Execute_Command stage for executing 3 shell scripts in parallel."

I can't help, but if nothing comes of your question here I would ping your official support provider for that.

Please post the complete unedited error message(s) that are logged. Are $ASBHOME and $ASBNODE set as well? And I don't believe that Windows uses a LIBPATH like UNIX does.

I don't know about 3x slower but 8.x jobs are known to be "slower" than their 7.x brethren. Your two "-log" calls from the command line may be the worst culprits... are your logs in the XMETA database or in hashed files?

Wrap your sql into a script using the command line for your database and then use DSExecute in a routine to call and check it after job.