Troubleshooting OLAP Problems

February 11, 2003

Should you have problems with Analysis Services, review this troubleshooting checklist to find potential solutions.

1. Check that you use the latest SQL Server service pack.

Because many Analysis Services bugs were fixed in SQL Server service packs, you should use the latest service pack. To check what SQL Server service pack are you running, see this link: How can I check what SQL service pack am I running? To download the latest SQL Server service pack, see this link: Where can I download the SQL Server service packs?

2. You might get an error message indicating "Cannot connect to the registry on the server computer (server2000)," when attempting to register an OLAP server running on Windows 2000 from an OLAP server running on Windows NT.

To work around this problem, start the remote registry service on the computer running Windows 2000. To start the remote registry service, do the following: Click Start -> Programs -> Administrative Tools -> Services -> right-click Remote Registry Service, and click Start.

3. The MSSQLServerOLAPService service fails to start after the server computer name has been changed or the network card has been replaced.

In this case, you should reinstall Analysis Services.

4. The MSSQLServerOLAPService service fails to start when the first word in the name of the root folder for Analysis Services is duplicated among root folder names on the same disk.

To work around this problem, you should rename the folder that does not contain Analysis Services.

5. You will get an error message that indicates, "Cannot obtain server's start directory from registry," if the path of the Analysis Services data directory contains more than 102 characters.

To work around this problem, you should change the path of the Analysis Services data directory by using the Data folder box in the Properties dialog box for the server.

6. A change made to a Windows NT 4.0 user's permissions does not take effect.

This happens when the change was made while the user was logged on to Windows NT 4.0. To apply new permissions, the user should log off and then log on again.

7. An error message indicating that insufficient disk space for temporary files is displayed.

To work around this problem, release space on the disk where the Analysis Services store the temporary file folder, or specify a temporary file folder on another disk with more space.

8. You can get an error message indicating that you do not have permission to administer the Analysis server.

To work around this problem, log on to Analysis server using an account that is a member of the OLAP Administrators group.

9. If the cubes use new SQL Server 2000 Analysis Services features, the SQL Server 7.0 OLAP Services client applications cannot see these cubes in the list of cubes in a database.

To work around this problem, upgrade SQL Server 7.0 OLAP Services client applications to the SQL Server 2000 Analysis Services client applications.

10. If you change the data source provider for an existing cube, an error can occur the next time the cube is processed.

Use Decision Support Objects (DSO) or Cube Editor to correct the problem. Microsoft does not recommend changing the data source provider for an existing cube, because different providers can use different SQL syntax.

11. The users view an old version of a cube or virtual cube when the cube or virtual cube was changed but not processed, or when the cube or virtual cube was processed during the users browse session.

To work around this problem, the Analysis Services administrator should process the cube or virtual cube, and the users should log off and then log on again.

12. A program using ADOMD may hang with 100% CPU if there is no BeginTrans corresponding to CommitTrans.

Always pair BeginTrans with CommitTrans.

13. If a virtual dimension is based on a column that has more than 760 rows, it is not possible to drill down data for this dimension when you browse the cube.

Create a regular dimension instead of a virtual dimension. This is an SQL Server 7.0 OLAP Services bug; SQL Server 2000 Analysis Services do not contain this problem.

14. The SQL Server 7.0 OLAP Services Manager is unable to browse a cube when the 'All Caption' property for the dimension matches the name of any level in the dimension.

Change the name selected for the 'All Caption' property.

15. If SQL Server authentication is used to connect to SQL Server ROLAP cubes, the incremental updates of ROLAP cubes may fail with an error message that indicates, "There is already an object named 'tableName' in the database."

The tables containing the aggregates data are dropped when incremental updates on ROLAP cubes are performed for the second time. OLAP server attempts to drop tables that have dbo as the owner. If the tables were created using another owner, the above error will occur. To work around this problem, create all objects with the user as dbo. This is an SQL Server 7.0 OLAP Services bug; SQL Server 2000 Analysis Services does not contain this problem.

16. When the OLAP repository is empty, the OLAP repository migration wizard fails with an error message that indicates "Error copying repository data."

Prior to migrating the OLAP repository, you should create at least one OLAP Services database.

17. If SQL Server 7.0 OLAP Services is installed in the root directory, the user connecting remotely gets an error message.

Microsoft recommends installing OLAP services in the default path (..\Program Files\OLAP Services). This is an SQL Server 7.0 OLAP Services bug; SQL Server 2000 Analysis Services does not contain this problem.

18. You can get an error when processing all shared dimensions either from SQL Server 7.0, OLAP Manager, or from a SQL Server 7.0 DTS package.

To work around this problem, process each shared dimension one by one, instead of trying to process all dimensions. This is an SQL Server 7.0 OLAP Services bug; SQL Server 2000 Analysis Services does not contain this problem.

19. You can get an error during the processing of a cube, if the cube has more than 128 levels.

Microsoft recommends limiting the number of levels per cube to 128. This is an SQL Server 7.0 OLAP Services bug; SQL Server 2000 Analysis Services does not contain this problem.

20. After an incremental processing of the cube, the date fields display incorrectly when a time dimension is based on the fact table.

This is an SQL Server 7.0 OLAP Services bug. To resolve this problem, incrementally update or refresh the time dimension before you process the cube, or apply Service Pack 2 for SQL Server 7.0.

» See All Articles by Columnist Alexander Chigrik








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers