error with Oracle 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
anandkumarm
Premium Member
Premium Member
Posts: 55
Joined: Tue Feb 24, 2004 8:17 am

error with Oracle stage

Post by anandkumarm »

Hi
I am having a problem with OraOCI stage when I try to view the data

<Oracle_Enterprise_0> Error occurred during initializeFromArgs().

Incorrect dboption list; it failed on Expected "," or "}", got: "$", line 1.

Creation of a step finished with status = FAILED.

I am able to connect to the same database using the server jobs but i get the above error if I do the Parllel jobs

The id and the password is correct the name of the Remote server is also correct.....

I have a question here...will there be any problem with the stage if the password has special charecters in it??????

thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Server jobs don't need them. Parallel jobs need them to determine whether the table is partitioned and, if so, how. Server jobs simply operate in sequential mode, whether or not the table is partitioned.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply