Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Zero-byte report inside zip file returned from API
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  13 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
dkasak  
View profile  
 More options Dec 1 2008, 11:51 pm
From: dkasak <daniel.ka...@247realmedia.com>
Date: Mon, 1 Dec 2008 20:51:11 -0800 (PST)
Local: Mon, Dec 1 2008 11:51 pm
Subject: Zero-byte report inside zip file returned from API
Hi all.

I posted this question ... somewhere else ... but I can't find where
now, so maybe I posted it in the wrong place? Anyway ...

I've been asked to look at an issue where some reports that we
download contain no information. The compressed file itself is valid
( ie not corrupted ), but when we unpack it, the report file inside is
0 bytes. ( Example report ID: 582000854 )

Does anyone know why we're ( intermittently ) getting these 0-byte
reports?


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
AdWords API Advisor Google employee  
View profile  
 More options Dec 2 2008, 11:31 am
From: AdWords API Advisor <adwordsapiadvi...@google.com>
Date: Tue, 2 Dec 2008 08:31:12 -0800 (PST)
Local: Tues, Dec 2 2008 11:31 am
Subject: Re: Zero-byte report inside zip file returned from API
Hello Daniel,

 In addition to being exposed via the AdWords API, all the reports you
schedule should also be available via the http://adwords.google.com/
web interface, in the Report Center of the account in question (this
may be the Report Center of the MCC account or of the actual AdWords
account, depending on how to scheduled it).

 Assuming you haven't scheduled 15 other reports since then and bumped
the report you mention out of the queue in the Report Center, what
happens when you take a look at the report via the web interface? Do
you see a properly populated report, or is it empty there as well?

Cheers,
-Jeff Posnick, AdWords API Team

On Dec 1, 11:51 pm, dkasak <daniel.ka...@247realmedia.com> wrote:


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
pedro  
View profile  
 More options Dec 3 2008, 3:57 pm
From: pedro <peterdoyle.ibers...@googlemail.com>
Date: Wed, 3 Dec 2008 12:57:18 -0800 (PST)
Local: Wed, Dec 3 2008 3:57 pm
Subject: Re: Zero-byte report inside zip file returned from API
Jeff

I have been experiencing this too.  I thought initially it was my
server running out of space but now that someone else is getting this
behaviour I am more suspicious.  I will investigate my situation more
and report back.

Peter Doyle

On Dec 2, 4:31 pm, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Pete Lavetsky (AdWords API Guru)  
View profile  
 More options Dec 3 2008, 4:17 pm
From: "Pete Lavetsky (AdWords API Guru)" <pete.lavet...@gmail.com>
Date: Wed, 3 Dec 2008 13:17:54 -0800 (PST)
Local: Wed, Dec 3 2008 4:17 pm
Subject: Re: Zero-byte report inside zip file returned from API
Might be an issue if you're waiting too long to download the report.

http://code.google.com/apis/adwords/docs/developer/ReportService.html

"When your report job is complete, use getReportDownloadUrl to
retrieve the URL where your report is stored. The returned URL is
valid for five minutes. If the URL expires, just call
getReportDownloadUrl again. Keep this URL private, since anyone can
use it to access your report."

I've seen both 404s for the URLs and also empty data reports but I had
always assumed we waited too long to download the report.  I'd be
interested to see if the empty report can be more definitely nailed
down to a different cause.

Pete

On Dec 3, 3:57 pm, pedro <peterdoyle.ibers...@googlemail.com> wrote:


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
AdWords API Advisor Google employee  
View profile  
 More options Dec 3 2008, 5:02 pm
From: AdWords API Advisor <adwordsapiadvi...@google.com>
Date: Wed, 3 Dec 2008 14:02:23 -0800 (PST)
Local: Wed, Dec 3 2008 5:02 pm
Subject: Re: Zero-byte report inside zip file returned from API
I'd definitely like to get to the bottom of the situation, so again,
if anyone is seeing this behavior, the most useful thing you could
check on is whether the report is also empty in the Report Center of
the AdWords web interface. That information, along with the reportId
and ideally some sort of way of identifying your getReportDownloadUrl
() request (either a log or the returned URL or the requestId SOAP
response header) would be great.

