DSXchange

Ummm... 'fails' how, exactly?

What do you mean by they are "completely ignored"? Are you saying that, even with the reject link, nothing goes down it for a FK violation?

That's certainly one way. The specific Oracle APT variables are mentioned here. And yes, a "direct path load" does no commits, that whole mechanism is bypassed which is part of where the speed comes from.

With 43200 seconds.

Hard to say. Have you involved your official support provider yet?

In other words, while you cannot conditionally execute anything before/after job, you can embed the 'condition' into what you execute.

Sans a debugger, I normally do as Arnd notes - breadcrumbs are number one, logging anything that might shed some light on the subject. That and the 'create a test harness from snippets of code' trick and running them standalone from the Manager via the 'Test' functionality.

I've found the Cleanup Resources option to be the simplest solution 99% of the time. Yes, sometimes you need to dig a little deeper and know the job number you are looking for, but very rarely do I find a need to go under the covers for a solution.

And, of course, the deadlock daemon.

basu.ds wrote:I don't have any zip software installed in my windows system

First step - get some. All else is for naught otherwise.

I don't see an issue, provided as noted that you stay on top of the runs with an appropriate auto-purge setting.

FAQ posting on this very subject. FYI.

Similar, perhaps, but not the same. Please start your own thread so we have your particulars - version, edition, etc etc.

Are you perhaps asking for too much heap or using an illegal configuration option? Um... no. :? FWIW, I was seeing similar messages / errors on the initial attempts to connect with my 8.1 client, including the one noted above. Changing the HeapSize values in the proxy didn't make any difference. It...

Same way.

While amusing, it was a legitimate attempt to help and hopefully that link actually yields some results for them. Seemed like it would to me when I checked the results it found.