Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Santosh_a
New Contributor

Error with google extractor

Hello All,

Recently we have a issue with qilk view google doc extractor using our qlikview service account. When the jobs run from QMC using service account the google doc extractor failing with below error but when if run the script manually with any user ID (QV admin), the job completes successfully and extracts the files from google drive. Could you please help us to solve this issue. 

 

Error log when ran from QMC

2019-02-16 05:30:03: Logging into Google Drive ....
2019-02-16 05:30:03: Login successful.

2019-02-16 05:30:03: Begin reading Google Drive for 'Ref Data' ...
2019-02-16 05:31:44: ERROR: retrieving file: Web request to 'https://accounts.google.com/o/oauth2/token' failed.
2019-02-16 05:31:44: End reading Google Drive.
2019-02-16 05:31:44: Begin sorting result ...
2019-02-16 05:31:44: ERROR: Sorting results Object reference not set to an instance of an object.
2019-02-16 05:31:44: End sorting result.

 

Log with other user ID.

 

2019-02-16 03:45:07: Logging into Google Drive ....
2019-02-16 03:45:08: Login successful.

2019-02-16 03:45:08: Begin reading Google Drive for 'CST performance feedback and actions (Responses)' ...
2019-02-16 03:45:09: Files Found: 1
2019-02-16 03:45:09: End reading Google Drive.
2019-02-16 03:45:09: Begin sorting result ...
2019-02-16 03:45:09: End sorting result.
2019-02-16 03:45:09: Checking for existance of folder . ...
2019-02-16 03:45:09: Folder already exists.