You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-09-12 18:53:34

faisal_mnet
Member
6 posts

faisal_mnet said:

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

Last edited by faisal_mnet (2016-09-12 18:59:11)

Offline

#2 2016-09-12 19:12:44

faisal_mnet
Member
6 posts

faisal_mnet said:

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?

Last edited by faisal_mnet (2016-09-13 20:04:28)

Offline

#3 2016-09-13 20:05:45

faisal_mnet
Member
6 posts

faisal_mnet said:

Re: tGoogleAdWordsReport Exeption

attached screenshot of advance settings


mini_imageedit_2_3729436863.jpg_20160913-1206.jpg

Last edited by faisal_mnet (2016-09-13 20:06:46)

Offline

#4 2016-09-14 05:43:48

ChimaeraE
Member
17 posts

ChimaeraE said:

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]

Offline

#5 2016-09-14 16:46:49

faisal_mnet
Member
6 posts

faisal_mnet said:

Re: tGoogleAdWordsReport Exeption

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

Offline

#6 2016-09-15 01:13:02

ChimaeraE
Member
17 posts

ChimaeraE said:

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.

Last edited by ChimaeraE (2016-09-15 03:04:16)

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy