I have a stuck one I'll let go for awhile. The report id is 431736501. It has been running for 2.5 hours. Hopefully your report team can find out what is going on with this one.
Thanks. Tim On Aug 23, 8:14 am, tozor <[EMAIL PROTECTED]> wrote: > One more example that occurred this morning. This time I only had > three concurrent reports. The report ran for 55 minutes before I > killed it. The stuck report id was 428986461. After I killed the > process the next report finished in two minutes. > > I hope I can get some resolution to this next week. Baby sitting my > application over the weekend is getting old. > > Thanks for your help. > > Tim > > On Aug 21, 3:09 pm, AdWords API Advisor <[EMAIL PROTECTED]> > wrote: > > > Thanks, I got pinged back from the reports team asking if there was a > > more recent example. I'll provide that report id to them. > > > Cheers, > > -Jeff Posnick, AdWords API Team > > > On Aug 21, 3:45 pm, tozor <[EMAIL PROTECTED]> wrote: > > > > Jeff, > > > > Just letting you know that the problem does still exist, although I > > > went for a couple of days without seeing it. The latest stuck report > > > id is 474410941. However I had to kill the process to keep my > > > application users happy. The report completed on the subsequent > > > attempt within a minute (the stuck report ran for about 40 minutes > > > before I had to kill it). > > > > Thanks again for looking into this. > > > > Tim > > > > On Aug 19, 12:00 pm, tozor <[EMAIL PROTECTED]> wrote: > > > > > I saw the problem on Sunday night and was going to wait until Monday > > > > morning to post with an updated report id. I have not seen the > > > > problem in the last two days. However I also backed down the > > > > concurrency to three concurrent reports in one part of my application > > > > where it is super critical for me not to have a stuck report. There > > > > is another part of my application where I left the concurrency at 5 > > > > reports (both of these are down from 10). > > > > > I will re-post on the next re-occurrence to let you know if the > > > > problem still exists. Thanks for checking in. > > > > > Tim > > > > > On Aug 19, 11:51 am, AdWords API Advisor > > > > > <[EMAIL PROTECTED]> wrote: > > > > > Hello Tim, > > > > > > I'm sorry that there's no significant update from the reports team > > > > > yet, but I did want to check in to see if the behavior has changed at > > > > > all since last week. I can understand the need to manually cancel the > > > > > offending reports to ensure that your clients get the retried reports > > > > > in a timely manner, so in the interim you shouldn't hesitate to cancel > > > > > them and retry. If the reports team comes back to me saying that they > > > > > need a "live" example I'll sync up with you about that. > > > > > > Cheers, > > > > > -Jeff Posnick, AdWords API Team > > > > > > On Aug 15, 6:00 pm, tozor <[EMAIL PROTECTED]> wrote: > > > > > > > Again thanks for the reply. One complicating factor is that I can't > > > > > > let a job remain stuck indefinitely because it backs up my > > > > > > application. At most I have about four hours after a post that I > > > > > > can > > > > > > wait. If you folks were in the middle of debugging it, then I can > > > > > > let > > > > > > it stay stuck, otherwise in the interest of my application users I > > > > > > am > > > > > > forced to kill the process and reissue the report. As far as the > > > > > > report ids you mentioned: > > > > > > > 421168971 - this completed after about 50 minutes, again this is > > > > > > highly abnormal since it usually takes 1 minute > > > > > > 471606181 - I had to kill this one after 2.5 hours. > > > > > > 471187411 - I had to kill this one after 90 minutes > > > > > > 471986881 - This was the one I reported today and I let it go for > > > > > > almost 4 hours before I had to kill it. > > > > > > > I will say that the accounts in question are very large and this may > > > > > > be a contributing factor. From my black box perspective it seems > > > > > > like > > > > > > you folks have code which predicts the cost of reports and doesn't > > > > > > let > > > > > > the resource cost from a single user exceed a certain limit. It > > > > > > seems > > > > > > like the jobs which get queued up as a result of the resource cost > > > > > > never get started. I am thinking that these jobs get cleared from > > > > > > the > > > > > > queue when the session goes away when I kill the process. Clearly I > > > > > > am guessing here but this is the type of behavior I see on my end. > > > > > > > I will continue to post stuck job ids to this thread if that is > > > > > > useful > > > > > > for you. If not let me know so that I don't spam the group too > > > > > > much. > > > > > > > Tim > > > > > > > On Aug 15, 4:33 pm, AdWords API Advisor <[EMAIL PROTECTED]> > > > > > > wrote: > > > > > > > > Hello Tim, > > > > > > > > 421168971 completing successfully should not have been the > > > > > > > result of > > > > > > > any special intervention on our end, no. How long did it take > > > > > > > before > > > > > > > it finally was marked as complete? And what about 471606181? > > > > > > > > Okay, thank you for the debugging that you're doing on your end. > > > > > > > I've > > > > > > > only heard back about 471187411, and that job did not complete > > > > > > > properly on our end, so it's not a question of the job completing > > > > > > > but > > > > > > > the wrong status being returned back. I have not heard anything > > > > > > > about > > > > > > > what the potential cause of the problem is yet unfortunately, so I > > > > > > > can't provide any concrete recommendations as to how to work > > > > > > > around it > > > > > > > at this time. I will update the open bug with the latest job id > > > > > > > though. > > > > > > > > Cheers, > > > > > > > -Jeff Posnick, AdWords API Team > > > > > > > > On Aug 15, 12:28 pm, tozor <[EMAIL PROTECTED]> wrote: > > > > > > > > > Sorry to be a pain about this, but this is becoming a real > > > > > > > > issue with > > > > > > > > my application. I have been successfully running multiple > > > > > > > > concurrent > > > > > > > > keyword status reports since V10 and all the way thru V12. Now > > > > > > > > seemingly without reason (at least as far as my existing > > > > > > > > application > > > > > > > > code goes) I am getting these situations where the report stays > > > > > > > > in > > > > > > > > progress forever. I have tried reducing the number of > > > > > > > > concurrent jobs > > > > > > > > and even putting a wait between each report request. So far > > > > > > > > this has > > > > > > > > not been successful. Again, I can kill the process and issue > > > > > > > > the same > > > > > > > > report request as the one which was stuck and it completes > > > > > > > > within a > > > > > > > > minute or two. While this is a workaround, it means that I > > > > > > > > have to > > > > > > > > monitor my application multiple times a day looking for stuck > > > > > > > > reports > > > > > > > > because the lack of synchronized data in my db has adverse > > > > > > > > downstream > > > > > > > > effects for my application. > > > > > > > > > My current stuck report is job id 471986881. Hopefully I can > > > > > > > > get an > > > > > > > > update from you folks as to whether you in fact believe there > > > > > > > > is a > > > > > > > > problem on your end or if there is something truly strange > > > > > > > > happening > > > > > > > > on my end. What would take the guess work out of the equation > > > > > > > > is if > > > > > > > > someone on your report team can look in the logs and see what > > > > > > > > the > > > > > > > > Adwords server side thinks is the status of this particular > > > > > > > > report. > > > > > > > > If it is still in progress, then why is it taking so long? If > > > > > > > > the > > > > > > > > server side thinks it is complete, then at least it focuses the > > > > > > > > debug > > > > > > > > effort. > > > > > > > > > Again I very much appreciate this forum and the Adwords API has > > > > > > > > been > > > > > > > > very reliable for us up until this issue. Unfortunately I > > > > > > > > don't know > > > > > > > > how to proceed without some help from someone who can look in > > > > > > > > the logs > > > > > > > > on the back end. > > > > > > > > > Tim > > > > > > > > > On Aug 14, 11:59 am, tozor <[EMAIL PROTECTED]> wrote: > > > > > > > > > > FYI one of them completed (421168971) and I'm not sure if > > > > > > > > > this was > > > > > > > > > divine intervention on your end. 471606181 remains in > > > > > > > > > progress. > > > > > > > > > > Tim > > > > > > > > > > On Aug 14, 11:37 am, AdWords API Advisor > > > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Thanks, Tim, if you don't mind leaving them InProgress I do > > > > > > > > > > think that > > > > > > > > > > would be helpful. I have managed to engage someone from the > > > > > > > > > > reports > > > > > > > > > > team to look into this so hopefully you won't have to leave > > > > > > > > > > them > > > > > > > > > > InProgress for too long a time. > > > > > > > > > > > Cheers, > > > > > > > > > > -Jeff Posnick, AdWords API Team > > > > > > > > > > > On Aug 14, 12:13 pm, tozor <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > Unfortunately limiting the concurrency to 5 reports did > > > > > > > > > > > not solve the > > > > > > > > > > > problem. I have two report ids (471606181 and 421168971) > > > > > > > > > > > currently > > > > > > > > > > > being reported as In Progress which I don't believe will > > > > > > > > > > > ever finish. > > > > > > > > > > > I'll let it run as long as I can in hopes that your > > > > > > > > > > > reporting team can > > > > > > > > > > > explain why they are stuck in Progress. > > > > > > > > > > > > Thanks again. > > > > > > > > > > > > Tim > > > > > > > > > > > > On Aug 13, 10:24 am, AdWords API Advisor > > > > > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > Thanks, Tim. I'll bring the issue up with the reports > > > > > > > > > > > > team and mention > > > > > > > > > > > > your observations along with that report job id. In the > > > > > > > > > > > > meantime if > > > > > > > > > > > > you believe that scheduling only 7 reports at once is a > > > > > > > > > > > > workaround, > > > > > > > > > > > > I'd encourage you to do that for the time being--I > > > > > > > > > > > > don't know of any > > > > > > > > > > > > limits on the number of concurrent zero impression > > > > > > > > > > > > reports, but it's > > > > > > > > > > > > possible that they're there. > > > > > > > > > > > > > Cheers, > > > > > > > > > > > > -Jeff Posnick, AdWords API Team > > > > > > > > > > > > > On Aug 13, 9:35 am, tozor <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > The problem continues to re-occur. I am wondering if > > > > > > > > > > > > > there is a limit > > > > > > > > > > > > > to the number of concurrent zero impression keyword > > > > > > > > > > > > > status reports I > > > > > > > > > > > > > can run. The particular > > ... > > read more ยป --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---