DSXchange

Hi,
I created a job with Oracle stage as source in EE 7.5.
In Oracle stage properties were set as
Output>Connections>dboption mode>auto generated
and I defined db password in environment variables.

so it generated Connection>DB Options={user=username,password=#$password#}

when I run the job it aborted giving me fatal error message as ..

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

$ is a special character and you can't use it just like that in your password.
The documentation mentions what you need to do when you have special characters in your password.

Minhajuddin wrote:$ is a special character and you can't use it just like that in your password.
The documentation mentions what you need to do when you have special characters in your password.

I am using evironment variable there, not '$' as a character in password.

Double check your password field. It shouldn't display anything like "#$password#"; it should always have something like "******" especailly for PX job.

lstsaur wrote:Double check your password field. It shouldn't display anything like "#$password#"; it should always have something like "******" especailly for PX job.

I defined password in environment variables and there its value is encrypted and displayed as *******

I am using that environmental variable so I have to use it as $#EnvironmentVariable#.

I should have thought #$EnvironmentVariable# is what's required - which would also explain the 'unexpected "$"' message.

have you defined the database (remote server)

ray.wurlod wrote:I should have thought #$EnvironmentVariable# is what's required - which would also explain the 'unexpected "$"' message. ...

now I am getting error as

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

when I run job again its giving me

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

can # or $ be used as part of password ? I used ## as part of passwd


Re:keshav0307: I have mentioned remote server name.

Oracle Dbase password got expired and was in grace period.

Thanks for Helping.

After 8 days later to find out that the job's problem was cuased by expired password? You marked this topic as a workaround?