throwing DetailedReportDownloadResponseException with 400 Response code.

869 views
Skip to first unread message

raneen...@datorama.com

unread,
Jan 2, 2018, 6:16:47 PM1/2/18
to AdWords API Forum
Hi ,

we are using the Adwords Api v201702 and we are facing problem  :
We are  trying to run this requset by using adwords api.

List<String> fields = new ArrayList<>();


 fields
.add("AdGroupId");
 fields
.add("CriteriaType");
 fields
.add("Criteria");


 
DateRange dateRange = new DateRange();
 dateRange
.setMin(startDate);
 dateRange
.setMax(endDate);
 
 
 
 
Selector selector = new Selector();
 selector
.getFields().addAll(fields);
 selector
.setDateRange(dateRange);
 
 
 
 
ReportDefinition reportDefinition = new ReportDefinition();
 reportDefinition
.setReportName("Datorama Report");
 reportDefinition
.setDateRangeType(ReportDefinitionDateRangeType.CUSTOM_DATE);
 reportDefinition
.setReportType(ReportDefinitionReportType.CRITERIA_PERFORMANCE_REPORT);
 reportDefinition
.setDownloadFormat(DownloadFormat.GZIPPED_CSV);
 reportDefinition
.setSelector(selector);


 
// download the report
 
ReportDownloader reportDownloader = new ReportDownloader(adWordsSession);
 reportDownloader
.setReportDownloadTimeout(HTTP_READ_TIMEOUT);
 
ReportDownloadResponse response = reportDownloader.downloadReport(reportDefinition);




 When we this Requset, sometimes responding with 400 response and sometimes running normally .
  This is the response:
Stack Trace :

Caused by: HTTP Response Code: 400
at com
.google.api.ads.adwords.lib.utils.v201702.DetailedReportDownloadResponseException$Builder.build(DetailedReportDownloadResponseException.java:35)
at com
.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.handleResponse(AdHocReportDownloadHelperImpl.java:117)
at com
.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.downloadReport(AdHocReportDownloadHelperImpl.java:60)
at sun
.reflect.GeneratedMethodAccessor859.invoke(Unknown Source)
at sun
.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java
.lang.reflect.Method.invoke(Method.java:498)
at com
.google.api.ads.common.lib.utils.AdsUtilityInvocationHandler.handleInvocation(AdsUtilityInvocationHandler.java:46)
at com
.google.common.reflect.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:84)
at com
.sun.proxy.$Proxy174.downloadReport(Unknown Source)
at com
.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelper.downloadReport(AdHocReportDownloadHelper.java:46)
at com
.google.api.ads.adwords.lib.utils.v201702.ReportDownloader.downloadReport(ReportDownloader.java:65)\


Peter Oliquino

unread,
Jan 2, 2018, 10:46:04 PM1/2/18
to AdWords API Forum
Hi,

In order to better investigate your concern, could you provide your clientCustomerId, the values of your startDate and endDate, and respond to me privately via the Reply privately to author option?

Thanks and regards,
Peter
AdWords API Team
Message has been deleted

Peter Oliquino

unread,
Jan 4, 2018, 12:56:51 AM1/4/18
to AdWords API Forum
Hi Raneen,

Thank you for sending the requested information. Upon trying out your report and by also using the 201702 version of the AdWords API, I was able to successfully generate it on my end and did not encounter the error 400. This being said, could you confirm if you are still encountering the issue?

Best regards,
Peter
AdWords API Team

Raneen Bsais

unread,
Jan 4, 2018, 6:37:05 AM1/4/18
to AdWords API Forum
Hi Peter,
this error not always reprduce , we didn't catch this excption by debugging , it happens sometiems for our clients ,
and even after the client try again the issue desapper.
the main problem that the issue happen and if try it not happen . 

Regards,
Raneen.

Anash P. Oommen (AdWords API Team)

unread,
Jan 5, 2018, 9:28:11 AM1/5/18
to AdWords API Forum
Hi Raneen,

