Error occurred during initializeFromArgs().

pavankatra · Post by **pavankatra** » Sun May 09, 2010 10:28 pm

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.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon May 10, 2010 2:31 am

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.

pavankatra · Post by **pavankatra** » Mon May 10, 2010 5:00 am

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.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon May 10, 2010 5:12 am

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 ?

pavankatra · Post by **pavankatra** » Mon May 10, 2010 5:32 am

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.

chulett · Post by **chulett** » Mon May 10, 2010 5:59 am

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?

pavankatra · Post by **pavankatra** » Mon May 10, 2010 8:04 am

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 · Post by **pavankatra** » Mon May 10, 2010 8:16 am

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.

chulett · Post by **chulett** » Mon May 10, 2010 10:06 pm

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