Query BillingSetup using PaymentsAccountId - Error Occured

[Suresh Kumar Shenbagam]

Hi,

Following error occured when I try to query BillingSetup Resource using PaymentsAccountId. Please find below the request and response,

2020-03-27 00:25:05,324 WARN  [Gax-2] logging.RequestLogger (RequestLogger.java:159) - FAILURE REQUEST SUMMARY. Method: google.ads.googleads.v3.services.GoogleAdsService/Search, Endpoint: googleads.googleapis.com:443, CustomerID: xxxxxx, RequestID: 7FIFU6JVpYq30aRreYyT0w, ResponseCode: INTERNAL, Fault: Internal error encountered..

2020-03-27 00:25:06,235 INFO  [Gax-2] logging.RequestLogger (RequestLogger.java:157) - FAILURE REQUEST DETAIL.

Request

-------

MethodName: google.ads.googleads.v3.services.GoogleAdsService/Search

Endpoint: googleads.googleapis.com:443

Headers: {developer-token=REDACTED, login-customer-id=xxxxxxx, x-goog-api-client=gl-java/1.8.0_202 gapic/ gax/1.50.1 grpc/1.25.0}

Body: customer_id: "xxxxxxx"

query: "SELECT\r\n\t billing_setup.resource_name\r\nFROM\r\n\tbilling_setup\r\nWHERE\r\n\tbilling_setup.payments_account_info.payments_account_id = \'xxxx-xxxx-xxxx-xxxx\'\r\nLIMIT\r\n\t100"

page_size: 1000

Response

--------

Headers: Metadata(content-type=application/grpc,request-id=7FIFU6JVpYq30aRreYyT0w,date=Thu, 26 Mar 2020 18:55:04 GMT,alt-svc=quic=":443"; ma=2592000; v="46,43",h3-Q050=":443"; ma=2592000,h3-Q049=":443"; ma=2592000,h3-Q048=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000,h3-T050=":443"; ma=2592000)

Body: null

Failure message: null

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

Exception in thread "main" com.google.api.gax.rpc.InternalException: io.grpc.StatusRuntimeException: INTERNAL: Internal error encountered.

at com.google.api.gax.rpc.ApiExceptionFactory.createException(ApiExceptionFactory.java:67)

at com.google.api.gax.grpc.GrpcApiExceptionFactory.create(GrpcApiExceptionFactory.java:72)

at com.google.api.gax.grpc.GrpcApiExceptionFactory.create(GrpcApiExceptionFactory.java:60)

at com.google.api.gax.grpc.GrpcExceptionCallable$ExceptionTransformingFuture.onFailure(GrpcExceptionCallable.java:97)

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

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

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

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

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

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

at io.grpc.stub.ClientCalls$GrpcFuture.setException(ClientCalls.java:520)

at io.grpc.stub.ClientCalls$UnaryStreamToFuture.onClose(ClientCalls.java:495)

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:111)

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 io.grpc.internal.CensusStatsModule$StatsClientInterceptor$1$1.onClose(CensusStatsModule.java:700)

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 io.grpc.internal.CensusTracingModule$TracingClientInterceptor$1$1.onClose(CensusTracingModule.java:399)

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

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

at io.grpc.internal.ClientCallImpl$ClientStreamListenerImpl.close(ClientCallImpl.java:630)

at io.grpc.internal.ClientCallImpl$ClientStreamListenerImpl.access$700(ClientCallImpl.java:518)

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

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

at io.grpc.internal.ContextRunnable.run(ContextRunnable.java:37)

at io.grpc.internal.SerializingExecutor.run(SerializingExecutor.java:123)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Suppressed: com.google.api.gax.rpc.AsyncTaskException: Asynchronous task failed

at com.google.api.gax.rpc.ApiExceptions.callAndTranslateApiException(ApiExceptions.java:57)

at com.google.api.gax.rpc.UnaryCallable.call(UnaryCallable.java:112)

at com.google.ads.googleads.v3.services.GoogleAdsServiceClient.search(GoogleAdsServiceClient.java:253)

at com.google.ads.googleads.examples.billing.AddBillingSetup.runExample(AddBillingSetup.java:142)

at com.google.ads.googleads.examples.billing.AddBillingSetup.main(AddBillingSetup.java:87)

Caused by: io.grpc.StatusRuntimeException: INTERNAL: Internal error encountered.

at io.grpc.Status.asRuntimeException(Status.java:533)

... 28 more

How can I retrieve the billing setup for the paymentsAccountId? Please let me know, if you need the customer id and payments account id to analyze the issue. I will reply privately.

Suresh

[Google Ads API Forum Advisor Prod]

Hi Suresh,

Thank you for reaching out. Can you please share the un-masked logs via Reply privately to author so that I can further investigate the issue?

Regards,
Mitchell
Google Ads API Team

ref:_00D1U1174p._5001UXWstQ:ref

[Suresh Kumar Shenbagam]

Hi Mitchell,

Could you please provide an update on this issue?

Suresh.

[Google Ads API Forum Advisor Prod]

Hi Suresh,

We're investigating this. 
Based on what our team has tried, it seems if you drop the WHERE clause, it would be able to retrieve some results?
Is that true on your side?

Best,
Thanet, Google Ads API Team

ref:_00D1U1174p._5001UXWstQ:ref

[Suresh Kumar Shenbagam]

Hi Thanet,

Thank you for the response.

Yes, it is working fine when I drop the WHERE clause. But I need to retrieve the Billing Setup resource name for a particular payments Account ID.

Suresh

[Google Ads API Forum Advisor Prod]

Hello Suresh,

Thanks for your reply.
We'll give you an update once we know more about the issue.