This looks to me as a combination of two issues - a server issue that's occasionally sending 400 responses, and the client library not being able to handle it correctly.

For the first part, could you turn on logging and capture a failing request? The instructions are here: https://github.com/googleads/googleads-java-lib/wiki/Logging. Once you have the logs, share it with me using the "Reply privately to author" and I'll ask the reporting team to respond.

For the second part, file an issue with the Java client library here: https://github.com/googleads/googleads-java-lib/issues. You'd want to post a redacted version of the log you are sharing with me privately.

Cheers
Anash P. Oommen,
AdWords API Team.

raneenb...@gmail.com

unread,
Jan 10, 2018, 5:25:23 AM1/10/18
to AdWords API Forum
Hi Anash,
the failure also happen with other reports.
we think that the problem happen because of that the AdWordsSession expired .
 we have checked in the documentation  which error returned if the AdWordsSession expired .
can you please confirm that we got 400 if the session expired .

Thanks,
Raneen.

Anash P. Oommen (AdWords API Team)

unread,
Jan 10, 2018, 3:03:48 PM1/10/18
to AdWords API Forum
Hi Raneen,

400 exception happens if there's something wrong with the request being sent to the server. It could be because of an expired session; it could be because of a malformed request. Capturing the logs is the best way to tell for sure, because that gives you the raw HTTP response that the client library can't somehow seem to parse.

Cheers
Anash P. Oommen
AdWords API Advisor.

avathan...@8thlight.com

unread,
Feb 28, 2018, 4:31:09 AM2/28/18
to AdWords API Forum
Hello AdWords API Team,

I am experiencing the same issue. Can you let me know who I should reach out inorder to send you the logs?

Thanks,
Andrew

Andrew Vathanakamsang

unread,
Mar 2, 2018, 12:46:13 PM3/2/18
to adwordsap...@google.com, AdWords API Forum, hometownquotes-support, Todd Chapple, Tyler Decker
Hi Anash,

Thanks for getting back to me on this issue.

This is a log of the error after trying to parse the response. We have not been able to download the reports since 02/23/18. 

We have not changed our implementation. Can you let us know if you are seeing a malformed request or is there an issue with our credentials?

Thanks,
Andrew 

DetailedReportDownloadResponseException: 400
at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelper.downloadReport(ReportRequest, DetailedReportDownloadResponseException$Builder)
at com.google.api.ads.adwords.lib.utils.v201702.ReportDownloader.downloadReport(ReportDefinition)
at com.thisorthat.alligator.service.impl.CampaignReportingServiceGoogleImpl.getGoogleCostReport(AdNetworkAccount, Date)
at com.thisorthat.alligator.service.impl.CampaignReportingServiceGoogleImpl.getCampaignCostReport(AdNetworkAccount, Date)
at com.thisorthat.alligator.ScheduledTasks.updateGoogleCampigns()
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Object, Object[])
at java.lang.reflect.Method.invoke(Object, Object[])
at org.springframework.scheduling.support.ScheduledMethodRunnable.run()
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run()
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run()
at java.util.concurrent.Executors$RunnableAdapter.call()
at java.util.concurrent.FutureTask.run()
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor$ScheduledFutureTask)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run()
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor$Worker)
at java.util.concurrent.ThreadPoolExecutor$Worker.run()
at java.lang.Thread.run()


On Fri, Mar 2, 2018 at 9:34 AM, <adwordsap...@google.com> wrote:
Hi Andrew,

I made this email thread private, so you can respond to it to share the details.

Cheers
Anash


--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/f0107f6a-a84c-4b99-bcaa-4af52220cfe1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Andrew Vathanakamsang
8th Light

Andrew Vathanakamsang

unread,
Mar 9, 2018, 6:52:44 PM3/9/18
to adwordsap...@google.com, AdWords API Forum, hometownquotes-support, Tyler Decker, Todd Chapple
Hi Sreelakshmi,

