RE: queries on product_group_view yield internal error

[Google Ads API Forum Advisor]

Hi, 

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

Upon checking the logs, I understand that you are getting an Internal Error. Kindly note Internal Error occurs when something unexpected happens while processing the request. You can refer to the documentation, to know how to handle the Internal Error. When you retry requests, use an exponential backoff policy. For example, if you first pause 5 seconds before the first retry, you could pause 10 seconds after the second and 20 seconds after the third retry. Exponential backoff helps ensure you are not calling the API too many times.

If the issue still persists, could you please provide us the complete API logs (request and response with request-id and request header) generated at your end to assist you further.

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:_00D1U1174p._5004Q2pRLZH:ref"

Thanks,
 

Google Ads API Team

[Konstantin Tarassow]

Hello, this has nothing to do with retries, it just happens at any time I try the request, since weeks.

You can see an example request + response incl. headers and ids in my first message.

[Google Ads API Forum Advisor]

Hi, 

Thank you for getting back to us.

Please be informed that I have removed your response from the forums as it contains the PII information.

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.!5004Q02pRLZH:ref"

Thanks,
 

Google Ads API Team

[Konstantin Tarassow]

Hello, is there any update on this? 

[Google Ads API Forum Advisor]

This was just passed to me and I'm consulting with one of my colleagues who works on this area of the API. I will respond here when I have a response.

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02pRLZH:ref"

Thanks,
 

Bob Hancock Google Ads API Team

[Google Ads API Forum Advisor]

This customer (cid 17519553) has corrupted product group trees, which are causing account-level requests to fail. At lest AdGroupId 54994418316 contains corrupted data. Engineering is working on correcting this.

[Google Ads API Forum Advisor]

I just spoke with my colleague and they cannot fix it on the back end. The workaround is:

• Recreate the AdGroup.
• Delete the original AdGroup that has the corrupted data.
• Let me know the results.

[Konstantin Tarassow]

Hello,

we are now running into an Internal Error when fetching product_group_view data for another client:

Does it have the same problem with corrupt product partitions?

Here are the request/response logs incl. request-id:

Method Name: /google.ads.googleads.v14.services.GoogleAdsService/SearchStream
Host: googleads.googleapis.com
Headers: {
    "x-goog-api-client": "gl-php\/8.0.30 gccl\/19.2.0 gapic\/19.2.0 gax\/1.18.2 grpc\/1.50.2 rest\/1.18.2 pb\/+n",
    "x-goog-request-params": "customer_id=8875125139",
    "developer-token": "REDACTED",
    "login-customer-id": "4554523147"
}
Request:
{"customerId":"8875125139","query":"\n                    SELECT segments.date,\ncampaign.id,\nad_group.id,\nad_group_criterion.criterion_id,\nad_group_criterion.criterion_id,\nsegments.ad_network_type,\nsegments.device,\nmetrics.cost_micros,\nmetrics.clicks,\nmetrics.impressions,\nmetrics.impressions\n                    FROM product_group_view\n                    WHERE segments.date BETWEEN '2023-12-14' AND '2023-12-14'\n                    AND campaign.status IN(ENABLED, PAUSED, REMOVED)\n                    AND ad_group.status IN(ENABLED, PAUSED, REMOVED)\n                    AND ad_group_criterion.status IN(ENABLED, PAUSED, REMOVED)\n                    AND ad_group_criterion.listing_group.type = 'UNIT'\n                 AND metrics.impressions > 0  AND segments.date = '2023-12-14' "}

Response
-------
Headers: {
    "request-id": "I7uqA2oUyo_NYQHPRwWIiQ",
    "date": "Fri, 15 Dec 2023 18:08:04 GMT",
    "alt-svc": "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
}

Fault
-------
Status code: 13
Details: Internal error encountered.
Failure: {"errors":[{"errorCode":{"internalError":"INTERNAL_ERROR"},"message":"An internal error has occurred."}],"requestId":"I7uqA2oUyo_NYQHPRwWIiQ"}
Exception in retryDecider: {
    "message": "Internal error encountered.",
    "code": 13,
    "status": "INTERNAL",
    "details": [
        {
            "@type": "google.ads.googleads.v14.errors.googleadsfailure-bin",
            "data": "<Unknown Binary Data>"
        },
        {
            "@type": "grpc-status-details-bin",
            "data": "<Unknown Binary Data>"
        },
        {
            "@type": "request-id",
            "data": "I7uqA2oUyo_NYQHPRwWIiQ"
        }
    ]
}

[Google Ads API Forum Advisor]

Before replying, please let me know if you followed the steps I recommended on 14 November 2023.