Day: July 9, 2007

Jerry Yasir

Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: The Application Server needs to have Analysis Services DSO Component installed.


During a configuration of Project Server 2007 Analysis Services I got the following error message "Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: The Application Server needs to have Analysis Services DSO Component installed. ". I tried the patch path given below and was able to resolve the issue without any issue.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;921116

On the computer that is running SQL Server 2005 Analysis Services, follow these steps:

a.

Install Microsoft SQL Server 2005 Service Pack 1 (SP1) or a later service pack. For more information about how to obtain the latest service pack for SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base:

913089 (http://support.microsoft.com/kb/913089/) How to obtain the latest service pack for SQL Server 2005

b.

Make sure that you are a member of the Server role on the Analysis Server. To add members to the server role for an instance of Analysis Services, follow these steps:

Note Members of the server role in an instance of SQL Server 2005 Analysis Services have unrestricted access to all Analysis Services objects and data in that instance. A member of the Analysis Services server role can add Microsoft Windows users and groups to the Analysis Services server role.

1.

In SQL Server Management Studio, connect to the instance of Analysis Services, right-click the instance name in Object Explorer, and then click Properties.

2.

Click Security in the Select a Page pane, and then click Add to add one or more Windows users or groups to the server role.

2.

Use one of the following methods, as appropriate for your situation:

•

If you have a single server deployment of Project Server 2003 in which Project Server 2003, SQL Server 2005, and SQL Server 2005 Analysis Services are installed on one computer, go to step 3. You do not have to perform the procedure in step 2.

•

If you have a server farm deployment of Project Server 2003, follow these steps:

a.

Start Microsoft Internet Explorer, and then visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en (http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en)

b.

On the computer or computers that are running the Project Server Views Notification Service, download and then install the following programs.

Note Install these programs in the order in which they are presented.

•

Microsoft .NET Framework 2.0

Note Install the .NET Framework 2.0 only if it is not already installed on the computer.

•

Microsoft Core XML Services (MSXML) 6.0

•

Microsoft SQL Server Native Client

•

Microsoft SQL Server 2005 Management Objects Collection

•

Microsoft SQL Server 2005 Backward Compatibility Components

Note When you install SQL Server 2005 Backward Compatibility Components, you have to install only Decision Support Objects (DSO). You do not have to install the other components.

•

Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

3.

On the computer that is running SQL Server 2005 Analysis Services, follow these steps:

Note This includes SQL Server 2005 Analysis Services that are running remotely in a 3-tier configuration.

a.

Create a subfolder that is named DSO9 in the following folder:

C:\Program Files\Microsoft Sql Server\Mssql.Number\OLAP

Note Mssql.Number is the folder in which the SQL Server 2005 Analysis Services files are stored.

b.

Copy the Msmdrep.mdb file from a computer that is running a fully patched SQL Server 2000 Analysis Services to the DSO9 folder on the computer that is running SQL Server 2005 Analysis Services.

c.

Share the DSO9 folder, and then specify MSOLAPRepository$ as the share name for the shared folder.

d.

Assign Read access and Write access for the shared folder. Do this for the Local Administrators group or for any account that Project Server 2003 will use to connect to Analysis Services for processing.

The account that accesses Analysis Services from Project Server 2003 must be granted the appropriate permissions on the Analysis Services instance.

e.

Open the Msmdsrv.ini file, and then replace the contents of the <DSO> tag with the following code:

<DSO> <RemoteRepositoryConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ComputerName\MSOLAPRepository$\msmdrep.mdb;Persist Security Info=False</RemoteRepositoryConnectionString> <RepositoryConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft SQL Server\MSSQL.Number\OLAP\DSO9\msmdrep.mdb;Persist Security Info=False</RepositoryConnectionString> <RemoteLocksDirectory>\\ComputerName\MSOLAPRepository$</RemoteLocksDirectory> <LocksDirectory>C:\Program Files\Microsoft SQL Server\MSSQL.Number\OLAP\DSO9</LocksDirectory> </DSO>

Note The Msmdsrv.ini file is located in the Path\Config folder. Make sure that you replace ComputerName in the code with the name of the computer that is running SQL Server 2005 Analysis Services.

The first time that you save the Msmdsrv.ini file, SQL Server 2005 Analysis Services encrypts the "ConnectionString" information. After this occurs, you cannot read the information when you open the file again. Therefore, you should keep a copy of the code in case you need it in the future.

f.

Stop and then restart the SQL Server 2005 Analysis Services service.

4.

Log on to Project Web Access 2003, and then build an OLAP cube. When you build the OLAP cube, specify the computer that is running SQL Server 2005 Analysis Services on the Update resource tables and OLAP cube page.
Jerry Yasir

Project Server 2007 Class Libraries and Web Services


Jerry Yasir

Adding a Web Reference to the PSI in the RTM Build


http://blogs.msdn.com/project_programmability/archive/2006/12/12/adding-a-web-reference-to-the-psi-in-the-rtm-build.aspx

Some times in Project Server, you may run into the following issue, where you are unable to add the Web Reference to the PSI

"The Document at the following uRL is not know type … bla bla bla."

The workaround is to click on the "Service Description" link. This will allow you to add the Web Reference to your project.

Regards,

Jerry

Jerry Yasir

Sgen.exe Exited with Code 1


VIA ligAZ blog

A Blog to Remember

"sgen.exe" exited with code 1

If you are having this problem while building your VS.NET 2005 project in Release mode here is the solution:

Go to the project properties. Click on the build tab and set the value of the "Generate Serialization Assembly" dropdown to Off.

P.S. If you wonder for what is this sgen.exe here is explanation from the msdn: "The XML Serializer Generator creates an XML serialization assembly for types in a specified assembly in order to improve the startup performance of a XmlSerializer when it serializes or deserializes objects of the specified types.".