job fails to do oracle select... extraction into sequential

[dzdiver]

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]

[chulett]

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.

[kcbland]

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.

[dzdiver]

I checked the versions and they are ok.
There were anly about 60 files in the &PH& dir.
On the next attempted run, the job ran okay :O
We made no changes between runs except looking at the logs and &PH& dir.
No idea what the problem is.