tGoogleAdWordsReport Exeption

Highlighted
One Star

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

One Star

Re: tGoogleAdWordsReport Exeption

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?
One Star

Re: tGoogleAdWordsReport Exeption

attached screenshot of advance settings


Two Stars

Re: tGoogleAdWordsReport Exeption

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]
One Star

Re: tGoogleAdWordsReport Exeption

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

Re: tGoogleAdWordsReport Exeption

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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download