Dataset to Oracle DB load error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

Dataset to Oracle DB load error

Post by satheesh_color »

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
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

Post by satheesh_color »

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.
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

Post by satheesh_color »

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..:(.


Now the issue is to fill the Task timesheet..:)

Thanks.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

8)
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply