Project Server 2007 Data Analysis errors and common issues faced
I have faced a number of scenarios where client machines are not able to process the data analysis views of PWA. Some of the common error messages faced were.
Project Server query could not be processed.
Cannot connect to the server ‘Project Server’. The server is either not started or too busy.
Situation 1: Missing components on the client machine.
Refer to article View OLAP Cube data Describes methods for your users to access OLAP cube data.
It is important you read this article.
State during installation
Microsoft Core XML Services (MSXML)
Microsoft SQL Server 2005 Analysis Services OLE DB provider
Microsoft Office Web Components 11 (OWC11)
This is if you have office 2003 installed on the client machines. If you have another version of Office, you will need to install the appropriate Office Web Component for that version
Situation 2: Cross liking of MSOLAP dll
If you have a situation where by the issue is client machine specific after ensuring that the above components are installed and available, I would suspect a cross interference of msolap dll.
I have seen this happen in the past and adopted the following to get around the issue.
The registration of MSOLAP90.dll may not have been completed as being default. A prior version of MSOLAP dll may be registered as the default.
Browse to location of MSOLAP dll using the command prompt and run the following. (you can easily find the location of MSOLAP.dll by runnin a search for MSOLAP*.dll on the client machine)
Sometimes instances of 8.0 and 9.0 get cross linked. Run the below from command prompt
- Regsvr32 –u msolap80.dll
- Regsvr32 –u msolap.dll
- Regsvr32 –u msolap90.dll
- Regsvr32 msolap90.dll
Now try and access the Data analysis Views.