topic Re: [POC] BigQuery as target , and got a error message "The access token has expired and could not be refreshed Errors" in Qlik Replicate

[POC] BigQuery as target , and got a error message "The access token has expired and could not be refreshed Errors"

Aaron_Liu — Tue, 02 Apr 2024 09:07:05 GMT

Hi Sir,

We in the POC stage, user used the db2 as400 as source and Big Query as target. we got they response they said they meet a error as below JPG (The access token has expired and could not be refreshed Errors).

So..that error mean they between the stop task and the resume task exceed 1 hour?
And tell user to click the "reload target" is the right way?

Thanks.
Aaron 2024-3-27

Re: [POC] BigQuery as target , and got a error message "The access token has expired and could not be refreshed Errors"

john_wang — Wed, 27 Mar 2024 01:55:17 GMT

Hello @Aaron_Liu ,

Thanks for reaching out to Qlik Community!

Looks to me this is because the access token has expired (eg it expires in 24 hours). Please check the access token expiration data in the "Service account key", or ask help from the DBA.

Hope this helps.

John.

Re: [POC] BigQuery as target , and got a error message "The access token has expired and could not be refreshed Errors"

misterlim13 — Wed, 27 Mar 2024 02:19:57 GMT

Hi John,

We are encountering the same issue and this error message pops up in just 1-2 mins after running the task. Any other suggestions? Thank you.

Regards,
Chester

Re: [POC] BigQuery as target , and got a error message "The access token has expired and could not be refreshed Errors"

john_wang — Wed, 27 Mar 2024 02:37:25 GMT

Hello @misterlim13 ,

Are you able to confirm how long of the access token? It seems not an access token issue. Let's try to troubleshoot the issue :

1. How about if you upload the file manually (set internal parameter keepCSVFiles & keepErrorFiles to TRUE)

2. How about the connectivity if we config a 64-bit ODBC DSN and test the connection by using the DSN

3. Please open a support ticket with TARGET_LOAD/TARGET_APPLY set to Verbose, and upload the Diag Packages. BTW, please decrypt the task log files before upload.

Thanks,

John.

Re: [POC] BigQuery as target , and got a error message "The access token has expired and could not be refreshed Errors"

misterlim13 — Wed, 27 Mar 2024 05:27:49 GMT

Hello John,

Thank you for the information. Unfortunately, it is still failing after doing step 1. For step 2, the connection is good as we can choose the BigQuery dataset. I have uploaded the decrypted log file in the link below for step 3.

https://community.qlik.com/t5/crmsupport/casepage/issue-id/00154161/issue-guid/5003z00002owUO5AAM/issue-provider/salesforce.

Appreciate the support!

Regards,
Chester

Re: [POC] BigQuery as target , and got a error message "The access token has expired and could not be refreshed Errors"

john_wang — Wed, 27 Mar 2024 06:35:23 GMT

Hello @misterlim13 ,

Thanks for the update. The upload link is inaccessible. Please open support ticket if you want to upload Diag Packages. Community is public to every visitor, it's not allowed to upload Diag Packages.

BTW, are you meaning you can upload the CSV files manually but it failed in Qlik Replicate task?

thanks,

John.