Here is the logs for same. With DEBUG level, logger used was Rails.logger
I, [2025-01-14T07:56:27.781364 #296] INFO -- : CID: 7939080607, Host:
googleads.googleapis.com:443, Method:
/google.ads.googleads.v16.services.GoogleAdsService/SearchStream, IsFault:
no, Request ID: N/A
D, [2025-01-14T07:56:27.836071 #296] DEBUG -- : ETHON: Libcurl initialized
D, [2025-01-14T07:56:27.926718 #296] DEBUG -- : ETHON: performed EASY
effective_url=https://www.googleapis.com/oauth2/v3/token response_code=200
return_code=ok total_time=0.088691
W, [2025-01-14T08:16:27.782679 #296] WARN -- : CID: 7939080607, Host:
googleads.googleapis.com:443, Method:
/google.ads.googleads.v16.services.GoogleAdsService/SearchStream, IsFault:
yes, Request ID: N/A
I, [2025-01-14T08:16:27.783025 #296] INFO -- : Outgoing request: Headers:
{"developer-token":"REDACTED","login-customer-id":"3661020287","x-goog-api-client":"gl-ruby/3.1.4
gccl/27.0.0 gax/0.21.1 gapic/27.0.0 grpc/1.62.0
pb/3.25.5","x-goog-request-params":"customer_id=7939080607"} Payload:
{"customerId":"7939080607","query":" SELECT asset.id, ad_group_ad.ad.type,
ad_group_ad_asset_view.resource_name,
ad_group_ad_asset_view.performance_label, ad_group_ad_asset_view.asset,
asset.type, asset.text_asset.text, asset.sitelink_asset.link_text,
asset.sitelink_asset.description1, asset.sitelink_asset.description2,
asset.structured_snippet_asset.header,
asset.structured_snippet_asset.values,
asset.call_to_action_asset.call_to_action, asset.name,
asset.youtube_video_asset.youtube_video_title,
ad_group_ad.ad.discovery_carousel_ad.description,
ad_group_ad.ad.discovery_carousel_ad.headline,
ad_group_ad.ad.discovery_carousel_ad.call_to_action_text,
asset.image_asset.full_size.url,
asset.youtube_video_asset.youtube_video_id,
asset.discovery_carousel_card_asset.square_marketing_image_asset,
asset.discovery_carousel_card_asset.portrait_marketing_image_asset,
asset.discovery_carousel_card_asset.marketing_image_asset,
asset.image_asset.full_size.height_pixels,
asset.image_asset.full_size.width_pixels\n FROM ad_group_ad_asset_view\n
WHERE ad_group_ad.ad.type in ('RESPONSIVE_SEARCH_AD', 'APP_AD',
'DISCOVERY_CAROUSEL_AD', 'DISCOVERY_MULTI_ASSET_AD',
'DISCOVERY_VIDEO_RESPONSIVE_AD')\n AND asset.type in ('TEXT', 'IMAGE',
'YOUTUBE_VIDEO', 'CALL_TO_ACTION', 'DISCOVERY_CAROUSEL_CARD', 'SITELINK',
'STRUCTURED_SNIPPET', 'UNKNOWN')\n AND segments.date\nBETWEEN
'2025-01-13'\n AND '2025-01-13'\n AND metrics.impressions > 0\n"}
I, [2025-01-14T08:16:27.783246 #296] INFO -- : Incoming response (errors):
GRPC::Core::CallError(grpc_call_start_batch failed with outstanding read
or write present (code=8)):
called from:
/home/deploy/.rvm/gems/ruby-3.1.4/gems/activesupport-6.1.7.8/lib/active_support/logger_thread_safe_level.rb:67:in
`add'
W, [2025-01-14T08:16:27.783440 #296] WARN -- : Query errored with
grpc_call_start_batch failed with outstanding read or write present
(code=8). Retrying with query batched on campaigns!
Details: {:query=>" SELECT asset.id, ad_group_ad.ad.type,
ad_group_ad_asset_view.resource_name,
ad_group_ad_asset_view.performance_label, ad_group_ad_asset_view.asset,
asset.type, asset.text_asset.text, asset.sitelink_asset.link_text,
asset.sitelink_asset.description1, asset.sitelink_asset.description2,
asset.structured_snippet_asset.header,
asset.structured_snippet_asset.values,
asset.call_to_action_asset.call_to_action, asset.name,
asset.youtube_video_asset.youtube_video_title,
ad_group_ad.ad.discovery_carousel_ad.description,
ad_group_ad.ad.discovery_carousel_ad.headline,
ad_group_ad.ad.discovery_carousel_ad.call_to_action_text,
asset.image_asset.full_size.url,
asset.youtube_video_asset.youtube_video_id,
asset.discovery_carousel_card_asset.square_marketing_image_asset,
asset.discovery_carousel_card_asset.portrait_marketing_image_asset,
asset.discovery_carousel_card_asset.marketing_image_asset,
asset.image_asset.full_size.height_pixels,
asset.image_asset.full_size.width_pixels\n FROM ad_group_ad_asset_view\n
WHERE ad_group_ad.ad.type in ('RESPONSIVE_SEARCH_AD', 'APP_AD',
'DISCOVERY_CAROUSEL_AD', 'DISCOVERY_MULTI_ASSET_AD',
'DISCOVERY_VIDEO_RESPONSIVE_AD')\n AND asset.type in ('TEXT', 'IMAGE',
'YOUTUBE_VIDEO', 'CALL_TO_ACTION', 'DISCOVERY_CAROUSEL_CARD', 'SITELINK',
'STRUCTURED_SNIPPET', 'UNKNOWN')\n AND segments.date\nBETWEEN
'2025-01-13'\n AND '2025-01-13'\n AND metrics.impressions > 0\n",
:account_id=>6263, :company_id=>706}
I, [2025-01-14T08:16:27.927913 #296] INFO -- : CID: 7939080607, Host:
googleads.googleapis.com:443, Method:
/google.ads.googleads.v16.services.GoogleAdsService/SearchStream, IsFault:
no, Request ID: N/A
W, [2025-01-14T08:36:27.928456 #296] WARN -- : CID: 7939080607, Host:
googleads.googleapis.com:443, Method:
/google.ads.googleads.v16.services.GoogleAdsService/SearchStream, IsFault:
yes, Request ID: N/A
I, [2025-01-14T08:36:27.928653 #296] INFO -- : Outgoing request: Headers:
{"developer-token":"REDACTED","login-customer-id":"3661020287","x-goog-api-client":"gl-ruby/3.1.4
gccl/27.0.0 gax/0.21.1 gapic/27.0.0 grpc/1.62.0
pb/3.25.5","x-goog-request-params":"customer_id=7939080607"} Payload:
{"customerId":"7939080607","query":" SELECT asset.id, ad_group_ad.ad.type,
ad_group_ad_asset_view.resource_name,
ad_group_ad_asset_view.performance_label, ad_group_ad_asset_view.asset,
asset.type, asset.text_asset.text, asset.sitelink_asset.link_text,
asset.sitelink_asset.description1, asset.sitelink_asset.description2,
asset.structured_snippet_asset.header,
asset.structured_snippet_asset.values,
asset.call_to_action_asset.call_to_action, asset.name,
asset.youtube_video_asset.youtube_video_title,
ad_group_ad.ad.discovery_carousel_ad.description,
ad_group_ad.ad.discovery_carousel_ad.headline,
ad_group_ad.ad.discovery_carousel_ad.call_to_action_text,
asset.image_asset.full_size.url,
asset.youtube_video_asset.youtube_video_id,
asset.discovery_carousel_card_asset.square_marketing_image_asset,
asset.discovery_carousel_card_asset.portrait_marketing_image_asset,
asset.discovery_carousel_card_asset.marketing_image_asset,
asset.image_asset.full_size.height_pixels,
asset.image_asset.full_size.width_pixels\n FROM ad_group_ad_asset_view\n
WHERE ad_group_ad.ad.type in ('RESPONSIVE_SEARCH_AD', 'APP_AD',
'DISCOVERY_CAROUSEL_AD', 'DISCOVERY_MULTI_ASSET_AD',
'DISCOVERY_VIDEO_RESPONSIVE_AD')\n AND asset.type in ('TEXT', 'IMAGE',
'YOUTUBE_VIDEO', 'CALL_TO_ACTION', 'DISCOVERY_CAROUSEL_CARD', 'SITELINK',
'STRUCTURED_SNIPPET', 'UNKNOWN')\n AND segments.date\nBETWEEN
'2025-01-13'\n AND '2025-01-13'\n AND metrics.impressions > 0\n AND
campaign.id IN (10033665967, 10033665982, 10033665988, 10033665991,
10051215287, 10051215290, 10051215293, 10051215296, 11444564124,
11444564778, 11444564781, 11869174529, 11869174532, 11869174541,
11869174544, 11869174547, 11869174550, 11869174556, 11869174559,
11869174682, 11869174691, 11869174703, 11869174712, 11869174718,
11869174730)"}
I, [2025-01-14T08:36:27.928759 #296] INFO -- : Incoming response (errors):
GRPC::Core::CallError(grpc_call_start_batch failed with outstanding read
or write present (code=8)):
called from:
/home/deploy/.rvm/gems/ruby-3.1.4/gems/activesupport-6.1.7.8/lib/active_support/logger_thread_safe_level.rb:67:in
`add'
/home/deploy/.rvm/gems/ruby-3.1.4/gems/grpc-1.62.0-x86_64-linux/src/ruby/lib/grpc/generic/active_call.rb:169:in
`run_batch': grpc_call_start_batch failed with outstanding read or write
present (code=8) (GRPC::Core::CallError)
/home/deploy/.rvm/gems/ruby-3.1.4/gems/grpc-1.62.0-x86_64-linux/src/ruby/lib/grpc/generic/active_call.rb:169:in
`run_batch': grpc_call_start_batch failed with outstanding read or write
present (code=8) (GRPC::Core::CallError)
On Monday, January 6, 2025 at 6:43:29 PM UTC+5:30 Google Ads API and
AdWords API Forum wrote:
Hi,
Thank you for reaching out to the Google Ads API support team.
>From the provided information which indicates that the query contains
multiple fields, which may be causing the error. To troubleshoot this,
consider breaking down the query into smaller groups.
If the issue still persists, kindly provide the complete API logs (request
<https://developers.google.com/google-ads/api/docs/concepts/field-service#request>
and response
<https://developers.google.com/google-ads/api/docs/concepts/field-service#response>
with request-id
<https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id>
and request header
<https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers>)
generated at your end when you are creating click conversations. Please
note that logs are crucial to replicate and address your issue.
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 guide Ruby
<https://developers.google.com/google-ads/api/docs/client-libs/ruby/logging> to
enable logging at your end. For REST interface requests, you can enable
logging via the curl command by using the -i flag.
Also, note that you are using 'v16' which is deprecated. I would suggest
you upgrade to the latest version
<https://developers.google.com/google-ads/api/docs/upgrade>, 'v18
<https://developers.google.com/google-ads/api/docs/release-notes#v18_2024-10-16>',
as soon as possible to benefit from new features. You may refer to this
documentation on deprecation and sunset
<https://developers.google.com/google-ads/api/docs/sunset-dates> for more
information regarding the specific deprecation and sunset dates for each
available version
You can send the details via *Reply privately to the author option*, or *direct
private reply* to this email.
Thanks,
The Google Ads API Team.
On Saturday, January 4, 2025 at 5:34:47 AM UTC+5:30
[email protected] wrote:
W, [2025-01-03T08:48:37.354177 #596] WARN -- : CID: REDACTED, Host:
googleads.googleapis.com:443, Method:
/google.ads.googleads.v16.services.GoogleAdsService/SearchStream, IsFault:
yes, Request ID: N/AI, [2025-01-03T08:48:37.354365 #596] INFO -- : Outgoing
request: Headers:
{"developer-token":"REDACTED","login-customer-id":"REDACTED","x-goog-api-client":"gl-ruby/3.1.4
gccl/27.0.0 gax/0.21.1 gapic/27.0.0 grpc/1.62.0
pb/3.25.5","x-goog-request-params":"customer_id=REDACTED"} Payload:
{"customerId":"REDACTED","query":"SELECT ad_group.id, ad_group_ad.ad.id,
ad_group_ad.ad.name, ad_group_ad.ad.type, ad_group_ad.status,
ad_group_ad.ad.display_url, ad_group_ad.ad.final_urls,
ad_group_ad.ad.device_preference, ad_group_ad.primary_status,
ad_group_ad.primary_status_reasons, ad_group_ad.ad.text_ad.headline,
ad_group_ad.ad.text_ad.description1, ad_group_ad.ad.text_ad.description2,
ad_group_ad.ad.image_ad.image_url,
ad_group_ad.ad.image_ad.preview_image_url,
ad_group_ad.ad.image_ad.pixel_height, ad_group_ad.ad.image_ad.pixel_width,
ad_group_ad.ad.expanded_text_ad.headline_part1,
ad_group_ad.ad.expanded_text_ad.headline_part2,
ad_group_ad.ad.expanded_text_ad.headline_part3,
ad_group_ad.ad.expanded_text_ad.description,
ad_group_ad.ad.expanded_text_ad.description2,
ad_group_ad.ad.expanded_text_ad.path1,
ad_group_ad.ad.expanded_text_ad.path2,
ad_group_ad.ad.responsive_search_ad.headlines,
ad_group_ad.ad.responsive_search_ad.descriptions,
ad_group_ad.ad.responsive_search_ad.path1,
ad_group_ad.ad.responsive_search_ad.path2,
ad_group_ad.ad.legacy_responsive_display_ad.marketing_image,
ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image,
ad_group_ad.ad.legacy_responsive_display_ad.business_name,
ad_group_ad.ad.legacy_responsive_display_ad.long_headline,
ad_group_ad.ad.legacy_responsive_display_ad.short_headline,
ad_group_ad.ad.expanded_dynamic_search_ad.description FROM ad_group_ad
WHERE segments.date BETWEEN '2024-12-29' AND '2024-12-29' AND
metrics.impressions > 0"} I, [2025-01-03T08:48:37.354464 #596] INFO -- :
Incoming response (errors): GRPC::Core::CallError(grpc_call_start_batch
failed with outstanding read or write present (code=8)): called from: /home/
deploy/.rvm/gems/ruby-3.1.4/gems/activesupport-6.1.7.8/lib/active_support/
logger_thread_safe_level.rb:67:in `add'
/home/deploy/.rvm/gems/ruby-3.1.4/gems/grpc-1.62.0-x86_64-linux/src/ruby/lib/grpc/generic/active_call.rb:169:in
`run_batch': grpc_call_start_batch failed with outstanding read or write
present (code=8) (GRPC::Core::CallError)
I see when I do query with lesser number of select fields, it returns
response.
I tried by doing only 1 Day in date range (29 Dec 2024) and also with
`LIMIT 1`.
GRPC Timeout: 20 min
Please Help
Thanks
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/adwords-api/ef79c3fb-b68c-4444-b20e-315997814f54n%40googlegroups.com.
