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
Dataset to Oracle DB load error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
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.
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.
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
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.
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.