PerformancePoint Error: The list containing this item no longer exists or you do not have permission to view it

Error Messages:

The list containing this item no longer exists or you do not have permission to view it. The item cannot be viewed. Additional details have been logged for your administrator.

The following lists cannot be accessed from SharePoint Server. These lists have been deleted or you no longer have permissions to open them. If you lost your network connection, please try again after the connection is restored."

IMP:

If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Some known facts / additional notes:

1.   Performance Point doesn't support claims-based

2.   Make sure the account you use to logon the server has proper permissions to the data connection list since when SharePoint open dashboard designer from client side, it use the current account of the server not the current account of the SharePoint site.

3.   Does the web app pool identity have permissions to connect to performance point service application?

4.   Have you configured the unattended service account?

5.   http://technet.microsoft.com/en-us/library/ee836145.aspx

6.   The service account that runs the IIS app pools had to be added as a reader in the BI Center.

7.   Run this command:

$w = Get-SPWebApplication -Identity http://SharePointGalaxy

$w.GrantAccessToProcessIdentity(“domainPerformance Point Web App Service Account”)

Reference:

Planning and Architecture Guide for Planning Server

http://technet.microsoft.com/en-us/library/bb838746.aspx

PerformancePoint Training Documentation:

http://www.microsoft.com/business/performancepoint/resources/training.aspx

BI-VPC (This is a Virtual image that includes all aspects of PPS and BI including samples 2 parts):

Part 1:

http://www.microsoft.com/downloads/details.aspx?familyid=8f3d12ea-0dd1-4b22-b530-156e90a2616e&displaylang=en&tm

Part 2:

http://www.microsoft.com/downloads/details.aspx?familyid=60262cc1-30a7-41a2-a1c6-e3524fac18f6&displaylang=en&tm

PerformancePoint Documentation Library:

http://office.microsoft.com/en-us/performancepoint/HA102422371033.aspx

PerformancePoint Marketing Site:  http://www.microsoft.com/business/performancepoint

PerformancePoint Server Product Site: http://www.microsoft.com/bi/products/performancepoint-overview.aspx

ProClarity – Training, Resources: http://www.microsoft.com/bi/products/ProClarity/proclarity-overview.aspx

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Product applies to:

1.   SharePoint 2010

2.   SharePoint 2013

Performance Point Service could not connect to the specified data source

One more performance point issue! Previously I have written some articles based on Performance Point Services (PPS) issues and their resolutions, as follows:

http://sharepointknowledgebase.blogspot.com/2013/11/code-blocks-are-not-allowed-in-this.html

http://sharepointknowledgebase.blogspot.com/2013/10/unattended-service-account-for.html

http://sharepointknowledgebase.blogspot.com/2013/10/this-data-source-cannot-be-used-because.html

http://sharepointknowledgebase.blogspot.com/2014/04/were-sorry-we-ran-into-problem.html

http://sharepointknowledgebase.blogspot.com/2013/07/cannot-connect-to-performancepoint.html

Note:

If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

I have faced the following error while working on PPS and trying to connect SharePoint list via Dashboard Designer.

Error Message:

PerformancePoint Services could not connect to the specified data source. Verify that either the current user or Unattended Service Account has read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct.

How to reproduce this error?

1.   Open your site in browser

2.   Click on Run Dashboard designer

3.   You will see two options Data connections and PerformancePoint content

4.   Right click on Data connections -> New Data source

5.   Select the data that you are trying to connect (SP list, SQL Server table, analysis services, excel services)

6.   BOOM -> You will get the error at this step!

How to resolve this issue?

Here are the details: [2 step resolution]

Make sure the unattended account has already created. If this is not yet created then please use this link: http://sharepointknowledgebase.blogspot.com/2013/10/unattended-service-account-for.html

Before you start any troubleshooting, please ensure you check your ULS logs as it will give you the exact root cause behind it. When we checked our ULS logs then we found out that “the account needs Read Permission”)

It’s pretty simple once I know the cause. How to check this?

1.   Central administration

2.   Manage web applications

3.   Select the web application which is associated with your site

4.   User Policy

5.   Assign full read permission to unattended service account.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Product applies to:
-SharePoint 2010
-SharePoint 2013

