Fatal error when loading an Oracle table

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
sumesh.abraham
Participant
Posts: 153
Joined: Thu May 11, 2006 1:52 am
Location: Bangalore

Fatal error when loading an Oracle table

Post by sumesh.abraham »

Hi All,

I'm loading data from a data set into an Oracle table. After the job is run, I get error as
main_program: Incorrect -dboptions option list; failed on Expected value for property "user".
main_program: Creation of a step finished with status = FAILED.
and the job is aborted.
I've defined the User name, password and DSN in the Oracle Enterprise stage using job parameters. Please let me know what causes this issue.

I also get a warning as
main_program: An NLS character map <ISO8859-1> is specified, but no entry was found in $APT_ORCHHOME/etc/oracle_cs.txt.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How are the other Connection properties set?
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