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. 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 response Stream, 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 have searched and can’t find a solution.
Dashboard Designer – Error Message
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
Dashboard Designer – Error Message
Hello,
I received the same error (An unexpected error occurred. Error 8205) and I contacted Microsoft about the issue and they replied that Performance point does not work with SSL. It works fine without SSL on my system which justifies their call.
So after this I figured out to not to trust these new products as they do no good to you. They do not have good documentation plus the bugs are everywhere. And these meaningless errors continue to occur.
I hope this information provides the answer you are looking for.