Re-posting the last inquiry (
https://groups.google.com/g/adwords-api/c/NWvlesi2Of8) from the forum as it
wasn't routed to our support queue.
Regards,
Google Ads API Team
On Wednesday, June 14, 2023 at 8:49:17 PM UTC+8 Nikoloz Chkheidze wrote:
> Hello,
>
> When I make a request to search_stream with the following query, after
> some time this error is being thrown:
>
> Traceback (most recent call last): File
> "/usr/local/lib/python3.10/site-packages/google/api_core/grpc_helpers.py",
> line 112, in __next__ return next(self._wrapped) File
> "/usr/local/lib/python3.10/site-packages/google/ads/googleads/interceptors/response_wrappers.py",
>
> line 108, in __next__ raise e File
> "/usr/local/lib/python3.10/site-packages/google/ads/googleads/interceptors/response_wrappers.py",
>
> line 105, in __next__ self._failure_handler(self._underlay_call) File
> "/usr/local/lib/python3.10/site-packages/google/ads/googleads/interceptors/exception_interceptor.py",
>
> line 71, in _handle_grpc_failure raise
> self._get_error_from_response(response) File
> "/usr/local/lib/python3.10/site-packages/google/ads/googleads/interceptors/response_wrappers.py",
>
> line 88, in __next__ message = next(self._underlay_call) File
> "/usr/local/lib/python3.10/site-packages/grpc/_channel.py", line 475, in
> __next__ return self._next() File
> "/usr/local/lib/python3.10/site-packages/grpc/_channel.py", line 694, in
> _next return self._next_response() File
> "/usr/local/lib/python3.10/site-packages/grpc/_channel.py", line 669, in
> _next_response raise self grpc._channel._SingleThreadedRendezvous:
> <_SingleThreadedRendezvous of RPC that terminated with: status =
> StatusCode.UNAVAILABLE details = "recvmsg:Connection reset by peer"
> debug_error_string = "UNKNOWN:Error received from peer ipv4:
> 64.233.166.95:443 {created_time:"2023-06-14T11:16:20.202841323+00:00",
> grpc_status:14, grpc_message:"recvmsg:Connection reset by peer"}"
>
> Here is the query being used:
>
> SELECT
> segments.date,
> customer.descriptive_name,
> customer.id,
> detail_placement_view.group_placement_target_url,
> detail_placement_view.target_url,
> customer.currency_code,
> metrics.impressions,
> metrics.clicks,
> metrics.cost_micros
> FROM
> detail_placement_view
> WHERE
> segments.date>='2022-01-01' AND segments.date<='2023-05-31' AND
> metrics.cost_micros > 0
>
> The error happens after around 20 minutes of downloading the report.
> Changing the date range to be smaller works fine, the downloading takes
> around 3 hours but it works without an issue, but with the provided query,
> it fails with the error given above in around 20 minutes.
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
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 adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/f265041a-9b3c-413f-93a8-f71b34f40dfan%40googlegroups.com.