Thanks for following up. Yes, we were able to resolve the issue.

Andrew

On Fri, Mar 9, 2018 at 2:31 PM, <adwordsap...@google.com> wrote:
Hi Andrew.

Following up on this thread. Were you able to resolve the issue? Please let me know if you need any further assistance.

Thanks,
Sreelakshmi, AdWords API Team
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Ronald Findling

unread,
Mar 20, 2018, 4:10:42 AM3/20/18
to AdWords API Forum
Hi Raneen,

we face a similar issue for some months now observing requests sporadically failing with 400 Bad Request.
Our versions:
201702 version of the AdWords API

The related log part:
2018-03-19 01:21:15 [WARN] c.g.a.a.a.lib.utils.report_download Request made: Service: reportdownload Method: POST clientCustomerId: 125-142-3890 URL: https://adwords.google.com//api/adwords/reportdownload/v201710 Request ID: null ResponseTime(ms): null OperationsCount: null IsFault: true FaultMessage: com.google.api.ads.adwords.lib.utils.ReportException: 400: Bad Request
2018-03-19 01:21:15 [ERROR] c.g.a.a.a.l.c.A.soapXmlLogger Couldn't process XML into a Document

Best Regards,
Ron
Message has been deleted

Sreelakshmi Sasidharan (AdWords API Team)

unread,
Mar 20, 2018, 3:06:14 PM3/20/18
to AdWords API Forum
Hi Ron, 

The V201702 version of the API is deprecated and all calls made to this version of the API will return an error. v201802 is the most recent version of the API currently available. We strongly recommend that you migrate to this version. For future reference, please find the deprecation schedule for various API versions. The resources given below might be helpful for you in migration: 
You could follow our Google Ads Developer blog or the AdWords API Announcements forum to make sure that you are not missing any announcements about the API in the future. Please let me know if you have any further questions. 

Josh Radcliff (AdWords API Team)

unread,
Mar 20, 2018, 4:54:13 PM3/20/18
to AdWords API Forum
Hi Raneen,

From our logs, it appears that your requests are most frequently failing with the following errors:
  • ReportDefinitionError.CUSTOMER_SERVING_TYPE_REPORT_MISMATCH
  • AuthorizationError.USER_PERMISSION_DENIED
  • ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT
Could you share a report request that failed, with any sensitive information removed (developer token, OAuth access token, etc.)?

Also, I see that you are using the client library for Java. Are you adhering to the thread-safety recommendations? For example, you should not use a ReportDownloader instance within multiple threads. Doing so will produce unpredictable behavior, such as malformed requests or issues parsing responses.

Thanks,
Josh, AdWords API Team

Ronald Findling

unread,
Mar 21, 2018, 6:18:17 AM3/21/18
to AdWords API Forum
Hi Sreelakshmi,
sorry, I somehow mixed up versions here -- we are actually using `com.google.api.ads.adwords.axis.v201710`

Josh Radcliff (AdWords API Team)

unread,
Mar 21, 2018, 8:28:59 AM3/21/18
to AdWords API Forum
Hi Ron, Raneen,

In my previous post, I mistakenly said that the list of errors I provided was for Raneen, but I just realized that they were actually for you, Ron. Sorry about that!

Ron, could you check out my previous post and the questions/items I highlighted there?

Thanks,
Josh, AdWords API Team

Ronald Findling

unread,
Mar 27, 2018, 9:53:11 AM3/27/18
to AdWords API Forum
Hi Josh,

thx for the hints.
Concerning the requested information I can give you 2 identical request where one succeeded and the other one failed with a 400 as shown in my last message.

failed:
time: 27.03.18 01:06:08 CEST
googleAdwordsAccountId: 685-366-2732
SELECT Conversions,ConversionValue FROM SHOPPING_PERFORMANCE_REPORT WHERE CountryCriteriaId = 2826 DURING 20180225,20180327;

