Solved

PerformancePoint Dashboard Designer 2010 Unable to Retrieve List

Posted on 2012-04-04
1
1,373 Views
Last Modified: 2012-04-11
Using PerformancePoint Dashboard Designer 2010 I can connect to all but 2 of the lists in my site.  The tasks list and another custom list I have are failing the connection test with a "Unable to retreive list." message.  Other lists as indicated all work fine.  The task list has been customized to add some additional fields used for workflows, and the other list I am attempting to connect to has about 35 columns.

On the server, the following event is logged:

Error 4/4/2012 2:28:27 PM PerformancePoint Service 1 PerformancePoint Services

Log Name:      Application
Source:        Microsoft-SharePoint Products-PerformancePoint Service
Date:          4/4/2012 2:28:27 PM
Event ID:      1
Task Category: PerformancePoint Services
Level:         Error
Keywords:      
User:          FC\SPSERVICE
Computer:      ROTHKO.FC.FUJIMICO.com
Description:
Unable to retrieve list.

System.Web.Services.Protocols.SoapException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.ListService.GetListItems(String listName, String viewName, XmlNode query, XmlNode viewFields, String rowLimit, XmlNode queryOptions)
   at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.SpListDataSourceProvider.getPreviewDataSet(String maxRecords)

PerformancePoint Services error code 201.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft-SharePoint Products-PerformancePoint Service" Guid="{A7CD5295-CBBA-4DCA-8B67-D5BE061B6FAE}" />
    <EventID>1</EventID>
    <Version>14</Version>
    <Level>2</Level>
    <Task>1</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime="2012-04-04T21:28:27.131342500Z" />
    <EventRecordID>127308</EventRecordID>
    <Correlation ActivityID="{7B6420BF-A0B6-4AAC-B018-44969AEC54F8}" />
    <Execution ProcessID="8012" ThreadID="1712" />
    <Channel>Application</Channel>
    <Computer>ROTHKO.FC.FUJIMICO.com</Computer>
    <Security UserID="S-1-5-21-842925246-1592454029-1801674531-20645" />
  </System>
  <EventData>
    <Data Name="string1">Unable to retrieve list.

System.Web.Services.Protocols.SoapException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.ListService.GetListItems(String listName, String viewName, XmlNode query, XmlNode viewFields, String rowLimit, XmlNode queryOptions)
   at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.SpListDataSourceProvider.getPreviewDataSet(String maxRecords)

PerformancePoint Services error code 201.</Data>
  </EventData>
</Event>
0
Comment
Question by:fujimico
1 Comment
 

Accepted Solution

by:
fujimico earned 0 total points
ID: 37835082
Looks like I found the answer to this one myself.  I had 5 additional people lookup fields in this list.  After deleting and recreating these as single line of text fields, I was able to connect to the list.  This isn't so much a solution as it is a workaround.  It happens that this list is being populated by a workflow, so as long as I populate those fields with user names from the workflow and no-one has to manually edit the list items, this is acceptable.  Seems like Microsoft needs to change their query methods or provide some access to timeout values on the queries.?.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now