Cheers,
-Jeff Posnick, AdWords API Team

On Dec 3, 4:17 pm, "Pete Lavetsky (AdWords API Guru)"


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Pete Lavetsky (AdWords API Guru)  
View profile  
 More options Dec 4 2008, 10:15 am
From: "Pete Lavetsky (AdWords API Guru)" <pete.lavet...@gmail.com>
Date: Thu, 4 Dec 2008 07:15:48 -0800 (PST)
Local: Thurs, Dec 4 2008 10:15 am
Subject: Re: Zero-byte report inside zip file returned from API
Jeff,

Here is a job that just happened that was empty when we downloaded it,
but *not* empty in the MCC Report Center: 539587199

I don't have the URL that was given to us by the report service, but
if that information is imperative, I can add in logging.

Pete

On Dec 3, 5:02 pm, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
AdWords API Advisor Google employee  
View profile  
 More options Dec 4 2008, 11:40 am
From: AdWords API Advisor <adwordsapiadvi...@google.com>
Date: Thu, 4 Dec 2008 08:40:03 -0800 (PST)
Local: Thurs, Dec 4 2008 11:40 am
Subject: Re: Zero-byte report inside zip file returned from API
Hello Pete,

 I'm not able to find a report with that id currently active in the
Report Center.

 I'll ping you off-thread to get some more details that might help
track this down.

Cheers,
-Jeff Posnick, AdWords API Team

On Dec 4, 10:15 am, "Pete Lavetsky (AdWords API Guru)"


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
dkasak  
View profile  
 More options Dec 4 2008, 6:46 pm
From: dkasak <daniel.ka...@247realmedia.com>
Date: Thu, 4 Dec 2008 15:46:02 -0800 (PST)
Local: Thurs, Dec 4 2008 6:46 pm
Subject: Re: Zero-byte report inside zip file returned from API
HI Jeff. Here's another one for you.

URL: https://adwords.google.com/api/adwords/ReportDownload?t=AAAAACOvQ1YAA...

ReportID: 598688598

And a bit of our log:

1204-133949 S Google.pm/412 Creative Report version:  Google API v12
1204-133950 S Base.pm/1404 Creating Service ReportService
1204-133950 S Base.pm/1620 Checking the report status for report
598688598
1204-133950 S Base.pm/1624 Waiting 10 seconds..
1204-134000 S Base.pm/1630 Current status for report 598688598 is
Completed
1204-134000 S Base.pm/1634 Success: finished report(598688598)
1204-134000 S Base.pm/1545 Doing a file download from URL
1204-134019 S Base.pm/1716 Download URL
https://adwords.google.com/api/adwords/ReportDownload?t=AAAAACOvQ1YAA...
to file /tmp/IgFStFB0HF/BdJGnNUukf.zip successful!
1204-134019 E se_download.pl/53 ERROR IN SE Download for:
--------------------------------------------------------------------------- -----
ERROR               =
no element found at line 1, column 0, byte 0:
D
^
 at /usr/local/lib/perl5/site_perl/5.8.3/i686-linux/XML/Parser.pm line
187

As you can see, we only waited 10 seconds until checking that the
report was complete, and it was at this point ( we got a url ) so we
downloaded it. It again was a valid zip file, but when unpacked the
report was a zero-byte file.

I logged into the web ui and found the report id, and when I clicked
on it, I got a single row of zeros. What is the behaviour in this
case? Should we expect a report structure, but with no data? Or does
the report structure only get output upon the 1st row of data?

Thanks.

Dan