succeeded:
time: 27.03.18 03:06:30 CEST
googleAdwordsAccountId: 685-366-2732
SELECT Conversions,ConversionValue FROM SHOPPING_PERFORMANCE_REPORT WHERE CountryCriteriaId = 2826 DURING 20180225,20180327;

Best Regards, Ron

Josh Radcliff (AdWords API Team)

unread,
Mar 27, 2018, 5:05:31 PM3/27/18
to AdWords API Forum
Hi Ronald,

I searched the logs on our side and could not find either of those requests. Are you sure that they were submitted for the account ID you mentioned?

By the way, did you check if you're adhering to the thread safety guidelines I mentioned earlier? I just want to make sure we can rule that out as a possible cause of the errors.

Thanks,
Josh, AdWords API Team

Ronald Findling

unread,
Mar 28, 2018, 8:10:33 AM3/28/18
to AdWords API Forum
Hi Josh,

I checked the request data that I provided you and they are exactly what I can see in my logs. Maybe I should mention that the provided time is the time at which the request failed not when it was sent to your servers (that time is ~30-40 seconds before).

Concerning the thread-safety recommendations I'm sure that the ReportDownloader and its Session are not used in multiple threads in our code.

Further information: 
Checking our errors I found an interesting pattern, failing requests always take at least 30 seconds (usually 30-31) while successful ones are most likely to be around 1 second.

Maybe a stupid thought but could it be a something like the java-library timing out after 30 seconds and retrying using the provided session/ReportDownloader again which then violates the threadSafety and results in invalid requests?

Best Regards,
Ron

Josh Radcliff (AdWords API Team)

unread,
Mar 30, 2018, 9:15:38 AM3/30/18
to AdWords API Forum
Hi Ron,

Sorry, I'm still having trouble locating those requests in our logs. Would you mind sending over the customer ID where your developer token is registered? You can send it only to me by clicking Reply privately to author.

Regarding the timeout theory, the ReportDownloader won't automatically retry requests. However, if you think timeouts are the root cause here, you can adjust the timeout for report downloads programmatically or in your ads.properties file. Check out this section of the ads.properties file for details.

Thanks,
Josh, AdWords API Team

Dorian Kind

unread,
Apr 3, 2018, 11:12:12 AM4/3/18
to AdWords API Forum
Hi all,

I thought I posted previously in this thread, but it looks like my message has been deleted. I just wanted to chime in that we've also been seeing these sporadic report failures that return a HTTP 400 status code and no reponse content. They don't seem to be reproducible, from what we can tell and are most likely not the result of an expired OAuth token or a malformed report definition as both of these cases give detailed error messages.
We don't feel comfortable automatically retrying report download requests for error codes below 500, so it'd be great if the Adwords team could shed some light on the issue.

Thanks and best regards,
Dorian

Josh Radcliff (AdWords API Team)

unread,
Apr 4, 2018, 3:18:02 PM4/4/18
to AdWords API Forum
Hi all,

Thanks for letting us know about these errors. I'm following up with our reporting team and will post back here when I have an update.

Cheers,
Josh, AdWords API Team

Zweitze

unread,
Apr 12, 2018, 6:11:34 AM4/12/18
to AdWords API Forum
This topic was somehow below my radar, but I occasionally get this too. See here for recent logs and the response headers that AdWordsAPI sent.
This error occurred on:
Dec 22
Dec 25 (3 times)
Dec 31
Jan 1
Jan 12
Feb 1
Feb 6 (2 times)
Mar 17 (3 times)
Mar 18
Mar 23
Mar 24
Mar 25
Mar 26
Mar 30
Apr 1
Apr 3
Apr 11 (3 times)
(@Google: I have requests and response headers for each instance).
We retrieve between 1,000 and 20,000 reports daily. Problems occur on different report types, on different accounts - I can't find a pattern on that.

Like Dorian I wonder how to deal with that error, as a 400-error means a serious error by the client.

