change_status - An internal error has occurred

[Ales Sturala]

Hello,

For the following GAQL query:

SELECT change_status.resource_name, change_status.last_change_date_time, change_status.resource_type FROM change_status WHERE change_status.resource_type="CAMPAIGN_SHARED_SET" AND change_status.last_change_date_time BETWEEN "2022-08-16" AND "2022-09-01" ORDER BY change_status.last_change_date_time DESC LIMIT 10000

We always receive an error within a couple of seconds:

 { "errorCode": { "internalError": "INTERNAL_ERROR" }, "message": "An internal error has occurred." }

 RequestId: nt3XDoyb0Rq3YDUm5VyqBA

ClientCustomerId: 2737840984

Can you please let me know what the problem is? thank you

Best,

 Ales

[Google Ads API Forum Advisor]

Hi Ales,

Thanks for reaching out to the Google Ads API Forum.

I was able to reproduce your issue on my end. Allow me to raise this to my rest of the team. However, could you try to send the request for a smaller date, for example, change_status.last_change_date_time BETWEEN '2022-08-28' AND '2022-09-01' and see if it works on your end? I tried to pull the change_status report data for a smaller date, and it worked. If it still doesn't work, you may provide the complete logs (request and response with request-id) via reply privately to author option.

regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2dtmAQ:ref

[Ales Sturala]

Hello,

So we decreased the GAQL query to 7 days instead of 14, tested it and it seemed to work. Today, when released, it still fails on most of the previously failing accounts :-/

RequestID = jtXDhj0ezVjRxgbacogq0w

RequestID = ic3uYVR6ZE4cK0WM06vGGQ

RequestID = UuQAboG2KiABQi2ls5KSzQ

RequestID = IRB9rvJMYDNuq0y9LbZ4nw

Best,

 Ales

[Google Ads API Forum Advisor]

Hi Ales,

There's too much data for this query for our database servers to handle correctly. You need to add additional filters to reduce the data that the query is trying to fetch. You could try running multiple queries in parallel to make up for the increased number of queries.

Regards
Anash

ref:_00D1U1174p._5004Q2dtmAQ:ref

[Ales Sturala]

Ok thank you for the insight Anash. Since it only affects couple of accounts of the same customer, we will just talked to the customer, explain the situation and not use that report for their accounts.