When building an OLAP cube that has an open connection, you might receive an error message similar to the following:

ERROR: File is already locked by another user.
ERROR: The physical cube cannot be deleted. 

An open connection can be an active query against the OLAP cube, or it can be the result of an orphaned connection. Orphaned connections can occur when a client application (such as SAS^® Web Report Studio or SAS^® Web OLAP Viewer for Java) is improperly closed while a cube is being viewed. To prevent orphaned connections, always use the Log Off link to exit the application. Do not simply close the browser window.

To close an active session, use the SAS OLAP Server Monitor in SAS^® Management Console. For instructions, see Managing OLAP Sessions and Queries.

If you are creating cubes in batch and are using SAS^® 9.2, you can use the OLAPOPERATE Procedure to manage sessions before submitting the PROC OLAP code.

Operating System and Release Information