Using DataStage 7.5.1.A on Oracle 10g:
We have a server job which simply loads data from a view into a table within the same db schema ("manual" materialization of an oracle view).
Like this:
Oracle stage (view) -> Transformer with 1:1 mapping -> Oracle stage (table)
When called within a normal Director run (initiated from a sequence within a larger run where a lot of other data are loaded) the job fails approximately 1 out of 2 times with:
ORA-08103: object no longer exists
on the Oracle "input" node.
When run directly from Director (i.e. when starting the job directly in isolation) it never fails.
Also, when run from within Designer, it never fails.
All job parameters are global, and given default value $PROJDEF. No parameter values are passed from the calling job sequence. The view errors on ORA-08103 is not referenced any other place in the project than in the Oracle input node mentioned above.
Any suggestions on what is causing this and how to fix it?
ORA-08103: object no longer exists in simple Server job
Moderators: chulett, rschirm, roy
Generally considered to be an Oracle bug.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers