Various errors when fetching ads since 4/6

[Gavin]

(I had a related post before but with wrong observation. I am now posting a new one instead of replying the old thread to avoid confusion)

Hello,

We have observed very strange behavior when querying ads with queries like

SELECT ad_group_ad.ad.final_urls, ad_group_ad.ad.final_mobile_urls, ad_group_ad.ad.id, ad_group_ad.ad.responsive_search_ad.descriptions, ad_group_ad.ad.responsive_search_ad.headlines, ad_group_ad.ad.responsive_search_ad.path1, ad_group_ad.ad.responsive_search_ad.path2, ad_group_ad.ad.tracking_url_template, ad_group_ad.ad.url_custom_parameters, ad_group_ad.ad.final_url_suffix, ad_group_ad.status, ad_group.id, ad_group.name, campaign.name
FROM ad_group_ad
WHERE campaign.id IN (some,campaign,ids)

AND ad_group_ad.ad.type = 'RESPONSIVE_SEARCH_AD'
AND campaign.status != 'REMOVED'
AND ad_group.status != 'REMOVED'
AND ad_group_ad.status != 'REMOVED'
ORDER BY ad_group_ad.ad.id ASC

I intentionally removed the long campaign id list.

We noticed that there have been various errors returned from similar queries:

• Deadline Exceeded

So far this happen most frequently. It happens randomly after the timeout value for the query that succeeded in the past. There were also cases where the error was returned only within a few seconds after we sent the request. When this happened, retry would likely hit the same error.

• Stream removed

This happened a few times. For one query with many retries, this error may be returned for one of the retries. But eventually the query failed with Deadline Exceeded.

• The service is currently unavailable

This is a temporary failure which can get recovered with retry

The issue with unstable queries started from 4/6. On average, it happens 1-2 times per hour. Before that, it never had such a high occurrence rate, only once per a few weeks, which we treated as API hiccup.

Is there a way that you can help track some of the calls if I can provide the exact timestamp when we sent the request and received the response with the query?

Thanks,

Gavin

[Google Ads API Forum Advisor]

Hi Gavin,

Thanks for reaching out. Can you please privately provide us with the request and response logs from a request that resulted in a deadline exceeded error?

Thanks,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2a2DTC:ref

[Gavin]

Hi, Matt,

I've replied privately with the request information. Did you receive the message and is there any update on the issue investigation?

Thanks,

Gavin

[Google Ads API Forum Advisor]

Hi Gavin,

Heidi, who also works on our support team requested more information for us. In you case you did not receive that email, I'll re-post it below:

Thank you for the reply.

Upon seeing your provided logs, I noticed that this is not enough. I can see that you provided some but not completed. That said, could you please provide the complete API logs (request and response logs with request ID ) so our team can identify the exact error and provide possible recommendations?

For you to provide the complete request and response logs with request ID and request header that generated on your end, note that this can be requested or provided to the developer handling the Google Ads API transactions when logging of the API requests has been enabled. If it hasn't been enabled yet, then advise to refer to the specific guide below:

Java - https://developers.google.com/google-ads/api/docs/client-libs/java/logging
.Net - https://developers.google.com/google-ads/api/docs/client-libs/dotnet/logging
PHP - https://developers.google.com/google-ads/api/docs/client-libs/php/logging
Python - https://developers.google.com/google-ads/api/docs/client-libs/python/logging
Ruby - https://developers.google.com/google-ads/api/docs/client-libs/ruby/logging
Perl - https://developers.google.com/google-ads/api/docs/client-libs/perl/logging

Regards,

Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2a2DTC:ref