I have a job which does a simple select... from a table into a sequential file.
On occasion the job fails to do the select and finishes almost immediately.
Looking at the log, it has lines:-
(NB I have replaced the actual jobname with the word jobname in these below)
Environment variable settings:
Finished Job jobname
When the job runs normally, the log says
Environment variable settings:
jobname..monthly_sum_file.IDENT1: DSD.StageRun Active stage starting, tracemode = 0.
jobname..NEW_IC_MEASURES: SELECT CUSTOMER_KEY, etc
jobname..monthly_sum_file.IDENT1: DSD.StageRun Active stage finishing.
13128444 rows read from DSLink13 etc
Finished Job jobname
Any ideas?[/i]
job fails to do oracle select... extraction into sequential
Moderators: chulett, rschirm, roy
Not really. I've seen times where it would say that it was starting and then nothing. The outermost Status view would not change, still showing the last successful run stats, but inside you'd see the new starting info and then nothing. That was a bug, apparently. This...
Are you managing your Phantom directory in your project? Specifically, the &PH& directory, does it have a large number of files in it? Grasping here, but that can cause some "odd" behaviour at times.
Are you managing your Phantom directory in your project? Specifically, the &PH& directory, does it have a large number of files in it? Grasping here, but that can cause some "odd" behaviour at times.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I've seen this when the OCI stage using a version of Oracle client that is not the same version as the database. In other words, you're using an OCI8 stage to connect with 8i sqlnet pointing at an Oracle 9i installation. Unexpected errors may not be covered and cause weird results. Just doublecheck that you're using the supported versions of all components involved.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle