We trying to access data from API, but it occurs an error today. Please check the information below
SELECT
hotel_performance_view.resource_name,
segments.date,
segments.device,
segments.partner_hotel_id,
segments.hotel_country,
segments.hotel_state,
segments.geo_target_country,
segments.hotel_city,
segments.hotel_price_bucket,
ad_group.id,
ad_group.name,
campaign.id,
campaign.name,
metrics.clicks,
metrics.conversions,
metrics.conversions_value,
metrics.search_impression_share,
metrics.search_top_impression_share,
metrics.cost_micros,
metrics.hotel_price_difference_percentage,
metrics.hotel_eligible_impressions,
metrics.impressions,
metrics.average_cpc,
metrics.ctr,
metrics.cost_per_conversion,
metrics.cost_per_all_conversions,
metrics.value_per_conversion
FROM hotel_performance_view
WHERE segments.date DURING LAST_7_DAYS
[2022-09-28 11:05:59,177] {bash_operator.py:126} INFO - Request made: ClientCustomerId:
7138620827, Host:
googleads.googleapis.com, Method: /google.ads.googleads.v11.services.GoogleAdsService/SearchStream, RequestId: None, IsFault: True, FaultMessage: Stream removed
[2022-09-28 11:05:59,178] {bash_operator.py:126} INFO - ---------------
7138620827---google_ads_meta--------------
[2022-09-28 11:05:59,181] {bash_operator.py:126} INFO - Traceback (most recent call last):
[2022-09-28 11:05:59,181] {bash_operator.py:126} INFO - File "/var/python-server/ads_env/lib/python3.7/site-packages/google/api_core/grpc_helpers.py", line 90, in __next__
[2022-09-28 11:05:59,182] {bash_operator.py:126} INFO - return next(self._wrapped)
[2022-09-28 11:05:59,182] {bash_operator.py:126} INFO - File "/var/python-server/ads_env/lib/python3.7/site-packages/google/ads/googleads/interceptors/response_wrappers.py", line 108, in __next__
[2022-09-28 11:05:59,182] {bash_operator.py:126} INFO - raise e
[2022-09-28 11:05:59,182] {bash_operator.py:126} INFO - File "/var/python-server/ads_env/lib/python3.7/site-packages/google/ads/googleads/interceptors/response_wrappers.py", line 105, in __next__
[2022-09-28 11:05:59,183] {bash_operator.py:126} INFO - self._failure_handler(self._underlay_call)
[2022-09-28 11:05:59,183] {bash_operator.py:126} INFO - File "/var/python-server/ads_env/lib/python3.7/site-packages/google/ads/googleads/interceptors/exception_interceptor.py", line 71, in _handle_grpc_failure
[2022-09-28 11:05:59,183] {bash_operator.py:126} INFO - raise self._get_error_from_response(response)
[2022-09-28 11:05:59,183] {bash_operator.py:126} INFO - File "/var/python-server/ads_env/lib/python3.7/site-packages/google/ads/googleads/interceptors/response_wrappers.py", line 88, in __next__
[2022-09-28 11:05:59,184] {bash_operator.py:126} INFO - message = next(self._underlay_call)
[2022-09-28 11:05:59,184] {bash_operator.py:126} INFO - File "/var/python-server/ads_env/lib/python3.7/site-packages/grpc/_channel.py", line 426, in __next__
[2022-09-28 11:05:59,184] {bash_operator.py:126} INFO - return self._next()
[2022-09-28 11:05:59,184] {bash_operator.py:126} INFO - File "/var/python-server/ads_env/lib/python3.7/site-packages/grpc/_channel.py", line 642, in _next
[2022-09-28 11:05:59,184] {bash_operator.py:126} INFO - return self._next_response()
[2022-09-28 11:05:59,185] {bash_operator.py:126} INFO - File "/var/python-server/ads_env/lib/python3.7/site-packages/grpc/_channel.py", line 617, in _next_response
[2022-09-28 11:05:59,185] {bash_operator.py:126} INFO - raise self
[2022-09-28 11:05:59,185] {bash_operator.py:126} INFO - grpc._channel._SingleThreadedRendezvous: <_SingleThreadedRendezvous of RPC that terminated with:
[2022-09-28 11:05:59,185] {bash_operator.py:126} INFO - status = StatusCode.UNKNOWN
[2022-09-28 11:05:59,186] {bash_operator.py:126} INFO - details = "Stream removed"
[2022-09-28 11:05:59,186] {bash_operator.py:126} INFO - debug_error_string = "{"created":"@1664334359.172630877","description":"Error received from peer ipv4:
142.250.66.42:443","file":"src/core/lib/surface/call.cc","file_line":1070,"grpc_message":"Stream removed","grpc_status":2}"