RE: "An internal error has occurred" randomly happens on one of our integration test

[Google Ads API Forum Advisor]

Hi there,

Thanks for reaching out to the Google Ads API Forum.

I had to delete your post as it contained your logs. I am reposting below without the sensitive log information for reference :

“We have an integration test that fails at random and returns  An internal error has occurred message.

These are some logs of the requests that we are making on the test:

Request-------MethodName: google.ads.googleads.v10.services.GoogleAdsService/SearchStream

query: "SELECT ad_group_criterion.criterion_id FROM ad_group_criterion WHERE ad_group.id >= 134714860925 AND ad_group.campaign = \'customers/1754975815/campaigns/17136938565\' ORDER BY ad_group_criterion.criterion_id LIMIT 4"

Failure message: errors {

error_code {

internal_error: INTERNAL_ERROR

}

message: "An internal error has occurred."

}

request_id: "9CSHWD1uXE7744kLDwZdtQ"

Status: Status{code=INTERNAL, description=Internal error encountered., cause=null}.

2022-05-04 11:09:36,741 [grpc-default-executor-0] WARN c.g.a.googleads.lib.request.summary:logAtLevel#159 - FAILURE REQUEST SUMMARY. Method: google.ads.googleads.v10.services.GoogleAdsService/SearchStream, Endpoint: googleads.googleapis.com:443, CustomerID: 1754975815, RequestID: 8n31qKLiD-ndVzKg9hipYg, ResponseCode: INTERNAL, Fault: Internal error encountered..

Request

-------

MethodName: google.ads.googleads.v10.services.GoogleAdsService/SearchStream 

query: "SELECT ad_group_criterion.criterion_id FROM ad_group_criterion WHERE ad_group.id >= 134714860925 AND ad_group.campaign = \'customers/1754975815/campaigns/17136938565\' ORDER BY ad_group_criterion.criterion_id LIMIT 4"

Response

--------

Failure message: errors {

error_code {

internal_error: INTERNAL_ERROR

}

message: "An internal error has occurred."

}

request_id: "8n31qKLiD-ndVzKg9hipYg"

Request

-------

MethodName: google.ads.googleads.v10.services.GoogleAdsService/SearchStream

 query: "SELECT ad_group_criterion.criterion_id FROM ad_group_criterion WHERE ad_group.id >= 134714860925 AND ad_group.campaign = \'customers/1754975815/campaigns/17136938565\' ORDER BY ad_group_criterion.criterion_id LIMIT 4"

I could really use some help with this issue.

Thanks in advance!

--”

 

Upon checking, I can see that your GAQL contains a filter for an ad_group.id >=  in WHERE clause that resulted in internal_error. I’ve replicated on my end as well. Allow me to report this Internal_error with my rest of the team. We will reach out once we have updates.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2aQWmh:ref

[Gianfranco Gallicchio Primavera]

Thanks!

[Gianfranco Gallicchio Primavera]

Hi! Any update on this?

[Bogdan Dumitrescu]

Interested since we have the same issue ... following 

[Google Ads API Forum Advisor]

Hi Gianfranco,

We're still investigating this one, but in the meantime, I noticed that if I remove the condition ad_group.id >= 134714860925 then the query does not return any rows, so the condition isn't actually performing any filtering. Since it's that condition that's leading to the error, you could just filter by ad_group.campaign instead as a workaround.

I'll be sure to let you know as soon as I have any updates.

Thanks,
Josh Radcliff, Google Ads API Team

ref:_00D1U1174p._5004Q2aQWmh:ref

[Google Ads API Forum Advisor]

Hi Gianfranco,

A fix for this issue was deployed over the weekend. Please let me know if you encounter any new occurrences for the queries you mentioned.

Thanks,

Josh Radcliff Google Ads API Team

ref:_00D1U1174p._5004Q2aQWmh:ref