Internal server error

[Kelly Dougan]

I am writing to determine the cause of an error I got using the python google ads api to make the following query:

select ad_group.base_ad_group, ad_group.campaign, ad_group.cpc_bid_micros, ad_group.cpm_bid_micros, ad_group.cpv_bid_micros, ad_group.id, ad_group.labels, ad_group.name, ad_group.resource_name, ad_group.status, ad_group.targeting_setting.target_restrictions, ad_group.tracking_url_template, ad_group.type, ad_group.url_custom_parameters, segments.ad_network_type, segments.conversion_action, segments.date, segments.day_of_week, segments.device, metrics.absolute_top_impression_percentage, metrics.average_page_views, metrics.average_time_on_site, metrics.bounce_rate, metrics.clicks, metrics.content_impression_share, metrics.content_rank_lost_impression_share, metrics.conversions, metrics.conversions_from_interactions_rate, metrics.conversions_value, metrics.cost_micros, metrics.cross_device_conversions, metrics.engagements, metrics.impressions, metrics.interaction_event_types, metrics.interaction_rate, metrics.interactions, metrics.percent_new_visitors, metrics.relative_ctr, metrics.search_absolute_top_impression_share, metrics.search_budget_lost_absolute_top_impression_share, metrics.search_budget_lost_top_impression_share, metrics.search_exact_match_impression_share, metrics.search_impression_share, metrics.search_rank_lost_absolute_top_impression_share, metrics.search_rank_lost_impression_share, metrics.search_rank_lost_top_impression_share, metrics.search_top_impression_share, metrics.top_impression_percentage, metrics.video_quartile_100_rate, metrics.video_quartile_25_rate, metrics.video_quartile_50_rate, metrics.video_quartile_75_rate, metrics.video_view_rate, metrics.video_views from ad_group where segments.date DURING LAST_7_DAYS LIMIT 10 

The error I received was: 

grpc._channel._InactiveRpcError: <_InactiveRpcError of RPC that terminated with:

        status = StatusCode.INTERNAL

        details = "Internal error encountered."

        debug_error_string = "{"created":"@1589505513.410897000","description":"Error received from peer ipv6:[2607:f8b0:4005:80b::200a]:443","file":"src/core/lib/surface/call.cc","file_line":1056,"grpc_message":"Internal error encountered.","grpc_status":13}"

The code I'm using works for other, similar queries.

[Google Ads API Forum Advisor Prod]

Hi Kelly,

The report query you are using has a lot of fields, as well as a segment on date, which may cause your report to be too large. Please try to use fewer fields and/or use more filters and see if that resolves your issue.

Regards,
Anthony
Google Ads API Team

ref:_00D1U1174p._5004Q1zpVeh:ref

[Kelly Dougan]

I was able to resolve this by removing the ad_group.labels field. Is this field deprecated? Can you provide any information why this would cause an error?

[Google Ads API Forum Advisor Prod]

Hi Kelly,

The labels field shouldn't cause any issues. Can you please reply privately to author your CID, report query and full error response so I can take a closer look?

Thanks,