Getting ReportDownloadError.ERROR_WRITING_REPORT_TO_FILE on Campaign Performance Report

[Yosi Kalmanson]

Hello,

In the last 24 hours I keep getting ReportDownloadError.ERROR_WRITING_REPORT_TO_FILE when trying to run Campaign Performance Report. If I run it 10 times in a sequence (with same parameters) so chances are that one time it will be successful. 

What should I do?

Thanks

[Matthias Baader]

Hi,

same problem here ...

[Stephen Howe]

Same for me. Most of my requests are working but I am intermittently getting this error. Seems something is down.

[Tiana S.]

Yup, same here. Seeing it occur more often in the past few hours.

[Jofin Kuriakose]

Hi,

I am getting this error for AdGroup Performance Report frequently.

[Dana Gray]

Same here...for several days sporadically seeing this behavior

[Nadine Sundquist (AdWords API Team)]

Greetings!

i recognize some API veterans on the line. Thanks everyone for chiming in to move this really high to the top of the queue; I like it when I see the community working together and not being passive. I'm looking into it. I'll post here as I have more information.

Regards,

Nadine, AdWords API Team

[Kris Insparx]

Same here.

The same query fails for one or two times but eventually it works, so it seems like an issue with the API and not the queries.

Error handling works as a quick solution, but please look into fixing it. Many thanks!

[Matt Beck]

GOOGLE -- This is urgent. Our agency relies on this API for reporting and analysis. I can't get any reporting out of the API.

[kmyers.unc...@gmail.com]

Same here, here is my code removing any personal stuff:

Request Summary: {'clientCustomerId': 'XXX-XXX-XXXX, 'includeZeroImpressions': False, 'server': 'adwords.google.com', 'skipColumnHeader': 'False', 'skipReportHeader': 'True', 'skipReportSummary': 'True', 'isError': True, 'errorMessage': '<?xml version="1.0" encoding="UTF-8" standalone="yes"?><reportDownloadError><ApiError><type>ReportDownloadError.ERROR_WRITING_REPORT_TO_FILE</type><trigger>Unable to create report</trigger><fieldPath></fieldPath></ApiError></reportDownloadError>'}

Traceback (most recent call last):

 File "XXXXXXXXX", line 1623, in _DownloadReportAsStream

   response = self.url_opener.open(request)

 File "/home/robot/miniconda3/envs/XXXX/lib/python3.6/urllib/request.py", line 532, in open

   response = meth(req, response)

 File "/home/robot/miniconda3/envs/XXXX/lib/python3.6/urllib/request.py", line 642, in http_response

   'http', request, response, code, msg, hdrs)

 File "/home/robot/miniconda3/envs/XXXX/lib/python3.6/urllib/request.py", line 570, in error

   return self._call_chain(*args)

 File "/home/robot/miniconda3/envs/XXXX/lib/python3.6/urllib/request.py", line 504, in _call_chain

   result = func(*args)

 File "/home/robot/miniconda3/envs/XXXX/lib/python3.6/urllib/request.py", line 650, in http_error_default

   raise HTTPError(req.full_url, code, msg, hdrs, fp)

urllib.error.HTTPError: HTTP Error 500: Internal Server Error

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

 File "XXXX", line 37, in <module>

   api_version=api_version

 File "XXXX", line 173, in GetCriterions

   skip_report_summary=True

 File "/home/robot/miniconda3/envs/XXXX/lib/python3.6/site-packages/googleads/common.py", line 531, in Wrapper

   return utility_method(*args, **kwargs)

 File "/home/robot/miniconda3/envs/XXXX/lib/python3.6/site-packages/googleads/adwords.py", line 1472, in DownloadReportAsStringWithAwql

   self._SerializeAwql(query, file_format), **kwargs)

 File "/home/robot/miniconda3/envs/XXXX/lib/python3.6/site-packages/googleads/adwords.py", line 1640, in _DownloadReportAsStream

   raise error

googleads.errors.AdWordsReportBadRequestError: Type: ReportDownloadError.ERROR_WRITING_REPORT_TO_FILE

Trigger: Unable to create report

Field Path: None

On Tuesday, September 4, 2018 at 8:50:12 AM UTC-4, Yosi Kalmanson wrote:

[mohammad...@vivaki.com]

Same here!

[kmyers.unc...@gmail.com]

I had the error from ~8am-11am EST but no longer

[Nadine Sundquist (AdWords API Team)]

Hello Folks,

I've confirmed that I see the issue on our servers. It looks like the storm of these error started at about 3 AM Pacific time. It's gotten a bit better, but we are still working on it.

Regards,

Nadine, AdWords API Team

[Nadine Sundquist (AdWords API Team)]

Greetings Community,

The root cause was identified, and we've been working through resolving it and making sure this doesn't happen again. The errors have subsided significantly within the last hour, and they should disappear completely shortly. Thanks, all, for reporting this!

Regards,

Nadine, AdWords API Team

[Tomas R]

And they are back again...

Hope the new API will be feature complete soon.

[Nadine Sundquist (AdWords API Team)]

Hi Tomas,

I just checked the health of our systems, and I don't see a widespread outage of any sort for report downloads with this error. Are you perhaps getting another error? If it's happening for one specific account or it's a slightly different error, then we take this offline and you can reply privately to author with the details. It may be localized to something in your world. At least you now have a sanity check of knowing that the whole system isn't down, which means whatever you're seeing must be on a smaller scale and fixable.

Cheers,

Nadine, AdWords API Team