Josh Radcliff (AdWords API Team)

unread,
Apr 12, 2018, 10:10:48 PM4/12/18
to AdWords API Forum
Hi,

Thanks for providing the customer IDs and timestamps of the failed requests. I've passed those along to the reporting team for investigation and asked for an update.

Cheers,
Josh, AdWords API Team
Message has been deleted

Ronald Findling

unread,
Apr 16, 2018, 11:27:53 AM4/16/18
to AdWords API Forum
After adding some more logging, another example that results in a 400 on our side:


19:07:52 [WARN] c.g.a.a.a.lib.utils.report_download Request made: Service: reportdownload Method: POST clientCustomerId: XXX URL: https://adwords.google.com//api/adwords/reportdownload/v201710 Request ID: null ResponseTime(ms): null OperationsCount: null IsFault: true FaultMessage: com.google.api.ads.adwords.lib.utils.ReportException: 502: Bad Gateway
2018-04-15 19:07:52 [INFO] c.g.a.a.a.lib.utils.report_download HTTP request:
accept-encoding: [gzip]
authorization: REDACTED
user-agent: [XXX (AwApi-Java, Common-Java/3.12.0, Java/1.8.0_121, maven, ReportDownloader)]
developertoken: REDACTED
clientcustomerid: XXX
includezeroimpressions: false

Content:
__rdquery: SELECT Conversions,ConversionValue FROM SHOPPING_PERFORMANCE_REPORT WHERE CountryCriteriaId = 2250 DURING 20180316,20180415
__fmt: XML

Caused by: HTTP Response Code: 400 at com.google.api.ads.adwords.lib.utils.v201710.DetailedReportDownloadResponseException$Builder.build(DetailedReportDownloadResponseException.java:35)

Josh Radcliff (AdWords API Team)

unread,
Apr 16, 2018, 4:59:35 PM4/16/18
to AdWords API Forum
Hi Ron,

I'm a little perplexed by the most recent example. I see it shows both:

com.google.api.ads.adwords.lib.utils.ReportException: 502: Bad Gateway

and:

Caused by: HTTP Response Code: 400

Was that a bad copy/paste, or are you actually seeing both 502 and 400 mentioned within the same error?

Thanks,
Josh, AdWords API Team

Josh Radcliff (AdWords API Team)

unread,
Apr 16, 2018, 5:01:11 PM4/16/18
to AdWords API Forum
Also, I forgot to ask: is that timestamp in CST?

Thanks,
Josh, AdWords API Team

Ronald Findling

unread,
Apr 23, 2018, 4:16:20 AM4/23/18
to AdWords API Forum
Taking into account the daylight savings we currently have UTC+2.
Concerning the 502 unfortionately I don't have the logs at hand any more -- but what I remember was an 502 which resulted in a 400 in our usage of the library.

Best Regards,
Ron

Josh Radcliff (AdWords API Team)

unread,
Apr 23, 2018, 8:52:50 AM4/23/18
to AdWords API Forum
Hi Ron,

Thanks for getting back to me. I think we have enough examples now to track this down. The eng team is making progress, but I don't have any updates to report just yet. I'll reply back as soon as I have more info.

Cheers,
Josh, AdWords API Team

Dorian Kind

unread,
May 4, 2018, 7:32:45 AM5/4/18
to AdWords API and Google Ads API Forum
Hi Josh,

any updates on this topic? Can we just retry downloads that fail with this specific error condition (400 HTTP status code and no response content) for the time being?

Thanks for your feedback and best regards,
Dorian

Josh Radcliff (AdWords API Team)

unread,
May 4, 2018, 3:18:47 PM5/4/18
to AdWords API and Google Ads API Forum
Hi Dorian,

Tracking down the root cause is proving quite challenging, so I don't have any news to report just yet. In the meantime, retrying failed requests (provided you're confident the request is valid) is a good approach.

Thanks,
Josh, AdWords API Team

Ronald Findling

