Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
FPellissier1625558358
Partner - Contributor III
Partner - Contributor III

tGoogleAdWordsReport : IllegalArgumentException, NullPointerException, ...

Hello,

 

 

I download the last version of this component and follow all the instructions from the google help pages to create a service account ( link : https://developers.google.com/google-ads/api/docs/oauth/service-accounts# setting_up_service_account_access )

 

But I still cannot configure it correctly, I have the following error, that I use the json file or the p12 key to configure the component :

 

 

java.lang.IllegalArgumentException

at com.google.api.client.repackaged.com.google.common.base.Preconditions.checkArgument(Preconditions.java:111)

at com.google.api.client.util.Preconditions.checkArgument(Preconditions.java:37)

at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.<init>(GoogleCredential.java:323)

at com.google.api.client.googleapis.auth.oauth2.GoogleCredential$Builder.build(GoogleCredential.java:539)

at de.jlo.talendcomp.google.adwords.AdWordsReport.authorizeWithServiceAccount(AdWordsReport.java:166)

at de.jlo.talendcomp.google.adwords.AdWordsReport.initializeAdWordsSession(AdWordsReport.java:265)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.tGoogleAdWordsReport_1Process(FPE_GoogleAds.java:522)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.runJobInTOS(FPE_GoogleAds.java:1196)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.main(FPE_GoogleAds.java:996)

Exception in component tGoogleAdWordsReport_1 (FPE_GoogleAds)

java.lang.NullPointerException

at de.jlo.talendcomp.google.adwords.AdWordsReport.executeQuery(AdWordsReport.java:304)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.tGoogleAdWordsReport_1Process(FPE_GoogleAds.java:543)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.runJobInTOS(FPE_GoogleAds.java:1196)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.main(FPE_GoogleAds.java:996)

[FATAL]: haiku.fpe_googleads_0_1.FPE_GoogleAds - tGoogleAdWordsReport_1 null

java.lang.NullPointerException

at de.jlo.talendcomp.google.adwords.AdWordsReport.executeQuery(AdWordsReport.java:304)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.tGoogleAdWordsReport_1Process(FPE_GoogleAds.java:543)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.runJobInTOS(FPE_GoogleAds.java:1196)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.main(FPE_GoogleAds.java:996)

 

 

Did someone knows that I can do to make it works ?

Labels (2)
4 Replies
gjeremy1617088143
Master
Master

Hi, could you send a screen of the advanced settings of the component and a screen of your job ?

Send me Love and Kudos

FPellissier1625558358
Partner - Contributor III
Partner - Contributor III
Author

Here are the two screens. The used schema is the 2 columns of the AWQL query

 

 

0695b00000GgLFFAA3.jpg0695b00000GgLFKAA3.jpg

gjeremy1617088143
Master
Master

Hi, it's seems an argument is missing or wrong

gjeremy1617088143
Master
Master

hope the documentation could help you :

https://jan-lolling.de/talend/components/help/tGoogleAdWordsReport.pdf

 

one other thing i saw is in your query :

you don't have a space before FROM and between REPORT AND during so it can be the issue