Error on executing Oracle Enterprise Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rajeev_prabhuat
Participant
Posts: 136
Joined: Wed Sep 29, 2004 5:56 am
Location: Chennai
Contact:

Error on executing Oracle Enterprise Stage

Post by rajeev_prabhuat »

Hi,

We are trying to load data from dataset to Oracle Enterprise stage, and we are doing the Truncate and Load method, and the target table is not partioned. But when the job is run i am getting a fatal error as follows:
Oracle_Enterprise_1: Could not place an operator for each partition.
main_program: Could not check all operators because of previous error(s)
main_program: Creation of step finished with status = FAILED
Have anyone come across this error if so what is the solution for this.

Regards,
Rajeev Prabhu
T42
Participant
Posts: 499
Joined: Thu Nov 11, 2004 6:45 pm

Post by T42 »

This is not due to Oracle. This is a DataStage error. You need to ensure that your APT_CONFIG_FILE is correctly set up. Review the chapter on "The Parallel Engine Configuration File" (Chapter 11) on "DataStage Manager Guide" (man_gde.pdf) on how to set up your configuration file properly.
Post Reply