Reference:
http://office.microsoft.com/en-us/dashboard-designer-help/getting-started-performancepoint-dashboard-designer-HA100800792.aspx

Web Applications using Claims authentication require an update

Recently we have created a web application using claims authentication and after few days, we have noticed an error in the health analyzer as mentioned below:

ERROR MESSAGE: Web Applications using Claims authentication require an update.

You don't need to research on this error as there is an official documentation has already been published by Microsoft. – Thank you MS.

Here is the link:

http://technet.microsoft.com/en-us/library/ff686815%28v=office.14%29.aspx

To download the update, go to

KB979917 - QFE for SharePoint issues - Perf Counter fix & User Impersonation.

Additional notes:

1.   Download the Windows6.1-KB979917-x64.msu (Win7) update (for Windows Server 2008 R2).

2.   Copy the setup to all your SharePoint servers -> Install it one by one.

3.   Once the install is finished then please restart all the servers.

4.   Once all the servers are up and running

5.   Click 'Reanalyze Now by means of health analyzer list

6.   The error shouldn't be there in the list!

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

IMP NOTE:

If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Product applies to:

1.   SharePoint Server 2010

2.   SharePoint Foundation 2010

Wow, that's a big workbook. Unfortunately, we can't open a workbook larger than 10 MB. You'll need to open this in Excel.

Problem description:

One user has reported an issue where he was getting an error while accessing the excel files from SharePoint site.

Before contacting the user, I tried uploading one dummy excel file to check the behavior and it works fine so I thought it might user who is doing some mistake. Further probing on the issue, I got the following details.

Entities:

1.   SharePoint 2013

2.   Excel 2013 / Office 2013

3.   Internet explorer 8.0

How to reproduce this error?

a)   Upload your excel document in the document library

b)   Try to open this document by directly clicking on it or excel dropdown ->view in browser.

c)   You will get the following error:

Error Message#1:

Wow, that's a big workbook. Unfortunately, we can't open a workbook larger than 10 MB. You'll need to open this in Excel.

Error message#2:

Couldn't Open the Workbook. Wow, that’s a big workbook. Unfortunately, we can't open a workbook larger than 10MB. You'll need to open this in Excel.

Error message#3:

The form submission cannot be processed because it exceeded the maximum length allowed by the web administrator. Please resubmit the form with less data.

Resolution:

a)   Central administration

b)   Application management

c)   Service applications

d)   Manage service applications

e)   Excel Services Application

f)    Trusted File locations

g)   Select the document library where your web part is failing

h)   Refer the section named as “workbook properties”

i)     Change the maximum workbook size

j)    By default its 10MB

k)   Change it to 50MB / 100MB as per your requirement

l)     Click OK.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Note:

If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Product applies to:

1.   SharePoint 2013

2.   SharePoint Foundation 2013

3.   SharePoint 2010

4.   SharePoint Foundation 2010

We're sorry. We ran into a problem completing your request. Please try that again in a few minutes.

This article is based on usage of Performance Point services with SharePoint 2013. Basically I am trying to generate an excel report with the help of performance point service.

Entities:

1.   SharePoint 2013

2.   Performancepoint Services

3.   Excel Services

How to reproduce the issue / error?

Here are the details:-

1.   Open the dashboard designer

2.   If you have already created the data connection then it’s good, if not then right click on the data connection and create a new.

3.   Once that done then you will get that external data i.e. SP list, SQL data etc inside the dashboard.

4.   Right click on data source ->select New -> Report

5.   Select excel services

6.   Click OK

7.   Once you will see the excel file selected in the “excel workbook” location then click on ‘View’

That’s it – You will get the error as mentioned below-

Error message:

We’re sorry. We ran into a problem completing your request. Please try that again in a few minutes.

How to fix this issue?

Here is the resolution:

1.   Open the Central administration

2.   Application management

3.   Manage web applications

4.   Select the web application where your site resides underneath

5.   Manage service connections

6.   Select the Excel Services Application

7.   Click OK

That’s it – You are done! Your issue will be resolved J

In case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Note: If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

Product Applies to:

1.   SharePoint 2013

2.   SharePoint 2010

3.   SharePoint Foundation 2010

4.   SharePoint Foundation 2013