DSXchange

#1.

Talk to your DBA about "ORA-00054: resource busy and acquire with NOWAIT specified". The table is in use and so can't be bulk loaded.

That one remains... unresolved... at the moment.

You'd have to have been granted telnet access to that server, which is separate from ftp access... do you have that?

We created a routine that is called in a stage variable derivation when something fails that should never fail, typically a reference lookup. It calls 'UtilityAbortToLog' from what I recall, which allows us to not only abort the job but also record in the log why we are aborting it.

Glad you got it sorted out. Let's see... 1. Because NLS_LANG is a combination of several values. 2. Not entirely sure. No, it doesn't get set to the same value as NLS_LANG, it has its own set of values. Type 'locales' from the command line to see how all of them are set. Or maybe it's 'locale'... I ...

You must have the parameter setup as an Integer with that error... perhaps just change it to a String?

It's not complaining about your Sequence object, it's saying the "TEST_ID" field does not exist in your "TEST_SEQ" table.

The 'dot' or the 'V' are legal... not both.

h?

You must have specified a Trigger Column which tells it to do that each time the value in that column changes. Don't do that.

Yes - which will still require a wrapper script to restart 'automatically' from cron. The job sequence itself will need to handle where exactly to restart from.

Right... but... my point isn't about individual jobs only. How can cron 'restart' anything on failure? It can't, hence the need for a script. The point as to whether the script is running one job or a sequence of jobs is moot.

just4u_sharath wrote:can anybody help with this error pls

In other words, no. At least not with a lot more information.

Restartablily could be handled only by Datastage. Not really. Whatever outermost job controls a series of jobs cannot restart itself. You will need to write a wrapper script, something that is scheduled via cron and which starts the main job. Once the job completes, the script would need to check t...