topic Re: tGoogleAdWordsReport Exeption in Talend Studio

tGoogleAdWordsReport Exeption

Anonymous — Mon, 12 Sep 2016 18:53:34 GMT

Hi,
I am trying to load reports from google adwords using tGoogleAdWordsReport, and I keep getting following exception. I divided the job into multiple components, added delays but it works for some calls and the for some calls it does not. I am running it in a loop to get data for last 10 days. any suggestions please?

Exception in component tGoogleAdWordsReport_2
com.google.api.ads.adwords.lib.utils.ReportException: Problem sending data to report download server.
at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.downloadReport(AdHocReportDownloadHelperImpl.java:85)
at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.downloadReport(AdHocReportDownloadHelperImpl.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.google.api.ads.common.lib.utils.AdsUtilityInvocationHandler.handleInvocation(AdsUtilityInvocationHandler.java:46)
at com.google.common.reflect.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:87)
at com.sun.proxy.$Proxy13.downloadReport(Unknown Source)
at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelper.downloadReport(AdHocReportDownloadHelper.java:49)
[statistics] disconnected
at com.google.api.ads.adwords.lib.utils.v201607.ReportDownloader.downloadReport(ReportDownloader.java:88)
at de.jlo.talendcomp.google.adwords.AdWordsReport.executeQuery(AdWordsReport.java:309)
at smash.smashadwordsandga_0_1.smashAdwordsAndGA.tGoogleAdWordsReport_2Process(smashAdwordsAndGA.java:1286)
at smash.smashadwordsandga_0_1.smashAdwordsAndGA.tJava_2Process(smashAdwordsAndGA.java:980)
at smash.smashadwordsandga_0_1.smashAdwordsAndGA.tLoop_1Process(smashAdwordsAndGA.java:813)
at smash.smashadwordsandga_0_1.smashAdwordsAndGA.tJava_1Process(smashAdwordsAndGA.java:648)
at smash.smashadwordsandga_0_1.smashAdwordsAndGA.runJobInTOS(smashAdwordsAndGA.java:1965)
at smash.smashadwordsandga_0_1.smashAdwordsAndGA.main(smashAdwordsAndGA.java:1748)
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:170)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)
at sun.security.ssl.InputRecord.read(InputRecord.java:503)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:973)
at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:930)
at sun.security.ssl.AppInputStream.read(AppInputStream.java:105)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
at java.io.BufferedInputStream.read1(BufferedInputStream.java:286)
at java.io.BufferedInputStream.read(BufferedInputStream.java:345)
at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:704)
at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:647)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1536)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
at com.google.api.client.http.javanet.NetHttpResponse.<init>(NetHttpResponse.java:37)
at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:94)
at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:981)
at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.downloadReport(AdHocReportDownloadHelperImpl.java:69)

... 17 more

Re: tGoogleAdWordsReport Exeption

Anonymous — Mon, 12 Sep 2016 19:12:44 GMT

need to set timeouts in advanced settings, but seems like it does not have "Timeout" in advance settings that i see in documentation. any suggestions please?

Re: tGoogleAdWordsReport Exeption

Anonymous — Tue, 13 Sep 2016 20:05:45 GMT

attached screenshot of advance settings

Re: tGoogleAdWordsReport Exeption

Anonymous — Wed, 14 Sep 2016 05:43:48 GMT

hi,
can I ask for your help on the tGoogleAdWordsReport set up? I have bee trying to use this component and followed the steps but I keep on getting an error. Please see below. Do I need to provide talend access to google adwords? if yes, how do I do that?
Please help. Thank you!

Starting job test at 21:38 13/09/2016.
[statistics] connecting to socket on port 3572
[statistics] connected
com.google.api.client.auth.oauth2.TokenResponseException: 400 Bad Request
{
"error" : "invalid_grant",
"error_description" : "Invalid JWT Signature."
}
at com.google.api.client.auth.oauth2.TokenResponseException.from(TokenResponseException.java:105)
at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:287)
at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307)
at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:384)
at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489)
at de.jlo.talendcomp.google.adwords.AdWordsReport.initializeAdWordsSession(AdWordsReport.java:250)
at adw.test_0_1.test.tGoogleAdWordsReport_1Process(test.java:319)
at adw.test_0_1.test.runJobInTOS(test.java:621)
at adw.test_0_1.test.main(test.java:478)
Exception in component tGoogleAdWordsReport_1
java.lang.NullPointerException
at de.jlo.talendcomp.google.adwords.AdWordsReport.executeQuery(AdWordsReport.java:274)
[statistics] disconnected
at adw.test_0_1.test.tGoogleAdWordsReport_1Process(test.java:348)
at adw.test_0_1.test.runJobInTOS(test.java:621)
at adw.test_0_1.test.main(test.java:478)
Job test ended at 21:38 13/09/2016. [exit code=1]

Re: tGoogleAdWordsReport Exeption

Anonymous — Wed, 14 Sep 2016 16:46:49 GMT

I have not faced this problem, but depending on the error it seems like issue with your config.

Re: tGoogleAdWordsReport Exeption

Anonymous — Thu, 15 Sep 2016 01:13:02 GMT

Did you make any modifications on your server time or in any of the files/java files?
If it's okay also, did you add any access to your google adwords account?

did you use the service account or client id for native application?

sorry for the many questions, I'm in a bind right now because Im at a lost here, I couldn't make it work.