Hi, Thanks for reporting this issue. It sounds like it is a difficult problem to emulate, since it only occurs sporadically and for a small subset of the rows. I'll alert the team to the issue, but in the mean time you may want to add some logic to your software that can filter out the duplicates.
Best, - Eric Koleda, AdWords API Team On Aug 25, 10:11 am, "j.e.frank" <[email protected]> wrote: > Twice in the past couple days, I have gotten an error in my report > consumption code because I am trying to insert records that violate a > unique constraint in my database. At first I thought it was a bug in > my code, but now I think it is a problem with the report itself. I > took a look at the report XML, and sure enough, there are some > duplicate rows in there. The report has about 100,000 rows, and there > are only about 120 duplicates. When I say "duplicate", I mean the > same creative ID, same day, same stats, same everything. When I tried > to re-create the report in the AdWords UI, I did not get duplicates. > And, I run reports about 8 times per day via the API, so it does not > happen every time by any means. > > I don't know if I can provide any more information to help identify > the problem -- I have the full report XML, but it is about 70 MB. -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
