Loading excel data from sharepoint gives error in Qlikview?

[#1]

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 .

1. 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

1. 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 !!!

[sureshsindhigi]

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.

[avinashelite]

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

[#4]

Hi Avinash,

Part of the log file is above.

Thanks,

[#5]

It did not work suresh !!

[avinashelite]

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

[kuba_michalik]

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?

[#8]

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,

[#9]

Hi Jakub,

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

but no luck .

Thanks,

Nancy