No of visitors who read this post: 1003
Type: Question
Your rating: None Average: 5 (1 vote)

“An unexpected system error has occurred. Additional details have been logged for your administrator. ” Appears when I create a new data connection using Performance Point Dashboard Designer. I right click Data Connections, select “New Data Source” then Excel Services. The error pops up after I click “Ok”.

These are the errors found on the USL Logs:

An unexpected error occurred. Error 8205

An unexpected error occurred. Error 8205. Exception details: System.Web.Services.Protocols.SoapException: You do not have permissions to open this file.

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.Client.ExcelService.OpenWorkbook(String workbookPath, String uiCultureName, String dataCultureName, Status[]& status)
at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.ExcelServicesDataSourceProvider.GetCubeMetaData(Boolean extendedMetadata)
at Microsoft.PerformancePoint.Scorecards.Server.PmServer.GetCubeMetaDataForDataSourceHelper(DataSource dataSource, Boolean extendedMetadata)
atMicrosoft.PerformancePoint.Scorecards.Server.PmServer.GetCubeMetaDataForDataSource(DataSource data Source)

It says “logged for your administrator” so I’m thinking maybe it’s a user issue but I’m not sure.

I desperately need someone to explain it to me because I’ve searched and can’t find a solution.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

#

Hallo Tamara,

To resolve that issue, you will need to install the WCF hot Fix that is designed for Windows Server 2008 R2. Check the following steps:

  • Do the following Central Administration >> Application Management >> Manage Service Application, and after that you will need to double click Secure Store Application followed by Generate New Key.
  • Also do the following Central Administration >> Application Management >> Manage Service Application >> PerformancePoint Service Application >> Manage, and then choose Update the PerformancePoint Unattended Service Account which is the first option.

The following step has to be successful, and in the event that it fails you will have to get rid of the PerformancePoint Service Application and after that you will have recreate it.

  • Do the following Central Administration >> Application Management | Manage Service Application >> PerformancePoint Service Application >> Administrator, and then Add the Unattended Service Account as well as Mark Full Control.

Regards,

Carl