topic Re: Loading excel data from sharepoint gives error in Qlikview? in QlikView

Loading excel data from sharepoint gives error in Qlikview?

Wed, 01 Mar 2017 09:27:57 GMT

Hello Everyone,

In my application I am pulling data from Sharepoint URL(Site is Https).

There are about four excel files available in this URL([https: // sharepoint. mydomain.com/ files /filename *.xls).

In the windows server when I am trying to load the excel data using the qlikview desktop reload Reload button I am getting the following error .

File not found error .

Cannot open file :’’

System error:Filesystem::FindImpl FindFirst call:Incorrect function

Just to say here the share point location URL are correctly mentioned .Also the files are exists in the said location with the data.

2)In the Qlikview QVW file using the Windows Explorer option to point to the sharepoint location URL for reading the excel data.

3)Since the sharepoint site is https we are mentioning in the sharepoint URL @SSL as below

\\XX.XXXX.XXX@SSL\Source\Qlikview\1.Dev\FileNam e *.xls

If I am running the same qvw file using the service account (Service account have been added in the sharepoint site ,it is having the contributor level privileges ) in QMC,I get the following error message .

TaskLog.txt :

************

Error The task "Source Documents/XXXXXX/QVD_Load_XXXXX.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.ThreadPoolJobStillRunningException: Aborting reload. Error: QDSMain.TaskResult || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- End of inner exception stack trace --- || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(CurrentExecutionArgs args)

20170228T070005.213+0100 Information Task Execute Duration=00:00:05.1249672

20170228T070005.213+0100 Information TaskResult.status=Finished

20170228T070005.244+0100 Information Notifying all triggers of new state: "FinishedWithErrors"...

20170228T070005.244+0100 Information Notifying all triggers of new state: "FinishedWithErrors" – Completed

DocumentLog.txt

**************

Error: Cannot open file: '\\*****@SSL\XXXXXX\Qlikview source\1. Development\FileName Input *.xls'

20170228T070004.478+0100 Information 2017-02-28 07:00:03 Execution Failed

20170228T070004.494+0100 Information 2017-02-28 07:00:03 Execution finished.

Please help !!!

Re: Loading excel data from sharepoint gives error in Qlikview?

sureshsindhigi — Wed, 01 Mar 2017 10:00:20 GMT

Hi Nancy,

Please try with the following syntax, change file name & sheet name accordingly

FROM

[https://sharepoint.mydomain.com/ files/filename.xls]

(ooxml, embedded labels, table is SHEETNAME)

Regards,

Suresh Sindhigi.

Re: Loading excel data from sharepoint gives error in Qlikview?

avinashelite — Wed, 01 Mar 2017 10:30:27 GMT

Could you share the script and QVW log file not the server log

Re: Loading excel data from sharepoint gives error in Qlikview?

Mon, 06 Mar 2017 10:00:10 GMT

Hi Avinash,

Part of the log file is above.

Thanks,

Re: Loading excel data from sharepoint gives error in Qlikview?

Mon, 06 Mar 2017 10:00:42 GMT

It did not work suresh !!

Re: Loading excel data from sharepoint gives error in Qlikview?

avinashelite — Mon, 06 Mar 2017 10:17:53 GMT

As per the Log,

*Check the file is available with the name mentioned

*Check the path once

*Check if the file has any row of data or not

Re: Loading excel data from sharepoint gives error in Qlikview?

kuba_michalik — Mon, 06 Mar 2017 10:27:15 GMT

I'm not sure if the wildcard (star) syntax is compatible with http URLs (could be it works only for local/UNC paths).

If you try loading a specific Excel file, does it work?

Re: Loading excel data from sharepoint gives error in Qlikview?

Mon, 06 Mar 2017 15:19:20 GMT

Hi Avinash,

i Confirm

1)file is available with the name mentioned .

2)Path is correct one .i have verified now even.

3)Data is there in the sheet .

Thanks,

Re: Loading excel data from sharepoint gives error in Qlikview?

Mon, 06 Mar 2017 15:20:32 GMT

Hi Jakub,

I have just tried with the complete file name ,by removing the * character ....

but no luck .

Thanks,

Nancy