[oraUpsert.C:1852]

[pavan_test]

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

[chulett]

What stage are you using? What settings / properties are set in the stage?

[pavan_test]

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