unread,
May 16, 2018, 4:34:19 PM5/16/18
to AdWords API and Google Ads API Forum
Hi Josh,

are there any updates on this topic? We are eagerly awaiting your response on this one.

Best Regards,
Ron

Josh Radcliff (AdWords API Team)

unread,
May 17, 2018, 10:44:27 AM5/17/18
to AdWords API and Google Ads API Forum
Hi Ron,

The engineering team is still digging into this. I'll be sure to update this thread as soon as I have more information.

In the meantime, please retry the requests as Dorian suggested earlier.

Thanks,
Josh, AdWords API Team

Ronald Findling

unread,
Jun 22, 2018, 10:08:21 AM6/22/18
to AdWords API and Google Ads API Forum
Is there some feedback from the engineering team?

AdWords API Advisor

unread,
Jun 22, 2018, 4:56:50 PM6/22/18
to AdWords API and Google Ads API Forum
Hi Ron,

I've been checking in with them on a regular basis, but unfortunately I don't have any progress to report yet.

Thanks,
Josh, AdWords API Team

Zweitze

unread,
Jul 17, 2018, 6:25:46 PM7/17/18
to AdWords API and Google Ads API Forum
This error was away at my site for quite a few weeks, but reappeared this morning. The response headers that came with the error were:

Content-Disposition/bigstore/aw3-webapi-report-download/17144261fca9f85-0a63-4a20-9d9f-3f8d5baaf6e5/fileId-null-uuid-1fca9f85-0a63-4a20-9d9f-3f8d5baaf6e5-cid-1714426.tmp.xml.gz
X-Content-Type-Optionsnosniff
X-Frame-OptionsSAMEORIGIN
X-XSS-Protection1; mode=block
Alt-Svcquic=":443"; ma=2592000; v="44,43,39,35"
Content-Length0
Cache-Controlprivate, max-age=0
Content-Typeapplication/x-gzip; charset=UTF-8
DateTue, 17 Jul 2018 04:42:09 GMT
ExpiresTue, 17 Jul 2018 04:42:09 GMT
ServerGSE

The error occured with some old code running v201710.
CustomerId and ReportDefinition are available if necessary, but I can assure you that that same ReportDefinition (a PLACEMENT_PERFORMANCE_REPORT this time) was successfully used thousands of times.



Josh Radcliff (AdWords API Team)

unread,
Jul 18, 2018, 11:58:51 AM7/18/18
to AdWords API and Google Ads API Forum
Hi Zweitze,

Thanks for providing those details. The engineer investigating this said they'll be quite helpful. I'll reply back when he has an update.

Cheers,
Josh, AdWords API Team

arthur....@brainweb.com.br

unread,
Jul 19, 2018, 4:50:57 PM7/19/18
to AdWords API and Google Ads API Forum
Hello everyone,

I'm working on an application that retrieves data from the Adwords API and I'm facing the same 400 - Bad Request problem. We are working with the v201710 version.
Yesterday I worked normally on the application and today when I arrived I faced the exact same problem reported here. I didn't change anything in the code that was working just yesterday! 
I spent a lot of time searching for a possible mistake and just want to make sure that it might not be an error from my part.

Thanks a lot for your attention!

best regards,

Arthur

arthur....@brainweb.com.br

unread,
Jul 19, 2018, 4:51:11 PM7/19/18
to AdWords API and Google Ads API Forum
hell

Josh Radcliff (AdWords API Team)

unread,
Jul 20, 2018, 9:43:45 AM7/20/18
to AdWords API and Google Ads API Forum
Hi Arthur,

Does the same request succeed on retry? If so, then you are encountering the same issue being discussed here. I advise having retry logic in your reporting jobs, both in general and to mitigate this particular issue.

Also, please note that v201710 will be sunset on July 25. Please make sure you migrate to a newer version of the AdWords API before that date.

Thanks,
Josh, AdWords API Team

Josh Radcliff (AdWords API Team)

