Friday, October 9, 2009

PPS Error Msg : Unable to connect to Remote server

I got the follwing err Message after i did the PPS Instalation.
"
PPS - Error Code - 3008 Message : A configuration error has occurred( Unable to connect to Remote server)
"
Detail Error Msg
Event code: 3008 Event message: A configuration error has occurred. Event time: 10/8/2009 12:09:23 PM Event time (UTC): 10/8/2009 7:09:23 PM Event ID: 6a954f77e2cf4aa1a756c50f9cfeb8ef Event sequence: 1 Event occurrence: 1 Event detail code: 0 Application information: Application domain: /LM/W3SVC/774163112/Root/WebService-9-128995025636718750 Trust level: Full Application Virtual Path: /WebService Application Path: C:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\PPSMonitoring_1\WebService\ Machine name: 25070_2_165763 Process information: Process ID: 4200 Process name: w3wp.exe Account name: NT AUTHORITY\NETWORK SERVICE Exception information: Exception type: HttpException Exception message: Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. (C:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\PPSMonitoring_1\WebService\web.config line 25) Request information: Request URL: http://74.3.234.9:40000/WebService/PmService.asmx Request path: /WebService/PmService.asmx User host address: 74.3.234.9 User: Is authenticated: False Authentication Type: Thread account name: NT AUTHORITY\NETWORK SERVICE Thread information: Thread ID: 1 Thread account name: NT AUTHORITY\NETWORK SERVICE Is impersonating: False Stack trace: at System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
"

I refered the following link it solve my issue.

Block Question:
http://74.125.153.132/search?q=cache:onAi3XCJ0ocJ:social.technet.microsoft.com/forums/en-US/ppsmonitoringandanalytics/thread/c83614c0-547f-4243-b6c5-1c04629c9b14/+PPS+%2B+Event+code+3008+%2B+Event+message:+A+configuration+error+has+occurred.&cd=2&hl=en&ct=clnk&gl=in

Answer:
http://blogs.msdn.com/fooshen/archive/2008/10/18/performance-point-server-2007-and-ajax-on-sharepoint.aspx

Unable to connect to SQL Server 2005 Analysis Services from Dashboard Designer

I got the folowing error Msg in Dashboard Designer after i did the PPS Instalalation.
"
The PerformancePoint Server could not connect to the specified data source. Verify that either the current user or application pool user has Read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct."
Please refer this link for more detail. It solve my issue.
http://74.125.153.132/search?q=cache:thQqD6WhI7AJ:social.technet.microsoft.com/Forums/en-US/ppsmonitoringandanalytics/thread/a1633bfb-6dad-49de-9a8e-0d130e586f10+PPS+could+not+connect+to+Sql+server+Analysis+Server+Database&cd=1&hl=en&ct=clnk&gl=in

Answer:
If everything is installed on the same server then you could setup these local accounts that you have running the Application Pools to have the proper read permissions to the SSAS database by adding them into a Role with Read Definition and Read-only access to the cube(s). If you want to pass your credentials then you need to go into the web.config files in the Web Service, Preview, and SharePoint directories and modify the Bpm.ServerConnectionPerUser value in the AppSettings to True so that the credentials of the current logged in user will be passed to the database.If you are in a distributed environment then you will have to look at configuring Kerberos, Configuring Kerberos Delegation with PerformancePoint Monitoring Server, or using the CustomData option outilined here - PPS Data Connection Security with CustomData.