On Dec 4, 9:02 am, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
AdWords API Advisor Google employee  
View profile  
(1 user)  More options Dec 5 2008, 1:25 pm
From: AdWords API Advisor <adwordsapiadvi...@google.com>
Date: Fri, 5 Dec 2008 10:25:45 -0800 (PST)
Local: Fri, Dec 5 2008 1:25 pm
Subject: Re: Zero-byte report inside zip file returned from API
Okay, after following up with Pete a bit off-thread, I think I have
enough information to file an issue with the core engineering team.

Basically, the behavior he was seeing is that he'd call
getReportDownloadUrl() for a recently-completed report job id, get a
URL back, and then upon downloading the URL find that there was no
content. I asked Pete to try calling getReportDownloadUrl() a second
time for the same report job id, and upon downloading that new URL the
report content was there. Additionally, the report is properly
accessible via the web interface's Report Center (ignore my previous
message about not being able to find it there).

This is obviously going to be a bit more difficult to debug than if,
for example, there was something about a given report job id that
caused it to always lead to a download URL that pointed to nothing,
but we'll see what we can do. It actually sounds like it may have some
similarities to another open issue described at

  http://groups.google.com/group/adwords-api/browse_thread/thread/c08c6...

I'll post updates with any information I get back from the core
engineering team. In the meantime, apologies for the inconvenience,
and putting in logic to call getReportDownloadUrl() again and get a
new URL when you encounter this failure seems to be a workaround.

Cheers,
-Jeff Posnick, AdWords API Team

On Dec 4, 6:46 pm, dkasak <daniel.ka...@247realmedia.com> wrote:


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
dkasak  
View profile  
 More options Jan 5, 5:32 pm
From: dkasak <daniel.ka...@247realmedia.com>
Date: Mon, 5 Jan 2009 14:32:02 -0800 (PST)
Local: Mon, Jan 5 2009 5:32 pm
Subject: Re: Zero-byte report inside zip file returned from API
Any word on a solution for this? I'm wondering whether I should bother
adding 'try again' logic as per Jeff Posnick's suggestion, or whether
the issue will be resolved sooner than I can get the fix into a
release.

    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
AdWords API Advisor Google employee  
View profile  
 More options Jan 5, 5:39 pm
From: AdWords API Advisor <adwordsapiadvi...@google.com>
Date: Mon, 5 Jan 2009 14:39:50 -0800 (PST)
Local: Mon, Jan 5 2009 5:39 pm
Subject: Re: Zero-byte report inside zip file returned from API
Hello Dan,

 This was just brought up again at

  http://groups.google.com/group/adwords-api/browse_thread/thread/3729f...

and as mentioned there, there are unfortunately no breakthroughs when
it comes to tracking down the root cause.

Cheers,
-Jeff Posnick, AdWords API Team

On Jan 5, 5:32 pm, dkasak <daniel.ka...@247realmedia.com> wrote:


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
pedro  
View profile  
 More options Jan 7, 4:35 am
From: pedro <peterdoyle.ibers...@googlemail.com>
Date: Wed, 7 Jan 2009 01:35:01 -0800 (PST)
Local: Wed, Jan 7 2009 4:35 am
Subject: Re: Zero-byte report inside zip file returned from API
Jeff

FYI
I am still getting this behaviour and await further news.

Peter

On Jan 5, 10:39 pm, AdWords API Advisor <adwordsapiadvi...@google.com>
wrote:


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
tozor  
View profile  
 More options Jan 8, 10:41 am
From: tozor <t...@adlucent.com>
Date: Thu, 8 Jan 2009 07:41:23 -0800 (PST)
Local: Thurs, Jan 8 2009 10:41 am
Subject: Re: Zero-byte report inside zip file returned from API
I have also been experiencing this error.  I had two occurrences in
the reports I ran this morning.  Initially I simply implemented a 5
second delay between the time the report status switched to completed
and the time I accessed the URL.  I will implement the retry discussed
here.

  Tim

On Jan 7, 3:35 am, pedro <peterdoyle.ibers...@googlemail.com> wrote:


    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google