Performance problems downloading criteria report via API

[LE Max]

We have been experiencing problems for the last several hours in retrieving reports via the API.

 

When we request a criteria report, we are getting the following message: 'Unable to create report, Type: ReportDownloadError.ERROR_WRITING_REPORT_TO_FILE'

 

We have made repeated attempts with the same failed result. Can you please let me know if there is an issue with the system?

[Vishal Vinayak (Adwords API Team)]

Hi,

Could you please provide me with the SOAP XML report definition, complete error logs and your 10 digit AdWords account ID? Please click on Reply privately to author when responding.

Regards,
Vishal, AdWords API Team

[Vitaliy Shibaev]

We also observe the same issue since 31 March - never seen that before:

Google.Api.Ads.AdWords.Util.Reports.AdWordsReportsException: AdWordsReportsException: One or more AdWords Report download errors have occurred.

ReportDownloadError.ERROR_WRITING_REPORT_TO_FILE. (Error: ReportDownloadError.ERROR_WRITING_REPORT_TO_FILE, FieldPath: , Trigger: Unable to create report)

 ---> System.Net.WebException: The remote server returned an error: (500) Internal Server Error.

суббота, 1 апреля 2017 г., 1:16:01 UTC+6 пользователь LE Max написал:

[cv]

Hello vishal,

we are also facing same error since 31 march. We have also sent soap xml to you.

[Dorian Kind]

Hi there,

FWIW, we're also seeing lots of these errors since Saturday.

Cheers,

Dorian

[Addams]

We are also experiencing the same error when attempting to download the KEYWORDS_PERFORMANCE_REPORT data for 4/1/2017 as well using the reports API.  We experienced this issue on 4/2/2017 at 9:03 PM EDT and again this morning, 4/3/2017 at 7:39 AM EDT.  We are currently unable to pull our reports data.  The full error is below.  Any help is greatly appreciated..  Please let me know if I can provide you any further details.  Thank you.

 

Google.Api.Ads.AdWords.Util.Reports.AdWordsReportsException: AdWordsReportsException: One or more AdWords Report download errors have occurred.

 

ReportDownloadError.ERROR_WRITING_REPORT_TO_FILE. (Error: ReportDownloadError.ERROR_WRITING_REPORT_TO_FILE, FieldPath: , Trigger: Unable to create report)

 

 ---> System.Net.WebException: The remote server returned an error: (500) Internal Server Error.

[Addams]

I was now able to run our application that pulls data from the reports API successfully on 4/3/2017 at 11:56 AM EDT.  Not sure if something was fixed, if the issue is just intermittent, or if I just got lucky.  Hoping the issue is fixed.  Thank you.

[Nadine Sundquist (AdWords API Team)]

Greetings AdWordsians,

This does appear to be an issue on our side. We're actively working on a solution. I'll get back to you when the problem is fully resolved.

Best,

Nadine, AdWords API Team

[Alex]

Hey Vishal,

I've realised we're getting the same issues as others here, with the Keywords Performance Report too. Saw the error last Friday, and again over the weekend, and this morning.

Has anyone got any information about the potential cause?

[Nadine Sundquist (AdWords API Team)]

Hi Alex,

This issue in our code base started on March 31st and continued into today. My team is currently in the cleanup phase of resolving this issue, so things should be getting better. I'll give the all clear when the error is completely resolved.

Best,

Nadine, AdWords API Team

[Josh Gabel]

We've been noticing a different type of reportdownload issue.

When running the following AWQL report request to v201702 we're getting a blank report returned. No actual errors reported, just a report with empty data rows. I have confirmed that we had campaigns that meet the conditions with clicks, impressions, and cost, but can't get the report to go send data back.

SELECT CampaignId, CampaignName, CampaignStatus, Clicks, Impressions, Cost FROM CAMPAIGN_PERFORMANCE_REPORT WHERE CampaignStatus != 'REMOVED' AND Impressions > 0 DURING 20170327,20170402

[Nadine Sundquist (AdWords API Team)]

Hi Josh,

