error in Oracle Stage > dboptions
Moderators: chulett, rschirm, roy
error in Oracle Stage > dboptions
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.
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.
Thanks & Regards,
Sri
Sri
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
$ 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.
The documentation mentions what you need to do when you have special characters in your password.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
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#.
Thanks & Regards,
Sri
Sri
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
now I am getting error asray.wurlod wrote:I should have thought #$EnvironmentVariable# is what's required - which would also explain the 'unexpected "$"' message. ...
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.
Thanks & Regards,
Sri
Sri
Got my problem Solved
Oracle Dbase password got expired and was in grace period.
Thanks for Helping.
Thanks for Helping.
Thanks & Regards,
Sri
Sri