DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
satheesh_color
Participant



Joined: 16 Jun 2005
Posts: 178

Points: 2104

Post Posted: Mon Sep 10, 2018 4:51 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

I could see the below error while loading the data from Dataset into Oracle table.

The variable nAccessorIndex has value -2 which is not valid in the current context. (CC_OraRecordDataSetConsumer::getAccessor, file CC_OraRecordDataSetConsumer.cpp, line 5,783)

The runLocally() of the operator failed.

Note: when i tried dataset to dataset load, it works well.

No clue about this error.


Kindly help me out on this.


Thanks
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42764
Location: Denver, CO
Points: 220364

Post Posted: Mon Sep 10, 2018 6:18 am Reply with quote    Back to top    

That looks very... internal. In your shoes I would be opening a support case.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
satheesh_color
Participant



Joined: 16 Jun 2005
Posts: 178

Points: 2104

Post Posted: Mon Sep 10, 2018 7:45 am Reply with quote    Back to top    

Hi Craig,

When i tried to generate sql at run-time..i could see the below warnings. But, i have been mapped to the target by using copy stage.

The column Col2 from the input schema is not used. It will be ignored.
The columnCol3 from the input schema is not used. It will be ignored.


Note: For me, i have to generate the DBSeq.nextval for the surrogate key for the fact, so that i ended up by creating manual insert statement. But failed:(.



Thanks.
Rate this response:  
Not yet rated
satheesh_color
Participant



Joined: 16 Jun 2005
Posts: 178

Points: 2104

Post Posted: Mon Sep 10, 2018 9:24 pm Reply with quote    Back to top    

Hi Craig,

Thanks for your valuable time on this and i apologize for wasting your time.

I have found out the issue with one of the column name "mispelled", when i try to create user-defined insert statement. It took almost 4 hrs to identify the issue..Sad.


Now the issue is to fill the Task timesheet..Smile

Thanks.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42764
Location: Denver, CO
Points: 220364

Post Posted: Tue Sep 11, 2018 6:31 am Reply with quote    Back to top    

Cool

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours