topic Re: Error while loading from SharePoint in QlikView

Error while loading from SharePoint

padmanabhan_ram — Mon, 12 May 2014 13:56:34 GMT

Hi,

I am trying to load a list from SharePoint in QlikView. With Limited load the dashboard refreshes successfully, but with a full load throws an error 'unspecified error on line number.... column number...'.

Could you please help me out on the issue?

Thanks,

Padmanabhan

Re: Error while loading from SharePoint

Roop — Mon, 12 May 2014 15:07:40 GMT

Need more information - What do you mean "limited load" ?

Thanks

Re: Error while loading from SharePoint

padmanabhan_ram — Mon, 12 May 2014 15:16:29 GMT

By Limited I meant, when I load the dashboard with 3000 or 4000 records in the debug mode, the dashboard refreshes fine. but when I make a full load of the dsahboard, it fails to read the data from SharePoint.

Re: Error while loading from SharePoint

Roop — Mon, 12 May 2014 15:23:04 GMT

How many records are in SharePoint?

I have used SharePoint in the past for a fairly limited data set and found that it can be OK most of the time. This could be your connection to SharePoint and it could be timing out.

I would suggest trying the file outside of SharePoint as it may well work and that will eliminate a few possibilities.

Re: Error while loading from SharePoint

padmanabhan_ram — Mon, 12 May 2014 16:16:24 GMT

Records in SP are more than 10,000

Re: Error while loading from SharePoint

Roop — Mon, 12 May 2014 21:05:19 GMT

I think that you need to test this file as a file outside SharePoint to eliminate SharePoint from the problem.

Re: Error while loading from SharePoint

Anonymous — Fri, 12 Sep 2014 14:56:25 GMT

There might be some data issue and may not be issue related to sharepoint. You get fulldata from sharepoint, and then try to manually load them, if it is working correctly, then check if there is indeed problem with sharepoint.