DSXchange

Hi,
I am getting following error when i load the data into oracle table.I have given Username ,password and servername.

Error occurred during initializeFromArgs().
Incorrect dboptions option list; it failed on Expected "," or "}", got: "USER", line 1.
A user name is required in the dboptions option.


So can anyone please suggest me how to overcome this.


Thanks in advance.

DataStage is having problem when attempting to decrypt your connection details.

Either you have provided blank or invalid characters in your username (or password) or using reserved words such as 'USER' or 'PASS' as its values.

Sainath.Srinivasan wrote:DataStage is having problem when attempting to decrypt your connection details.

Either you have provided blank or invalid characters in your username (or password) or using reserved words such as ' ...

THanks for reply.

I have given below details
user name:V8USER
password:V8USER
server:test.uk
table name:V8USER.emp
UPSERTis write mode.

please suggest me where i did wrong.And suggest me hoe to overcome this issue.

Try to view the corresponding osh script.

Also check the response from view data. That may give you hint about any parameters or missing values.

Can you see the values correctly in the connection details ?

Sainath.Srinivasan wrote:Try to view the corresponding osh script.

Also check the response from view data. That may give you hint about any parameters or missing values.

Can you see the values correctly in the connecti ...

my job is got aborted,so i am unable to view the OSh code.Oracle stage is my target.

Which "Oracle stage" are you using? Have you used them before so you know they should work or is this your first attempt? What exact 8.x release?

chulett wrote:Which "Oracle stage" are you using? Have you used them before so you know they should work or is this your first attempt? What exact 8.x release? ...

thanks for u r reply.

i am using oracle enterprises as target in 8.1 version.

i have used oracle enterprise edition as a source,that time it worked fine.
So can anyone please help me to rectify this issue.

pavankatra wrote:

chulett wrote:Which "Oracle stage" are you using? Have you used them before so you know they should work or is this your first attempt? What exact 8.x release? ...

thanks for u r reply.

i am using oracle enterprises as target in 8.1 version.

i have used oracle enterprise edition as a source,that time it worked fine.
So can anyone please help me to rectify this issue.

Thanks all.

problem got solved.

i was gone through the OSh code,then i have found out the issue and resolved.

thanks for your cooperation.

Any chance you could post the resolution? It could help future searchers who come here with the same problem.