Re: Campaign API failed due to Connection Time Out

['changhong yun' via Google Ads API and AdWords API Forum]

Hi,

 Thanks for your feedback, could you guide me which error type we 
should include to proceed retry? Coz we won't add all the exceptions for 
retry handling. Thank you very much.

Regards,
Aaron

On Saturday, May 20, 2023 at 5:03:14 AM UTC+8 Google Ads API and AdWords 
API Forum wrote:

> Hi,
>
> Thank you for raising this issue to the Google Ads API support team.
>
> Regarding your concern, can you confirm if you already retry your request 
> and yet you still got the same error? If you haven't yet, I suggest doing 
> so. Also, you may check this Timeout (
>
> https://developers.google.com/google-ads/api/docs/client-libs/java/advanced-usage#timeout)
>  
> document for reference.
>
> Regards,
> Google Ads API Team
> On Friday, May 19, 2023 at 10:11:20 AM UTC+8 changh...@rakuten.com wrote:
>
>> Hi Team, we hit one exception regarding the timeout, could you please 
>> check the issue log as below, thank you very much.
>>
>> date:2023-05-19T05:43:41.037+09:00 thread:grpc-default-executor-7 track: 
>> level:WARN logger:com.google.ads.googleads.lib.request.summary 
>> message:FAILURE 
>> REQUEST SUMMARY. Method: 
>> google.ads.googleads.v12.services.GoogleAdsService/SearchStream, Endpoint: 
>> googleads.googleapis.com:443, CustomerID: 5014627391 <(501)%20462-7391>, 
>> RequestID: null, ResponseCode: UNAVAILABLE, Fault: io exception.
>>
>> date:2023-05-19T05:43:41.040+09:00 thread:grpc-default-executor-7 track: 
>> level:INFO logger:com.google.ads.googleads.lib.request.detail 
>> message:FAILURE 
>> REQUEST DETAIL.
>>
>> Request
>>
>> ---
>>
>> MethodName: 
>> google.ads.googleads.v12.services.GoogleAdsService/SearchStream
>>
>> Endpoint: googleads.googleapis.com:443
>>
>> Headers: {developer-token=REDACTED, login-customer-id=5693729523, 
>> x-goog-api-client=gl-java/17.0.2 gccl/22.0.0 gapic/22.0.0 gax/2.12.2 
>> grpc/1.44.0 pb/3.19.6}
>>
>> Body: customer_id: "5014627391 <(501)%20462-7391>"
>>
>> query: "SELECT customer.id, campaign.id, campaign_budget.amount_micros 
>> FROM campaign WHERE segments.date = \'2023-05-19\' ORDER BY campaign.id"
>>
>>
>>
>> Response
>>
>> 
>>
>> Headers: null
>>
>> Body: null
>>
>> Failure message: null
>>
>> Status: Status{code=UNAVAILABLE, description=io exception, 
>> cause=io.grpc.netty.shaded.io.netty.channel.unix.Errors$NativeIoException: 
>> readAddress(..) failed: Connection timed out
>>
>> }.
>>
>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/7e079c62-1a0f-4da6-8954-75d20ccc1857n%40googlegroups.com.

Campaign API failed due to Connection Time Out

['changhong yun' via Google Ads API and AdWords API Forum]

Hi Team, we hit one exception regarding the timeout, could you please check 
the issue log as below, thank you very much.

date:2023-05-19T05:43:41.037+09:00 thread:grpc-default-executor-7 track: 
level:WARN logger:com.google.ads.googleads.lib.request.summary message:FAILURE 
REQUEST SUMMARY. Method: 
google.ads.googleads.v12.services.GoogleAdsService/SearchStream, Endpoint: 
googleads.googleapis.com:443, CustomerID: 5014627391, RequestID: null, 
ResponseCode: UNAVAILABLE, Fault: io exception.

date:2023-05-19T05:43:41.040+09:00 thread:grpc-default-executor-7 track: 
level:INFO logger:com.google.ads.googleads.lib.request.detail message:FAILURE 
REQUEST DETAIL.

Request

---

MethodName: google.ads.googleads.v12.services.GoogleAdsService/SearchStream

Endpoint: googleads.googleapis.com:443

Headers: {developer-token=REDACTED, login-customer-id=5693729523, 
x-goog-api-client=gl-java/17.0.2 gccl/22.0.0 gapic/22.0.0 gax/2.12.2 
grpc/1.44.0 pb/3.19.6}

Body: customer_id: "5014627391"

query: "SELECT customer.id, campaign.id, campaign_budget.amount_micros FROM 
campaign WHERE segments.date = \'2023-05-19\' ORDER BY campaign.id"



Response



Headers: null

Body: null

Failure message: null

Status: Status{code=UNAVAILABLE, description=io exception, 
cause=io.grpc.netty.shaded.io.netty.channel.unix.Errors$NativeIoException: 
readAddress(..) failed: Connection timed out

}.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/f5112d34-9540-452c-80fc-2cdef0683035n%40googlegroups.com.

Re: INTERNAL ERROR occur get Metrics and Campaign Data using Google Ads API V10 version

['changhong yun' via Google Ads API and AdWords API Forum]

Hi Team,

 Thanks for your feedback. I'v added the retry mechanism and wait for 
at least 900secs to process rest apis.

 Actually I'm still curious about the < RESOURCE_EXHAUSTED error>, 
actually our project even didn't exceed the maximum quota(15,000) for this 
case.

 Anyway, let me proceed it firstly then give you feedback later.

Regards,
Aaron.

On Thursday, December 22, 2022 at 4:51:03 PM UTC+8 adsapi wrote:

> Hi Aaron,
>
>
>
> Thanks for getting back to us.
>
> Could you confirm if you again hit the RESOURCE_EXHAUSTED error after 
> implementing the exponential back off policy and rate limiter? If yes, our 
> team requires the most recent complet logs in order to investigate the 
> issue further.
>
> When receiving a RESOURCE_EXHAUSTED error, you must wait for the duration 
> stated in the error description, or else the API will start increasing the 
> wait time, which is likely why you see it up to 900 seconds. Continuing to 
> retry before that time is going to cause many, many more errors, which will 
> generally ruin your throughput.
>
> Most likely what happened is you got one error, didn't wait, and then it 
> escalated until all or most of your requests were rejected by not abiding 
> by the rate limit.
>
> Kindly see below responses to your questions:
>
>
>
> *a. If no data for API request return, does it still mean one API 
> operation and count into maximum requests?*
>
> >> API operations are the total sum of get requests and mutate operations. 
> If you have sent one API request for the search or searchStream and the API 
> request did not return any response, then it will be considered as 1 
> operation consumed. A request that is not a Get, Mutate, Search, or 
> SearchStream request counts as one operation against the user's daily 
> operation quota. Requests that are rejected with a *GoogleAdsFailure* 
> 
>  
> still count against the user's daily operation quota.
>
> On the other hand, requests that fail but don't return a 
> *GoogleAdsFailure* 
> ,
>  
> such as from an error at the network level, won't count against the user's 
> daily operation quota since the requests would never reach the service. An 
> example of this is a network connectivity failure.
>
>  *b. How to calculate the API requests total count from my side to check 
> if hit the 15,000 API operations per day?*
>
> >> Kindly note that the API request and operation are different. 1 request 
> can have many operations such as 
> *OfflineUserDataJobService.AddOfflineUserDataJobOperations* 
> 
>  
> can consume 10,000 operations in one request. However, using Google Ads API 
> there is no way to calculate the consumed API operations count. 
>
> Regards,
> [image: Google Logo] 
> Yasar 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2gQH50:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/75a5c684-ab81-49e2-85c2-132796e14af1n%40googlegroups.com.

Re: INTERNAL ERROR occur get Metrics and Campaign Data using Google Ads API V10 version

['changhong yun' via Google Ads API and AdWords API Forum]

Hi Yasar, Nirmita and Team,

 Based on my checking and understanding, for our per hour job, we just 
loop our available google accounts (21) and for each google account, we 
just execute 3 requests.

That means, if what my understanding is correct. We just have at most 21 * 
3 = 63 requests per hour. Please refer to our requests as below:

Even in summary for one day, we have 63 * 24 = 1512 requests,  less than 
the total maximum 15,000 requests. hmmm... I am not for sure why hit this 
issue?
Meanwhile could you help check below two questions, thank you very much~
 a. If no data for API request return, does it still mean one API 
operation and count into maximum requests?
 b. How to calculate the API requests total count from my side to check 
if hit the 15,000 API operations per day?

Google Ads Query:

Request 1:

*static* *final* String *CAMPAIGN_INFO* = "SELECT" +

" customer.descriptive_name," +

" campaign.name," +

" customer.id," +

" campaign.id," +

" ad_group.id," +

" ad_group.name," +

" ad_group_ad.ad.id," +

" ad_group_ad.ad.name" +

" FROM ad_group_ad";

Request 2:

*static* *final* String *CAMPAIGN_CONVERSION* = "SELECT" +

" customer.descriptive_name," +

" campaign.name," +

" customer.id," +

" campaign.id," +

" ad_group.id," +

" ad_group.name," +

" ad_group_ad.ad.id," +

" ad_group_ad.ad.name," +

" metrics.cost_micros," +

" metrics.impressions," +

" metrics.average_cpm," +

" metrics.clicks," +

" metrics.average_cpc," +

" metrics.ctr," +

" metrics.video_views," +

" metrics.video_view_rate," +

" metrics.video_quartile_p25_rate," +

" metrics.video_quartile_p50_rate," +

" metrics.video_quartile_p75_rate," +

" metrics.video_quartile_p100_rate," +

" metrics.conversions," +

" metrics.conversions_from_interactions_rate," +

" metrics.cost_per_conversion," +

" metrics.conversions_value" +

" FROM ad_group_ad" +

" WHERE segments.date = '%s'" +

" ORDER BY campaign.id";
Request 3:

*static* *final* String *CAMPAIGN_BUDGET_INFO* = "SELECT" +

" customer.id," +

" campaign.id," +

" campaign_budget.amount_micros" +

" FROM campaign" +

" WHERE segments.date =  '%s'" +

" ORDER BY campaign.id";

Regards,
Aaron.
On Tuesday, December 20, 2022 at 1:52:57 PM UTC+8 adsapi wrote:

> Hi Aaron,
>
> I work with Nirmita. Thanks for getting back to us.
>
> I understand that you have encountered an RESOURCE_EXHAUSTED 
> 
>  
> error, and error message ‘Too many requests. Retry in 900 seconds“. This 
> seems to be that API requests hitting the server aggressively. The server 
> throws this error once it detects that your request has exceeded the system 
> frequency limit. When you retry requests, you may continue using an 
> exponential backoff policy by delaying 5-10 seconds. 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 aggressively. 
>
> Also, you mentioned that you set your batch job hourly to process sync 
> campaign data from Google Platform, but in the above email you provided 
> error logs for the GoogleAdsService/SearchStream API request. So, there 
> seems to be concurrent API requests making calls to Google Ads API at same 
> time, and this is why you encountered said error.
>
> That being said, we suggest setting a reasonable upper bound for the total 
> number of concurrent tasks that are going to make requests (across all 
> processes and machines), and adjusting upward to optimize your throughput 
> without exceeding the rate limit is recommended. Otherwise, you may 
> possibly experience the exceeding rate limits that the client app is 
> spawning an excessive number of parallel tasks since we don't limit the 
> number of parallel requests a client app can have, this can easily exceed 
> the Requests Per Second limit at the developer token level. However, 
> Throttles can be implemented at the consumer side by limiting the number of 
> concurrent consumers, or implement rate limiters or throttlers for either 
> the producers or consumers.For more information, you may refer to this 
> throttling QPS from the client side (check out *Throttling and rate 
> limiters* 
> 
> ). 

Re: INTERNAL ERROR occur get Metrics and Campaign Data using Google Ads API V10 version

['changhong yun' via Google Ads API and AdWords API Forum]

Hi Team,

 Thanks for your feedback. we will make further checking on these.

 Meanwhile, could you help check the cause as below two failed request 
today, not for sure the error reason as mentioned

Request

---

MethodName: google.ads.googleads.v12.services.GoogleAdsService/SearchStream

Endpoint: googleads.googleapis.com:443

Headers: {developer-token=REDACTED, login-customer-id=5693729523, 
x-goog-api-client=gl-java/17.0.2 gccl/22.0.0 gapic/22.0.0 gax/2.12.2 
grpc/1.44.0 pb/3.19.6}

Body: customer_id: "1161207172"

query: "SELECT customer.id, campaign.id, campaign_budget.amount_micros FROM 
campaign WHERE segments.date =  \'2022-12-21\' ORDER BY campaign.id"



Response



Headers: 
Metadata(content-type=application/grpc,request-id=UprDhyB4aNklsoPcyhKigQ,date=Wed,
 
21 Dec 2022 06:01:05 GMT,alt-svc=h3=":443"; ma=2592000,h3-29=":443"; 
ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443"; 
ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v="46,43")

Body: null

Failure message: errors {

  error_code {

internal_error: INTERNAL_ERROR

  }

  message: "An internal error has occurred."

}

request_id: "*UprDhyB4aNklsoPcyhKigQ*"


Status: Status{code=INTERNAL, description=Internal error encountered., 
cause=null}.

date:2022-12-21T15:01:05.574+09:00thread:maintrack:level:ERROR 
  
 
logger:com.rakuten.rmp.connect.sync.domain.service.googleads.GoogleAdsReaderServiceImpl
 
   message:Cannot get Google API Ads - ex_account_id: 1161207172

com.google.ads.googleads.v12.errors.GoogleAdsException: errors {

  error_code {

internal_error: INTERNAL_ERROR

  }

  message: "An internal error has occurred."

}

request_id: "UprDhyB4aNklsoPcyhKigQ"


   at 
com.google.ads.googleads.v12.errors.GoogleAdsException$Factory.createException(GoogleAdsException.java:42)

   at 
com.google.ads.googleads.v12.errors.GoogleAdsException$Factory.createException(GoogleAdsException.java:34)

   at 
com.google.ads.googleads.lib.stubs.exceptions.BaseGoogleAdsException$Factory.createGoogleAdsException(BaseGoogleAdsException.java:105)

   at 
com.google.ads.googleads.lib.callables.GoogleAdsExceptionTransformation.transform(GoogleAdsExceptionTransformation.java:39)

   at 
com.google.ads.googleads.lib.stubs.callables.ExceptionTransformingServerStreamingCallable$ExceptionTransformingStreamObserver.onError(ExceptionTransformingServerStreamingCallable.java:71)

   at 
com.google.api.gax.tracing.TracedResponseObserver.onError(TracedResponseObserver.java:103)

   at 
com.google.api.gax.rpc.RetryingServerStreamingCallable$1.onFailure(RetryingServerStreamingCallable.java:99)

   at com.google.api.core.ApiFutures$1.onFailure(ApiFutures.java:68)

   at 
com.google.common.util.concurrent.Futures$CallbackListener.run(Futures.java:1100)

   at 
com.google.common.util.concurrent.DirectExecutor.execute(DirectExecutor.java:31)

   at 
com.google.common.util.concurrent.AbstractFuture.executeListener(AbstractFuture.java:1277)

   at 
com.google.common.util.concurrent.AbstractFuture.complete(AbstractFuture.java:1038)

   at 
com.google.common.util.concurrent.AbstractFuture.setException(AbstractFuture.java:808)

   at 
com.google.api.gax.retrying.BasicRetryingFuture.handleAttempt(BasicRetryingFuture.java:200)

   at 
com.google.api.gax.retrying.CallbackChainRetryingFuture$AttemptCompletionListener.handle(CallbackChainRetryingFuture.java:135)

   at 
com.google.api.gax.retrying.CallbackChainRetryingFuture$AttemptCompletionListener.run(CallbackChainRetryingFuture.java:117)

   at 
com.google.common.util.concurrent.DirectExecutor.execute(DirectExecutor.java:31)

   at 
com.google.common.util.concurrent.AbstractFuture.executeListener(AbstractFuture.java:1277)

   at 
com.google.common.util.concurrent.AbstractFuture.complete(AbstractFuture.java:1038)

   at 
com.google.common.util.concurrent.AbstractFuture.setException(AbstractFuture.java:808)

   at 
com.google.api.core.AbstractApiFuture$InternalSettableFuture.setException(AbstractApiFuture.java:95)

   at 
com.google.api.core.AbstractApiFuture.setException(AbstractApiFuture.java:77)

   at 
com.google.api.core.SettableApiFuture.setException(SettableApiFuture.java:52)

   at 
com.google.api.gax.rpc.ServerStreamingAttemptCallable.onAttemptError(ServerStreamingAttemptCallable.java:378)

   at 
com.google.api.gax.rpc.ServerStreamingAttemptCallable.access$600(ServerStreamingAttemptCallable.java:97)

   at 
com.google.api.gax.rpc.ServerStreamingAttemptCallable$2.onErrorImpl(ServerStreamingAttemptCallable.java:249)

   at 
com.google.api.gax.rpc.StateCheckingResponseObserver.onError(StateCheckingResponseObserver.java:86)

   at 
com.google.api.gax.rpc.Watchdog$WatchdogStream.onErrorImpl(Watchdog.java:284)



~~

Request

---

MethodName: google.ads.googleads.v12.services.GoogleAdsService/SearchStream

Endpoint: googleads.googleapis.com:443

Headers: {developer-token=REDACTED, login-customer-id=5693729523, 
x-goog-api-client=gl-java/17.0.2 

Re: INTERNAL ERROR occur get Metrics and Campaign Data using Google Ads API V10 version

['changhong yun' via Google Ads API and AdWords API Forum]

Hi Team,

 Thanks for your feedback, actually we set our batch job hourly to 
process sync campaign data from Google Platform. while sometimes it hit the 
issue in the morning, sometimes it failed in the afternoon or even the 
night. If it goes with your says for exceeding the 15,000 operational 
requests, it should be happened in the late of each day.  Could you help 
check our requests provided in detail. thank you very much.

 Meanwhile could you advise how to proceed this "setting up short 
delays between requests" ? Thank you~

Regards,
Aaron.

On Thursday, December 15, 2022 at 12:31:55 AM UTC+8 adsapi wrote:

> Hi,
>
> Thank you for reaching out to the Google Ads API support team.
>
> We are able to get response of your query.
>
> Kindly note that the RESOURCE_EXHAUSTED 
> 
>  error 
> generally occurs when you are sending too many requests in a short period 
> of time. The server throws this error once it detects that your request has 
> exceeded the system frequency limit. I would recommend setting up short 
> delays between requests or combine more operations in fewer requests.
>
> Please refer to the Best practices guide 
> 
>  to 
> optimize the efficiency and performance. Also, this may occur if you have 
> already exceeded the daily limit of 15,000 API operations per day. You may 
> refer to this documentation 
> 
>  for 
> the quota you need to consider daily when performing requests using the 
> API. It says that the basic access level allows the developer token to 
> execute up to 15,000 operational requests per day and 1,000 get operations 
> per day only.
>
> Thanks, 
> [image: Google Logo] 
> Nirmita 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2gQH50:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/5cf12740-5d36-4ee2-8f3a-ef00482afe3fn%40googlegroups.com.

Re: INTERNAL ERROR occur get Metrics and Campaign Data using Google Ads API V10 version

['changhong yun' via Google Ads API and AdWords API Forum]

Hi Team, 

 As advised, we add the mandatory logging configuration into our system.

 And today we hit the exception as below, could you help provide some 
solutions or work around to escape these exceptions, thank you very much

date:2022-12-14T18:02:42.133+09:00thread:grpc-default-executor-3   
 track:level:WARN   
 logger:com.google.ads.googleads.lib.request.summarymessage:FAILURE 
REQUEST SUMMARY. Method: 
google.ads.googleads.v12.services.GoogleAdsService/SearchStream, Endpoint: 
googleads.googleapis.com:443, CustomerID: 3258900403, RequestID: 
89crmlX3fGKZSaQkxlJgRg, ResponseCode: RESOURCE_EXHAUSTED, Fault: Resource 
has been exhausted (e.g. check quota)..

date:2022-12-14T18:02:42.160+09:00thread:grpc-default-executor-3   
 track:level:INFOlogger:com.google.ads.googleads.lib.request.detail 
   message:FAILURE REQUEST DETAIL.

Request

---

MethodName: google.ads.googleads.v12.services.GoogleAdsService/SearchStream

Endpoint: googleads.googleapis.com:443

Headers: {developer-token=REDACTED, login-customer-id=5693729523, 
x-goog-api-client=gl-java/17.0.2 gccl/22.0.0 gapic/22.0.0 gax/2.12.2 
grpc/1.44.0 pb/3.19.6}

Body: customer_id: "3258900403"

query: "SELECT customer.descriptive_name, campaign.name, customer.id, 
campaign.id, ad_group.id, ad_group.name, ad_group_ad.ad.id, 
ad_group_ad.ad.name, metrics.cost_micros, metrics.impressions, 
metrics.average_cpm, metrics.clicks, metrics.average_cpc, metrics.ctr, 
metrics.video_views, metrics.video_view_rate, 
metrics.video_quartile_p25_rate, metrics.video_quartile_p50_rate, 
metrics.video_quartile_p75_rate, metrics.video_quartile_p100_rate, 
metrics.conversions, metrics.conversions_from_interactions_rate, 
metrics.cost_per_conversion, metrics.conversions_value FROM ad_group_ad 
WHERE segments.date = \'2022-12-14\' ORDER BY campaign.id"



Response



Headers: 
Metadata(content-type=application/grpc,request-id=89crmlX3fGKZSaQkxlJgRg,date=Wed,
 
14 Dec 2022 09:02:42 GMT,alt-svc=h3=":443"; ma=2592000,h3-29=":443"; 
ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443"; 
ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v="46,43")

Body: null

Failure message: errors {

  error_code {

quota_error: RESOURCE_EXHAUSTED

  }

  message: "Too many requests. Retry in 900 seconds."

}

request_id: "89crmlX3fGKZSaQkxlJgRg"


Status: Status{code=RESOURCE_EXHAUSTED, description=Resource has been 
exhausted (e.g. check quota)., cause=null}.

date:2022-12-14T18:02:42.390+09:00thread:maintrack:level:ERROR 
  
 
logger:com.rakuten.rmp.connect.sync.domain.service.googleads.GoogleAdsReaderServiceImpl
 
   message:Cannot get Google API Ads - ex_account_id: 3258900403

com.google.ads.googleads.v12.errors.GoogleAdsException: errors {

  error_code {

quota_error: RESOURCE_EXHAUSTED

  }

  message: "Too many requests. Retry in 900 seconds."

}

Regards,

Aaron.

On Thursday, December 1, 2022 at 10:49:38 PM UTC+8 adsapi wrote:

> Hello,
>
> Thank you for providing several examples of the issue. However, if you can 
> reply privately with the complete request and response, including request 
> headers, this will help us investigate the issue, and any issues there may 
> be with your request. 
>
> Thanks,
>
> [image: Google Logo] 
> Matt 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2gQH50:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/1f1bec12-e373-4c22-878e-8c968688f563n%40googlegroups.com.

Re: INTERNAL ERROR occur get Metrics and Campaign Data using Google Ads API V10 version

['changhong yun' via Google Ads API and AdWords API Forum]

Hi Team,

  Today we hit lots of the same issues in our system, please refer to 
below logs

date:*2022-12-01T19:26:33.122+09:00*
- Google Account: *1154526700*
com.google.ads.googleads.v10.errors.GoogleAdsException: errors {
error_code {
internal_error: INTERNAL_ERROR
}
message: "An internal error has occurred."
}
request_id: "*--e13xxiS1-WN3nl4mJE4w*"



date:*2022-12-01T18:56:57.653+09:00*
- ex_account_id: *5156847529*
com.google.ads.googleads.v10.errors.GoogleAdsException: errors {
error_code {
internal_error: INTERNAL_ERROR
}
message: "An internal error has occurred."
}
request_id: "*d10d4wNAsF30asj7wAWimw*"



date:*2022-12-01T18:56:56.680+09:00*
- ex_account_id: *9832760617*
com.google.ads.googleads.v10.errors.GoogleAdsException: errors {
error_code {
internal_error: INTERNAL_ERROR
}
message: "An internal error has occurred."
}
request_id: "*JLxlA6Y5tT4qzOL51hitPw*"

@

date:*2022-12-01T18:56:44.679+09:00*
- ex_account_id: *4598968391*
com.google.ads.googleads.v10.errors.GoogleAdsException: errors {
error_code {
internal_error: INTERNAL_ERROR
}
message: "An internal error has occurred."
}
request_id: "*2XwxcB4W5TX5PmWPVgBffg*"

@@@

date:*2022-12-01T18:35:00.100+09:00*
- ex_account_id: *3258900403*
com.google.ads.googleads.v10.errors.GoogleAdsException: errors {
error_code {
internal_error: INTERNAL_ERROR
}
message: "An internal error has occurred."
}
request_id: "*eEWxI-JcG5NBgZvXPSe0pg*"

Kindly please check this, thank you very much.

Regards,
Aaron.

On Friday, November 18, 2022 at 11:31:04 PM UTC+8 adsapi wrote:

> Hi,
>
> You have reached the Google Ads API Forum.
>
> It appears that you have encountered an internal error 
> .
>  
> This error occurs when something unexpected happened while processing the 
> request and the API isn't functioning correctly due to a bug. However, this 
> is transient in nature and the API request will work again when retying it 
> after 30 seconds or some time. That said, please retry your request again 
> to see if this error will still occur.
>
> For more information before raising this to the rest of my team, could you 
> please tell us how frequently you encounter this internal error ? Also, it 
> would be helpful if you can provide the complete and updated request 
> 
>  and response 
> 
>  logs with requestID 
> 
>  and request header 
> 
>  that 
> generated on your end after retrying on your end. This information will 
> help our team to further check the said error. If you haven't 
> yet, logging can be enabled by navigating to the *Client libraries > Your 
> client library (ex. Java) > Logging* documentation, which you can access 
> from this link 
> .
>
> For privacy purposes, you can provide it via the Reply
> * privately to author* option. If this option is not available, then send 
> it instead on this email address googleadsapi-supp...@google.com.
>
> Best regards,
> [image: Google Logo] 
> Jinky 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2gQH50:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/f4cec2d9-e73b-4f1e-a398-850c9f99f1acn%40googlegroups.com.

INTERNAL ERROR occur get Metrics and Campaign Data using Google Ads API V10 version

['changhong yun' via Google Ads API and AdWords API Forum]

Hello sir

   we are trying to get Display Ads campaign and Metrics data using 
Google Ads V10 API , but occasionally  it will give me INTERNAL ERROR , and 
i can't find why this such type of error has been come

com.google.ads.googleads.v10.errors.GoogleAdsException: errors {

  error_code {

internal_error: INTERNAL_ERROR

  }

  message: "An internal error has occurred."

}

request_id: "EDSPIdhbp3lSjX29k4INQg"


   at 
com.google.ads.googleads.v10.errors.GoogleAdsException$Factory.createException(GoogleAdsException.java:42)

   at 
com.google.ads.googleads.v10.errors.GoogleAdsException$Factory.createException(GoogleAdsException.java:34)

   at 
com.google.ads.googleads.lib.stubs.exceptions.BaseGoogleAdsException$Factory.createGoogleAdsException(BaseGoogleAdsException.java:105)

   at 
com.google.ads.googleads.lib.callables.GoogleAdsExceptionTransformation.transform(GoogleAdsExceptionTransformation.java:39)

   at 
com.google.ads.googleads.lib.stubs.callables.ExceptionTransformingServerStreamingCallable$ExceptionTransformingStreamObserver.onError(ExceptionTransformingServerStreamingCallable.java:71)

   at 
com.google.api.gax.tracing.TracedResponseObserver.onError(TracedResponseObserver.java:103)

   at 
com.google.api.gax.rpc.RetryingServerStreamingCallable$1.onFailure(RetryingServerStreamingCallable.java:99)

   at com.google.api.core.ApiFutures$1.onFailure(ApiFutures.java:68)

   at 
com.google.common.util.concurrent.Futures$CallbackListener.run(Futures.java:1041)

   at 
com.google.common.util.concurrent.DirectExecutor.execute(DirectExecutor.java:30)

   at 
com.google.common.util.concurrent.AbstractFuture.executeListener(AbstractFuture.java:1215)

   at 
com.google.common.util.concurrent.AbstractFuture.complete(AbstractFuture.java:983)

   at 
com.google.common.util.concurrent.AbstractFuture.setException(AbstractFuture.java:771)

   at 
com.google.api.gax.retrying.BasicRetryingFuture.handleAttempt(BasicRetryingFuture.java:200)

   at 
com.google.api.gax.retrying.CallbackChainRetryingFuture$AttemptCompletionListener.handle(CallbackChainRetryingFuture.java:135)

   at 
com.google.api.gax.retrying.CallbackChainRetryingFuture$AttemptCompletionListener.run(CallbackChainRetryingFuture.java:117)

   at 
com.google.common.util.concurrent.DirectExecutor.execute(DirectExecutor.java:30)

   at 
com.google.common.util.concurrent.AbstractFuture.executeListener(AbstractFuture.java:1215)

   at 
com.google.common.util.concurrent.AbstractFuture.complete(AbstractFuture.java:983)

   at 
com.google.common.util.concurrent.AbstractFuture.setException(AbstractFuture.java:771)

   at 
com.google.api.core.AbstractApiFuture$InternalSettableFuture.setException(AbstractApiFuture.java:95)

   at 
com.google.api.core.AbstractApiFuture.setException(AbstractApiFuture.java:77)

   at 
com.google.api.core.SettableApiFuture.setException(SettableApiFuture.java:52)

   at 
com.google.api.gax.rpc.ServerStreamingAttemptCallable.onAttemptError(ServerStreamingAttemptCallable.java:378)

   at 
com.google.api.gax.rpc.ServerStreamingAttemptCallable.access$600(ServerStreamingAttemptCallable.java:97)

   at 
com.google.api.gax.rpc.ServerStreamingAttemptCallable$2.onErrorImpl(ServerStreamingAttemptCallable.java:249)

   at 
com.google.api.gax.rpc.StateCheckingResponseObserver.onError(StateCheckingResponseObserver.java:86)

   at 
com.google.api.gax.rpc.Watchdog$WatchdogStream.onErrorImpl(Watchdog.java:284)

   at 
com.google.api.gax.rpc.StateCheckingResponseObserver.onError(StateCheckingResponseObserver.java:86)

   at 
com.google.api.gax.grpc.ExceptionResponseObserver.onErrorImpl(ExceptionResponseObserver.java:84)

   at 
com.google.api.gax.rpc.StateCheckingResponseObserver.onError(StateCheckingResponseObserver.java:86)

   at 
com.google.api.gax.grpc.GrpcDirectStreamController$ResponseObserverAdapter.onClose(GrpcDirectStreamController.java:149)

   at 
io.grpc.PartialForwardingClientCallListener.onClose(PartialForwardingClientCallListener.java:39)

   at 
io.grpc.ForwardingClientCallListener.onClose(ForwardingClientCallListener.java:23)

   at 
io.grpc.ForwardingClientCallListener$SimpleForwardingClientCallListener.onClose(ForwardingClientCallListener.java:40)

   at 
com.google.ads.googleads.lib.logging.LoggingInterceptor$1$1.onClose(LoggingInterceptor.java:113)

   at 
io.grpc.internal.DelayedClientCall$DelayedListener$3.run(DelayedClientCall.java:463)

   at 
io.grpc.internal.DelayedClientCall$DelayedListener.delayOrExecute(DelayedClientCall.java:427)

   at 
io.grpc.internal.DelayedClientCall$DelayedListener.onClose(DelayedClientCall.java:460)

   at io.grpc.internal.ClientCallImpl.closeObserver(ClientCallImpl.java:557)

   at io.grpc.internal.ClientCallImpl.access$300(ClientCallImpl.java:69)

   at 
io.grpc.internal.ClientCallImpl$ClientStreamListenerImpl$1StreamClosed.runInternal(ClientCallImpl.java:738)

   at 
io.grpc.internal.ClientCallImpl$ClientStreamListenerImpl$1StreamClosed.runInContext(ClientCallImpl.java:717)

   at