unread,
Jul 26, 2018, 9:09:47 AM7/26/18
to AdWords API and Google Ads API Forum
Hi,

We've identified the root cause and are working on a fix. I'll update this discussion once the fix has been deployed.

Thanks,
Josh, AdWords API Team

Josh Radcliff (AdWords API Team)

unread,
Aug 11, 2018, 10:45:35 AM8/11/18
to AdWords API and Google Ads API Forum
Hi,

Thanks, everyone, for your patience while we tracked down the root cause of this issue. The problem was that when a specific transient error occurred during processing on our side, it was being incorrectly reported back in the response  with status code 400 (bad request). A fix was deployed so that the proper status code of 500 (internal server error) will now be returned in this situation.

Best regards,
Josh, AdWords API Team

samson Odubanjo

unread,
Mar 4, 2019, 5:55:02 AM3/4/19
to AdWords API and Google Ads API Forum
Hi

I believe i am getting similar issue. It was working arround 8 hours ago.

 c.g.a.a.a.lib.utils.report_download      : Request made: Service: reportdownload Method: POST clientCustomerId: URL: https://adwords.google.com//api/adwords/reportdownload/v201809 Request ID: null ResponseTime(ms): null OperationsCount: null IsFault: true FaultMessage: com.google.api.ads.adwords.lib.utils.ReportException: 400: Bad Request
2019-03-03 19:13:20.430  INFO 17416 --- [ool-17-thread-4] c.g.a.a.a.lib.utils.report_download      : HTTP request:
accept-encoding: [gzip]
authorization: REDACTED
user-agent: [unknown (AwApi-Java, AdWords-Axis/4.4.0, Common-Java/4.4.0, Axis/1.4, Java/1.8.0_171, maven)]
developertoken: REDACTED
clientcustomerid: ########
skipreportheader: false
skipcolumnheader: false
skipreportsummary: false
includezeroimpressions: false

Content:
__rdxml: <?xml version="1.0" encoding="UTF-8" standalone="yes"?><reportDefinition xmlns:ns2="https://adwords.google.com/api/adwords/cm/v201809"><ns2:selector><ns2:fields>Id</ns2:fields><ns2:fields>AdGroupId</ns2:fields><ns2:fields>Date</ns2:fields><ns2:fields>CampaignId</ns2:fields><ns2:fields>CampaignName</ns2:fields><ns2:fields>AdGroupName</ns2:fields><ns2:fields>Criteria</ns2:fields><ns2:fields>Impressions</ns2:fields><ns2:fields>Ctr</ns2:fields><ns2:fields>Cost</ns2:fields><ns2:fields>ConversionRate</ns2:fields><ns2:fields>Conversions</ns2:fields><ns2:fields>Clicks</ns2:fields></ns2:selector><ns2:reportName>AGE_RANGE_PERFORMANCE_REPORT</ns2:reportName><ns2:reportType>AGE_RANGE_PERFORMANCE_REPORT</ns2:reportType><ns2:downloadFormat>CSV</ns2:downloadFormat></reportDefinition>

googleadsapi...@google.com

unread,
Mar 4, 2019, 1:43:05 PM3/4/19
to samp...@gmail.com, AdWords API and Google Ads API Forum
Hi,

Could you share the date and time, including time zone, of the failed request below so I can look it up in our logs?

Thanks,
Josh, AdWords API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/b45c47d5-d7af-41cd-bc11-7f4b693fa770%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

googleadsapi...@google.com

unread,
Mar 25, 2019, 6:05:57 PM3/25/19
to samp...@gmail.com, AdWords API and Google Ads API Forum
Hi all,

I haven't been able to locate the failed requests in our logs from earlier this month, but if you're still encountering this error regularly please let me know.

Thanks,
Josh, Google Ads API Team


=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    http://googleadsdeveloper.blogspot.com/search/label/adwords_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Reply all
Reply to author
Forward
0 new messages