Hi
I am experimenting with the Oracle OCI Load Stage using direct path loading and I dont seem to get a simple job to run. It is a simple job with one Oracle Source, Transformer and the OCI Load Stage. I am using the AUTOMATIC load option and hence do not specify any
Directory Path
Control File Name
Data File Name
as instructured in the documentation.
Delimeter is also not specified since the input stream does not have any delimitiers being read from an Oracle source. It is not though specified in the documentation.
The only error message I get is
Abnormal termination of stage DevFDMxStoreProcessedRecords..xfmRecords detected
Which doesnt say very much.
Does somebody have any tip on what the issue can be? I am using Oracle 8.1.7 client loading to a 9.2.0.5 database
BR
Oli
Problems with Oracle OCI Load Stage
Moderators: chulett, rschirm, roy
Hi there
I reset the job and only get the very explanatory information (NOT)
Job DevFDMxStoreProcessedRecords aborted.
Resetting Job DevFDMxStoreProcessedRecords.
Resetting stage DevFDMxStoreProcessedRecords..xfmRecords.
Finished Resetting stage DevFDMxStoreProcessedRecords..xfmRecords.
Job DevFDMxStoreProcessedRecords has been reset.
If you have a similar job that I could take a look at I would appreciate having a look at it. I might be doing something fundamentally wrong ?
BR
OLI
I reset the job and only get the very explanatory information (NOT)
Job DevFDMxStoreProcessedRecords aborted.
Resetting Job DevFDMxStoreProcessedRecords.
Resetting stage DevFDMxStoreProcessedRecords..xfmRecords.
Finished Resetting stage DevFDMxStoreProcessedRecords..xfmRecords.
Job DevFDMxStoreProcessedRecords has been reset.
If you have a similar job that I could take a look at I would appreciate having a look at it. I might be doing something fundamentally wrong ?
BR
OLI
More than likely. It could be related to the fact that you are mixing 8i and 9i.
To be honest, I've never had an occasion to even try the Automatic mode, we use the Manual mode exclusively. We have scripts that work through the large collection of extracted files we pull out of CDC and this gives us a greater degree of flexibility and parallelism when we handle this step ourselves.
Have you opened a case with Support?
![Confused :?](./images/smilies/icon_confused.gif)
To be honest, I've never had an occasion to even try the Automatic mode, we use the Manual mode exclusively. We have scripts that work through the large collection of extracted files we pull out of CDC and this gives us a greater degree of flexibility and parallelism when we handle this step ourselves.
Have you opened a case with Support?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers