Hi,
i am using a teradata api stage to run an aggregation query on teradata database, now the problem is that although the query is running and data is getting inserted in the tables , the director log shows that no row has been inserted.
The log entry was something like the following
Number of rows received = 1, rejected = 0, inserted = 0, updated = 0, deleted = 0.
although 101 rows are getting inserted in the table.
i am using a row grenerator and teradata api for running the query.
Api stage-datastage director log showing wrong information.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 4
- Joined: Tue May 08, 2007 2:44 am
- Location: delhi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 47
- Joined: Fri Mar 18, 2005 5:59 am
Re: Api stage-datastage director log showing wrong informati
Is this one-off thing or a reproducable error. Would you be able to give more detail.
Since made a random job/query to check whether i could reproduce the above , with a simple aggregation of partition by key values, and it does give the statistics as intended.
Since made a random job/query to check whether i could reproduce the above , with a simple aggregation of partition by key values, and it does give the statistics as intended.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 4
- Joined: Tue May 08, 2007 2:44 am
- Location: delhi
Hi,
the funny thing about this error is that it does not happen with all jobs which are made similarly, i have made other jobs using api stage and row generator and they are showing the correct stats.
What i did then was I copied the query and pasted in a job which was showing correct stats and even then the stats were coming out to be wrong.
when i ran this job again ,this showed the correct stats,so i am really confused as to what may be the rason of this error might be!!
so this is a recurring rror although not quite reproducable in the correct sense of the term!!
the funny thing about this error is that it does not happen with all jobs which are made similarly, i have made other jobs using api stage and row generator and they are showing the correct stats.
What i did then was I copied the query and pasted in a job which was showing correct stats and even then the stats were coming out to be wrong.
when i ran this job again ,this showed the correct stats,so i am really confused as to what may be the rason of this error might be!!
![Shocked :shock:](./images/smilies/icon_eek.gif)
![Mad :x](./images/smilies/icon_mad.gif)
so this is a recurring rror although not quite reproducable in the correct sense of the term!!