Activity count zero for Stream Operator update or delete

rsunny · Post by **rsunny** » Sun Jun 03, 2012 4:56 pm

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

rsunny · Post by **rsunny** » Mon Jun 04, 2012 7:39 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Jun 04, 2012 9:07 pm

What reason for Abort is given in the job log?

We can't see your system!

rsunny · Post by **rsunny** » Mon Jun 04, 2012 9:15 pm

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)

chulett · Post by **chulett** » Mon Jun 04, 2012 9:20 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Jun 04, 2012 10:25 pm

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.

rsunny · Post by **rsunny** » Tue Jun 05, 2012 7:07 am

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

rsunny · Post by **rsunny** » Wed Jun 06, 2012 4:47 pm

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