Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tGoogleAdWordsReport Exeption

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

Labels (2)
5 Replies
Anonymous
Not applicable
Author

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?
Anonymous
Not applicable
Author

attached screenshot of advance settings


0683p000009MFj2.jpg
Anonymous
Not applicable
Author

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]
Anonymous
Not applicable
Author

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

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.