API DOWN for ad_group_ad_asset_view

[Oliver]

Hi,

For the last few hours, the following query (which has been running fine for a long time) suddnely started returning an INTERNAL error for all accounts.

SELECT 

campaign.id, 

ad_group.id, 

ad_group_ad.ad.id, 

asset.text_asset.text, 

metrics.impressions 

FROM ad_group_ad_asset_view

 WHERE asset.type IN ('TEXT') AND

ad_group_ad_asset_view.enabled = 'TRUE' AND

ad_group_ad.ad.type IN ('RESPONSIVE_SEARCH_AD')

Example request IDs that are failing 1syrBXafY0bYDn8vcOO

Can someone from the API team please update us?

Oliver

[Google Ads API Forum Advisor]

Hi Oliver,

Thank you for reaching out to Google Ads API Forum.

I can see that you are encountering INTERNAL_ERROR. This error occurs when something unexpected happened while processing the request. The common cause could be the API isn't functioning correctly. However, this is transient in nature and the API request will work again when retrying it after 30 seconds or some time. That said, can you retry your API request and let us know if the error persists? You may also retry any requests that failed with this error, using an exponential backoff schedule for the retries.

If the error persists after trying the suggested solution, then you may provide to us the complete API logs (request and response with request-id and request header) generated when you encountered the said error. You can provide it via the Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Reference links included in this email:

• INTERNAL_ERROR: https://developers.google.com/google-ads/api/docs/best-practices/common-errors?hl=en#internalerror
• request: https://developers.google.com/google-ads/api/docs/concepts/field-service?hl=en#request
• response: https://developers.google.com/google-ads/api/docs/concepts/field-service?hl=en#response
• request-id: https://developers.google.com/google-ads/api/docs/concepts/call-structure?hl=en#request-id
• request header - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers

 

This message is in relation to case "ref:_00D1U1174p._5004Q2nSfro:ref"

Thanks,
 

Google Ads API Team

[Oliver]

The issue is NOT temporary. We already have a retry mechanism and even after 3 retries (minutes apart) the same operation is failing.  It failed thousands of times over the last few hours.  Please investigate at your end as this is the first time anything like this ever happened in our 10 years of using the API.

[Oliver]

We've sent you the info you requested.  Can you please let us know at your earliest convenience as this is affecting our production system.

Oliver

[Google Ads API Forum Advisor]

Hi Oliver,

Thanks for getting back to us.

Allow me to share this concern with the rest of our team. Rest assured that we will get back to you as soon as we have some updates.
 

[Google Ads API Forum Advisor]

We are able to reproduce the problem and are consulting with the asset team. I'll reply as soon as I have a response.

 

This message is in relation to case "ref:_00D1U1174p._5004Q2nSfro:ref"

Thanks,
 

Bob Hancock Google Ads API Team

[Kevin Nguyen]

We are having a similar problem too.

[Kevin Nguyen]

"SELECT asset.id, asset.type, asset.resource_name, asset.youtube_video_asset.youtube_video_id FROM asset WHERE asset.type in (YOUTUBE_VIDEO) AND asset.id in (93690215637)"

Headers: Metadata(content-type=application/grpc,request-id=M28FfX7O3QQ29st8J98Z8A,date=Wed, 26 Jul 2023 17:40:54 GMT,alt-svc=h3=":443"; ma=2592000,h3-29=":443"; ma=2592000) Body: null Failure message: request_id: "M28FfX7O3QQ29st8J98Z8A" Status: Status{code=INTERNAL, description=Internal error encountered., cause=null}.

[Oliver]

The same problem is also happening with customer_asset.

Hence, so far, the following resources are reported in this thread as experiencing Internal errors:

• ad_group_ad_asset_view
• asset
• customer_asset

Oliver

[Pete Lavetsky (AdWords API Guru)]

We had the same problem start overnight ... it's fixed via any place you reference the AssetType enum you now need to encapsulate as a String ... so your query needs to look like:

"SELECT asset.id, asset.type, asset.resource_name, asset.youtube_video_asset.youtube_video_id FROM asset WHERE asset.type in ( \"YOUTUBE_VIDEO\" ) AND asset.id in (93690215637)"

The original queries we all used still comes back as valid against the GAQL validator : https://developers.google.com/google-ads/api/fields/v14/query_validator

Pete

[Google Ads API Forum Advisor]

>>>We had the same problem start overnight ... it's fixed via any place you reference the AssetType enum you now need to encapsulate as a String ... so your query needs to look like:

"SELECT asset.id, asset.type, asset.resource_name, asset.youtube_video_asset.youtube_video_id FROM asset WHERE asset.type in ( \"YOUTUBE_VIDEO\" ) AND asset.id in (93690215637)"

 

The original queries we all used still comes back as valid against the GAQL validator : https://developers.google.com/google-ads/api/fields/v14/query_validator
<<<

Thank you for the additional data. This is helpful in our debugging.

 

This message is in relation to case "ref:_00D1U1174p._5004Q2nSfro:ref"

Thanks,
 

Bob Hancock Google Ads API Team

[Oliver]

Thank you Pete.  You're a star!