SocketTimeoutException while calling list API on publisher profiles

[Karthikeyan R]

Hi,

 

I am Karthikeyan from Adobe Advertising team. We are working on migrating AdExchangeBuyer II APIs to Marketplace APIs before it gets deprecated completely, meanwhile we are still using the former APIs to fetch deals and publisher profiles from Google. Last couple of days, we are seeing the following error response from publisher profiles list API. Please let us know what could’ve gone wrong and what is the solution to fix this error.

 

API: https://developers.google.com/authorized-buyers/apis/reference/rest/v2beta1/accounts.publisherProfiles/list

 

2023-07-18T09:30:51,056Z [ERROR] [default-1-m_mVxj2KOB3P4QHf8-xNIw] c.t.a.p.adx.AdxPublisherFetcher - java.net.SocketTimeoutException: Read timed out                    at java.base/java.net.SocketInputStream.$$YJP$$socketRead0(Native Method)                    at java.base/java.net.SocketInputStream.socketRead0(SocketInputStream.java)                    at java.base/java.net.SocketInputStream.socketRead(SocketInputStream.java:115)                    at java.base/java.net.SocketInputStream.read(SocketInputStream.java:168)                    at java.base/java.net.SocketInputStream.read(SocketInputStream.java:140)                    at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:448)                    at java.base/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:68)                    at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1103)                    at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:823)                    at java.base/java.io.BufferedInputStream.fill(BufferedInputStream.java:252)                    at java.base/java.io.BufferedInputStream.read1(BufferedInputStream.java:292)                    at java.base/java.io.BufferedInputStream.read(BufferedInputStream.java:351)                    at java.base/sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:754)                    at java.base/sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:689)                    at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1610)                    at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1515)                    at java.base/java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:527)                    at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:334)                    at com.google.api.client.http.javanet.NetHttpResponse.<init>(NetHttpResponse.java:36)                    at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:149)                    at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:84)                    at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1012)                    at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:514)                    at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:455)                    at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:565)

 

Thanks,

Karthikeyan R.

[Mark Saniscalchi]

Hello Karthikeyan,

Is this an intermittent issue? Are you still impacted? I can run the v2beta1 accounts.publisherProfiles.list method without issues. It looks like your request timed out, so my expectation is that this was a temporary issue.

One additional step I could take on my end is to check whether any errors are logged on our end for requests coming from your account, but I would need your account ID. I wouldn't recommend posting that publicly on this support forum, so if you'd like me to take a look I'd recommend reaching out to our support alias: adxbuyera...@google.com.

Regards,

Mark

[Karthikeyan R]

Hi Mark,

Thanks for replying. This is an intermittent issue and it's occurring less frequently now. We believe migrating to Marketplace APIs should fix these errors.

Thanks,

Karthikeyan R.

[Mark Saniscalchi]

Hello Karthikeyan,

Sure thing, that is consistent with my expectations given that I haven't heard of significant rises in timeouts. The older v2beta1 Marketplace resources are not in active development and are known to be less stable than the dedicated Marketplace API, so I agree that this probably would be resolved when you migrate. If you happen to have any questions I can assist with during your migration, feel free to reach out.

Regards,

Mark

[Karthikeyan R]

Hi Mark,

Hope you are doing great.

We migrated to Marketplace API last week and we still get these errors while calling list publisher profile API. Could you please take a look and suggest if there is any solution?

Error 1

com.google.api.client.googleapis.json.GoogleJsonResponseException: 500 Internal Server Error

GET https://authorizedbuyersmarketplace.googleapis.com/v1/buyers/89185975/publisherProfiles?pageSize=500&pageToken=COgHEMydnNOs54EDGMydnNOs54ED

{

  "code" : 500,

  "errors" : [ {

    "domain" : "global",

    "message" : "UNEXECUTABLE: Unable to fetch data from table:mobile_application_catalog",

    "reason" : "backendError"

  } ],

  "message" : "UNEXECUTABLE: Unable to fetch data from table:mobile_application_catalog",

  "status" : "UNKNOWN"

}

                at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:146)

                at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:118)

                at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:37)

                at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:428)

                at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1111)

                at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:514)

                at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:455)

                at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:565)

                at com.tubemogul.api.partner.adx.AdxPublisherFetcher.fetchRaw(AdxPublisherFetcher.java:64)

 

Error 2:

                at com.tubemogul.api.partner.adx.AdxPublisherFetcher.fetchRaw(AdxPublisherFetcher.java:64)

[Authorized Buyers API Forum Advisor]

Hello Karthikeyan,

I think I see a duplicate email, so I'll focus on responding to this thread going forward.

Sorry to hear that you're seeing issues with publisherProfiles after migrating. Given that I can not reproduce, my impression is that this is either account-specific or an infrequently recurring error. The error message suggests that data could not be retrieved while it was being queried internally, so it's highly likely to be some sort of bug on our end. I'll get in touch with the Marketplace API engineering lead and begin an investigation. A few questions that might be helpful to clarify the issue:

• How often would you say an error response is returned?
• Does the error response occur for a particular page?
• Can a retry of the failed API call be successful, or does it consistently fail?

Regards,
Mark

ref:_00D1U1174p._5004Q2pQGuL:ref