DSXchange

There's no "string" function - you use the square brackets with your string field to substring it.

The plugin import doesn't have the 'fall back' option in it that the client does, so it uses TNS_ADMIN when set whereas the client will check it first and fallback to the standard '$ORACLE_HOME/network/admin' location when it can't find the specific entry there. You only need TNS_ADMIN set when the ...

Odd... have you run this problem by your DBA?

Rerun the Server install. It will go into 'Maintenance Mode' and allow you to (amongst other things) do 'Plug-In Maintenance' - install any you missed the first time around.

To me it is more straight-forward than the 'package installer'.

"02 10 * * *" says to run it at 10:02AM every day. Is it not running then? I would suggest redirecting std out & err to a file to see if it is running then and something is going wrong.

Searching for a common (non-unique) part of your error - "did not finish OK, return code =" for example - would have revealed many conversations on this topic.

You need to be the specific one here, otherwise the answer to the "Can I?" question is just "yes". What caused your job to abort? What errors were logged?

Well, hopefully Ray will be back real soon with his "actually easier in Server jobs" solution.

If you want "07" for the month, don't use "A3" in the OConv date mask. Once you have the date you can use Field to split the pieces out, or just substring them.

Sorry, but what "string" are you talking about and how exactly are you using it "inside the transformer"?

So... is this working properly and all you are asking is how to get rid of the message or do you still have a conversion problem?

What is it? 'Delta' means 'change' in this context.

I think this has been posted before - if the MJC throws the error but you can compile them individually just fine, then it's a bug.

Post samples of your date data and the actual derivation you are using.

Ran out of disk space?