Project Server 2007 Data Analysis common issues

 

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.

Error Message

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.

 

Component  

Version  

State during installation  

Microsoft Core XML Services (MSXML)  

6.0 

All components are available in the downloadable Feature Pack for Microsoft SQL Server 2005.

Microsoft SQL Server 2005 Analysis Services OLE DB provider

9.0 

 

Microsoft Office Web Components 11 (OWC11)

2003 

 

 

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.

Leave Reply

Hey, so you decided to leave a comment! That’s great. Just fill in the required fields and hit submit. Note that your comment will need to be reviewed before it’s published Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>