Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Need more information - What do you mean "limited load" ?
Thanks
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.
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.
Records in SP are more than 10,000
I think that you need to test this file as a file outside SharePoint to eliminate SharePoint from the problem.
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.