can anyone please suggest me what is this [oraUpsert.C:1852] error.
I get this error message when etl job is inserting to oracle DB in version 8.1
the insert statement executes successfully in oracle (though 0 rows inserted) but etl job is aborting.
Unable to insert a record into the table due to . [oraUpsert.C:1852]
The runLocally() of the operator failed. [api/operator_rep.C:4027]
Heap growth during runLocally(): 1901K bytes
Operator terminated abnormally: runLocally() did not return APT_StatusOk [processmgr/rtpexecutil.C:199]
Unable to insert a record into the table due to . [oraUpsert.C:1852]
runLocally() of the operator failed. [api/operator_rep.C:4027
Operator terminated abnormally: runLocally() did not return APT_StatusOk [processmgr/rtpexecutil.C:199]
can anyone please suggest me.
Thanks
Mark
[oraUpsert.C:1852]
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
[oraUpsert.C:1852]
I have seq stage ---> copy ---> oracle enterprise endition stage.
inside Oracle stage, i have upsert mode. insert statement and dummy update statement.
whenever insert statement runs it is not necessary there will be inserts in the table.
such as insert executed, 0 rows inserted.
insert into table_name1 col1, col2 values (select col1,col2 from table_name2)
the job runs successfully where there are actual inserts but when there are no inserts etl job aborts message" unable to insert a record into the table.."
Thanks
Mark
inside Oracle stage, i have upsert mode. insert statement and dummy update statement.
whenever insert statement runs it is not necessary there will be inserts in the table.
such as insert executed, 0 rows inserted.
insert into table_name1 col1, col2 values (select col1,col2 from table_name2)
the job runs successfully where there are actual inserts but when there are no inserts etl job aborts message" unable to insert a record into the table.."
Thanks
Mark