DSXchange

Hi ,

My target(Teradata) is Upsert and Access Method is Bulk and Load Type is Stream
My Source is Teradata and the lookup is a file .

When i try to trunctae the target table and run the job.

I am getting the error as "[IIS-CONN-TERA-005003] RDBMS code 9903: Activity count zero for Stream Operator update or delete. (CC_TeraAdapter::selectStreamErrorTable1, file CC_TeraAdapter.cpp, line 7,599)"
But the Data is loaded into the Target table but the job got Aborted. I am having a reject link for the target and i checked Duplicate Key to reject.

Can you please let me know what would be the reason for Aborting the job but loading the Data into the Target table

Can any one please let me know the solution for the above issue.

What reason for Abort is given in the job log?

We can't see your system!

The job got Aborted due to below error in Log

Activity count zero for Stream Operator update or delete. (CC_TeraAdapter::selectStreamErrorTable1, file CC_TeraAdapter.cpp, line 7,599)

So, something specific to Teradata - have you taken that message / code to your Teradata DBA?

So what you've sent to Teradata is the equivalent of UPDATE stuff WHERE 1=0 and it didn't like it. You need to re-design to avoid this situation.

Is there any possibility to avoid that error by using any settings in teradata connector stage?

The only way i could able to resolve is seperated the links for Update and Insert instead of using upsert.