ERROR_GETTING_RESPONSE_FROM_BACKEND when downloading Product Partition Report for some Campaigns

[Stefan Kleine Stegemann]

Hi,

we are experiencing problems when downloading product partition reports for some campaigns. We're loading these reports for large number of campaigns without problems but three campaigns started to fail consistently this morning (german  time). We've successfully downloaded reports for the "problematic" campaigns in the past days.

We're using the ReportDownloader from the Java API (v201607) and noticed that the call almost immediately fails with a DetailedReportDownloadResponseException:

com.google.api.ads.adwords.lib.utils.v201607.DetailedReportDownloadResponseException: 500
        at com.google.api.ads.adwords.lib.utils.v201607.DetailedReportDownloadResponseException$Builder.build(DetailedReportDownloadResponseException.java:35
)
        at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.handleResponse(AdHocReportDownloadHelperImpl.java:111)
        at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.downloadReport(AdHocReportDownloadHelperImpl.java:55)
        at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:483)
        at com.google.api.ads.common.lib.utils.AdsUtilityInvocationHandler.handleInvocation(AdsUtilityInvocationHandler.java:46)
        at com.google.common.reflect.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:87)
        at com.sun.proxy.$Proxy118.downloadReport(Unknown Source)
        at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelper.downloadReport(AdHocReportDownloadHelper.java:49)
        at com.google.api.ads.adwords.lib.utils.v201607.ReportDownloader.downloadReport(ReportDownloader.java:72)

According to the exception details, the problem is not triggered by the report definition but some internal error:

2016-10-25 11:15:59,243 121808 [qtp1454127753-13] ERROR AdWordsReportDownloadImpl  httpStatus: 500
2016-10-25 11:15:59,243 121808 [qtp1454127753-13] ERROR AdWordsReportDownloadImpl  message: 500
2016-10-25 11:15:59,244 121809 [qtp1454127753-13] ERROR AdWordsReportDownloadImpl  fieldPath: --
2016-10-25 11:15:59,245 121810 [qtp1454127753-13] ERROR AdWordsReportDownloadImpl  trigger: Unable to read report data
2016-10-25 11:15:59,246 121811 [qtp1454127753-13] ERROR AdWordsReportDownloadImpl  type: ReportDownloadError.ERROR_GETTING_RESPONSE_FROM_BACKEND

The report definition looks as follows:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<reportDefinition xmlns:ns2="https://adwords.google.com/api/adwords/cm/v201607">
  <ns2:selector>
    <ns2:fields>AdGroupId</ns2:fields>
    <ns2:fields>AverageCpc</ns2:fields>
    <ns2:fields>CampaignId</ns2:fields>
    <ns2:fields>Id</ns2:fields>
    <ns2:fields>Clicks</ns2:fields>
    <ns2:fields>Cost</ns2:fields>
    <ns2:fields>Impressions</ns2:fields>
    <ns2:fields>CpcBid</ns2:fields>
    <ns2:fields>ParentCriterionId</ns2:fields>
    <ns2:fields>PartitionType</ns2:fields>
    <ns2:fields>ProductGroup</ns2:fields>
    <ns2:fields>SearchImpressionShare</ns2:fields>
    <ns2:fields>BenchmarkAverageMaxCpc</ns2:fields>
    <ns2:predicates>
      <ns2:field>CampaignId</ns2:field>
      <ns2:operator>EQUALS</ns2:operator>
      <ns2:values>XXXXXXXX</ns2:values>
    </ns2:predicates>
    <ns2:predicates>
      <ns2:field>AdGroupStatus</ns2:field>
      <ns2:operator>EQUALS</ns2:operator>
      <ns2:values>ENABLED</ns2:values>
    </ns2:predicates>
    <ns2:predicates>
      <ns2:field>IsNegative</ns2:field>
      <ns2:operator>EQUALS</ns2:operator>
      <ns2:values>false</ns2:values>
    </ns2:predicates>
    <ns2:dateRange>
      <ns2:min>20160924</ns2:min>
      <ns2:max>20161023</ns2:max>
    </ns2:dateRange>
  </ns2:selector>
  <ns2:reportName>BMOS Report</ns2:reportName>
  <ns2:reportType>PRODUCT_PARTITION_REPORT</ns2:reportType>
  <ns2:dateRangeType>CUSTOM_DATE</ns2:dateRangeType>
  <ns2:downloadFormat>GZIPPED_XML</ns2:downloadFormat>
</reportDefinition>

I cannot write the client customer id or campaign ids here, but I'll be happy to share it with you privately if that's necessary for investigation.

Best,

Stefan

[Shwetha Vastrad (AdWords API Team)]

Hi Stefan,

Could you provide the Campaign IDs which are experiencing this issue? Is it isolated to these particular Campaigns or AdWords account? You can use Reply privately to author to send this information. 

Thanks,

Shwetha, AdWords API Team.

[Stefan Kleine Stegemann]

Hi Shwetha,

thanks for the fast reply. I sent you the campaign ids via private reply.

I cannot tell whether it's related to the campaign or account, because each campaign belongs to a separate account and our system does not "manage" any other campaigns from these accounts.

Best,

Stefan

[abweg]

Hi,
same problem, but only one account fails.
Response Code: 500, Trigger: Unable to read report data, Type: ReportDownloadError.ERROR_GETTING_RESPONSE_FROM_BACKEND..... 
Any idea?
Thanks A. Boldt

[Stefan Kleine Stegemann]

Hi,

just wanted to update this thread saying that the problem does not longer exist. Thanks for solving it.

Best,

Stefan

Am Dienstag, 25. Oktober 2016 12:19:30 UTC+2 schrieb Stefan Kleine Stegemann: