Change History API throwing Internal Error for a particular account

[Arun S R]

I am getting the following error when I make a GAQL request for a particular account. It seems to work for other accounts. Please Help.

{
  "StatusCode": 13,
  "Details": "Internal error encountered.",
  "RequestId": "UrPzzhhjkmuMky-BtUeomA",
  "Failure": {
    "requestId": "UrPzzhhjkmuMky-BtUeomA"
  }
}

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

As per provided information, I understand that you are getting 'INTERNAL_ERROR' while making a GAQL request. Do note that the INTERNAL_ERROR occurs when something unexpected happens 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. You may also retry any requests that failed with this error, using an  Exponential backoff schedule for the retries. Here is a code example demonstrating how to implement an exponential back off strategy.

If the issue still persists, then provide us with the below information, so that we can investigate this issue further.

• Affected Customer Id
• Date of this issue started
• How much time did you wait before retry of a request
• complete API logs (request and response with request-id and request header) generated at your end.

If you are using a client library and haven't enabled the logging yet, I would request you to enable logging for the specific client library that you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag.

You can send the details via Reply privately to the author option, or direct private reply to this email.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tJDdb:ref" (ADR-00238459)

Thanks,
 

Google Ads API Team

[Arun S R]

The internal error in this particular account has not been resolved even when tried after significant interval. Please find the attached log and details and help solve this issue at the earliest. 

Affected Customer ID:  1425022273
Date of issue beginning: June 5 2024
Time waited before trying again: Days

LOG:
Request
-------

Method Name: /google.ads.googleads.v15.services.GoogleAdsService/SearchStream
Host:
Headers: {
  "x-goog-api-client": "gl-dotnet/6.0.0 gapic/17.1.0 gax/4.2.0+a8085e4f36ad24e2747b5e550f11079d4a891e78 grpc/2.46.3 gccl/3.1.0 pb/3.21.5+638779f353731a0a04496bde20d14164684c3d93",
  "developer-token": "REDACTED",
  "login-customer-id": "1425022273",
  "x-goog-request-params": "customer_id=1425022273"
}

{ "customerId": "1425022273", "query": "REDACTED", "summaryRowSetting": "NO_SUMMARY_ROW" }

Response
--------
Headers: {
  "request-id": "6aT3ZFjYMcj84ZAsGCOgOw",
  "date": "Tue, 18 Jun 2024 12:22:02 GMT",
  "alt-svc": "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000",
  "google.ads.googleads.v15.errors.googleadsfailure-bin": "EhY2YVQzWkZqWU1jajg0WkFzR0NPZ093",
  "grpc-status-details-bin": "CA0SG0ludGVybmFsIGVycm9yIGVuY291bnRlcmVkLhpgCkR0eXBlLmdvb2dsZWFwaXMuY29tL2dvb2dsZS5hZHMuZ29vZ2xlYWRzLnYxNS5lcnJvcnMuR29vZ2xlQWRzRmFpbHVyZRIYEhY2YVQzWkZqWU1jajg0WkFzR0NPZ093"
}

Fault: {

  "StatusCode": 13,
  "Details": "Internal error encountered.",

  "RequestId": "6aT3ZFjYMcj84ZAsGCOgOw",
  "Failure": {
    "requestId": "6aT3ZFjYMcj84ZAsGCOgOw"
  }
}
----------------END API CALL----------------

Query:

SELECT change_event.ad_group, change_event.campaign, change_event.asset, change_event.change_date_time, change_event.change_resource_name, change_event.change_resource_type, change_event.changed_fields, change_event.client_type, change_event.feed, change_event.feed_item, change_event.new_resource, change_event.old_resource, change_event.resource_change_operation, change_event.resource_name, change_event.user_email FROM change_event WHERE change_event.change_date_time >= '20240521' AND change_event.change_date_time <= '20240619' ORDER BY change_event.change_date_time DESC LIMIT 10000

[Google Ads API Forum Advisor]

Hi,

I will check with our team regarding your issue and one of my team members will reach out to you once we have an update on this. Meanwhile, your patience is highly appreciated.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tJDdb:ref" (ADR-00238459)

Thanks,
 

Google Ads API Team

Register for the upcoming workshop: Performance Max and the Google Ads API!
 

[Google Ads API Forum Advisor]

Hi,

I have tried to reduce the date range from 'change_event.change_date_time >= '20240521' to 'change_event.change_date_time >= '20240531' and am able to get the results. Could you retry your query by reducing the duration of days, please see the below sample query for reference:

{
  "query": "SELECT change_event.ad_group, change_event.campaign, change_event.asset, change_event.change_date_time, change_event.change_resource_name, change_event.change_resource_type, change_event.changed_fields, change_event.client_type, change_event.feed, change_event.feed_item, change_event.new_resource, change_event.old_resource, change_event.resource_change_operation, change_event.resource_name, change_event.user_email FROM change_event WHERE change_event.change_date_time >= '20240531' AND change_event.change_date_time <= '20240619' ORDER BY change_event.change_date_time DESC LIMIT 10000"
}

You can try making a request using the Search or SearchStream. Also, you can use Query Builder to create your query and Query Validator to validate your query. I hope this helps, let me know how this goes on your end.

[Arun S R]

What is incorrect with the date range? we would like to get as much changes as possible from the API. As per documentation 30 days is available. What is wrong with the above query I had posted? Because it is only failing for this account/customer id,  can you help?

[Google Ads API Forum Advisor]

Hi,

I will check with our team regarding your issue and one of my team members will reach out to you once we have an update on this. Meanwhile, your patience is highly appreciated.
 

[Google Ads API Forum Advisor]

Hi,

Thanks for your patience with the issue. We have raised this issue to the according engineering team to take a further look. Once there is any update, I will get back to this thread.

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tJDdb:ref" (ADR-00238459)

Thanks,
 

Google Ads API Team