error in Oracle Stage > dboptions

[sribuz]

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.

[Minhajuddin]

$ 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.

[sribuz]

$ 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.

[lstsaur]

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

[sribuz]

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#.

[ray.wurlod]

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

[keshav0307]

have you defined the database (remote server)

[sribuz]

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.

[sribuz]

Oracle Dbase password got expired and was in grace period.

Thanks for Helping.

[lstsaur]

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