Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
rsunny
Participant
Posts: 223 Joined: Sat Jul 03, 2010 10:22 pm
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
Participant
Posts: 223 Joined: Sat Jul 03, 2010 10:22 pm
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rsunny
Participant
Posts: 223 Joined: Sat Jul 03, 2010 10:22 pm
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rsunny
Participant
Posts: 223 Joined: Sat Jul 03, 2010 10:22 pm
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
Participant
Posts: 223 Joined: Sat Jul 03, 2010 10:22 pm
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.