Please start a new thread on this one. That'll make it easier for us to track and for people to +1 your particular issue.

Thanks,

Nadine, AdWords API Team

[Nadine Sundquist (AdWords API Team)]

Hello Everyone!

We've resolved the issue. The duration of this issue lasted from March 31st until today. You should no longer be seeing this error. If you see it again, please get back to me. We're currently working on putting measures in place to ensure that this particular issue does not pop up again.

Take care,

Nadine, AdWords API Team

[Paul Newbury]

Cheers guys!

I'm getting RATE_EXCEEDED, just curious if there's a way I can see what time this is reset in my account? Or, maybe, is this a knock on effect from the earlier issue?

Thanks again

[Nadine Sundquist (AdWords API Team)]

Hello Paul,

The only reasons I can think of you getting a RATE_EXCEEDED would be if you were retrying on error quite rapidly due to this issue or if you have Basic access, and you exceeded your limit. Unfortunately, we can't do a reset for that. With the error, you should have gotten a few more specifics if you need to wait another 30 seconds or if you exceeded the number of operations per day. Please take a look RATE_EXCEEDED under Common Errors for more detail on how to respond to an error like this. If you need further help, please start a new forum thread, and my team would be happy to help.

Thanks,

Nadine, AdWords API Team

[AdwAPI-TR]

Hello there,

I'm starting to get this error today.

Report download failed. Underlying errors are Type = 'ReportDownloadError.ERROR_WRITING_REPORT_TO_FILE', Trigger = 'Unable to create report'

3 Nisan 2017 Pazartesi 23:41:29 UTC+3 tarihinde Nadine Sundquist (AdWords API Team) yazdı:

[Shwetha Vastrad (AdWords API Team)]

Hi, 

Could you provide the report definition used along with the clientCustomerId for which this error occurred? Does this error occur consistently? Please use Reply privately to author when sending the requested details.

Thanks,

Shwetha, AdWords API Team.

[Dorian Kind]

Hi all,

just wanted to chime in to say that we've also been experiencing these errors more frequently again during the last few days. As opposed to the occurrence in April however, retrying almost always helps.

Best regards,
Dorian

[Justin Coon]

Hi we are experiencing errors similar to this with the CAMPAIGN_PERFORMANCE_REPORT. We either get an empty report(no errors) or we get an error 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><reportDownloadError><ApiError><type>ReportDownloadError.ERROR_GETTING_RESPONSE_FROM_BACKEND</type><trigger>Unable to read report data</trigger><fieldPath></fieldPath></ApiError></reportDownloadError>

Any thoughts API team?

[Shwetha Vastrad (AdWords API Team)]

Hi All, 

Could you provide the clientCustomerIds along with the report definitions for the API requests which encountered this error? Please use Reply privately to author when responding.  

Regards,

Shwetha, AdWords API Team.

[Shwetha Vastrad (AdWords API Team)]

Hi All, 

We are aware of the issue and we have implemented a fix. You should no longer be seeing this error. If you see it again, please get back to me. 

[ra...@intentwise.com]

I am upgrading to version 201705 and I get the below error. I go back to my older version of 201702 and I still see the same issue.

googleads.errors.AdWordsReportBadRequestError: Type: ReportDownloadError.ERROR_WRITING_REPORT_TO_FILE

Trigger: Unable to create report

Field Path: None

-Raghu

[Shwetha Vastrad (AdWords API Team)]

Hi all,

The team is working on a solution as a top priority. I'll keep you notified once I have more updates. 

[Tomas R]

Also, we see a significant performance decline since few days ago using reporting API.

[Shwetha Vastrad (AdWords API Team)]

Hi Tomas,

We are aware of the issue and are investigating the latency in report downloads in AdWords API. The original issue has been fixed and you should no longer be seeing this error. I'll update this thread once I have more details. 

[Shwetha Vastrad (AdWords API Team)]

Hi All,

I'm marking this thread as duplicate of this one: https://groups.google.com/d/msg/adwords-api/MfX0XL7G4o4/c_40PK51AgAJ

Please follow the other thread for updates about this issue.