DSXchange

Ok, the password has to be decrypted before your O/S command can use it. There should be a 'Silent' version of ExecDODS you can switch to that doesn't log that information. If it doesn't exist, it should be easy enough to write one.

That doesn't make much sense. Can you post the log where you see the actual password? So perhaps we have some clue what is logging it.

Please start a new post for this. And when you do, be more specific in your needs and question.

Still, deletes without an index equals a full table scan per request. As requested - what is the abort when it does finally fail?

No, no screenshot but copy/paste the message from the log - do not type it in. Resetting is not meant to solve anything directly but rather help in the resolution. After the job aborts and you reset it, is there a message in the log saying "From previous run..."? If there is, double-click on it and ...

Define what you mean by "insert/update" - two separate links or a combo Update Action?

ps. Updates don't work so good without an index to support them, you know.

Then you *may* be able to use the dbms_lob package to help, talk to your DBA about it.

In this month, have you involved your official support provider at all?

You select whichever ones you need. If you are unsure, install them all but I'd wager some will never be used. Still, won't hurt anything.

Post the actual errors in their entirety. Also, Reset the aborted job and let us know the contents of any 'From previous run...' message.

thurmy34 wrote:The job abort because the Cust_Id field is sent with null value to the database. The row is rejected because a Cust_Id cannot be null.

And does this have anything to do with the hashed file we are discussing?

The Pivot stage is one of the optional stages - did you choose to install it on your test server? I wager... not.

This week.

Trick question.

Never said you could use it 'after job', just that it exists as an InfoType. What's the value of any attempt to find out when a job finished before it actually finishes?

An actual LONG, not a CLOB? Yuck. Definitely 'Not Supported' and a PITA to work with even in Oracle. What version of Oracle, btw?