Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

When a cube build fails, the OLAP procedure attempts to remove the directories that it created. If the process fails in such a way that this is not possible, rebuilding the cube might cause a new directory to be created with a numeric suffix appended to the end of the directory name, for example:

   PATH/CubeName
   PATH/CubeName1
   PATH/CubeName2
   ...
   PATH/CubeNameN

If a cube build fails, before rebuilding the cube, you should use either operating system utilities or SAS programs to remove any directories created by the process. Taking this action will prevent the query process from trying to retrieve data from the original directory if it exists. Another side effect of the extra directories is that they could eventually use up the available disk space and result in insufficient disk space errors.

This problem is more likely to happen on a UNIX environment where the UNIX permissions do not allow the current user to delete the existing cube files that might have been created by a different user. You can consider using the UMASK feature to have each cube developer start the workspace server with the same permissions pattern. This should allow each cube developer the ability to delete the existing cube files, even if they were created by a different user. For more information on creating a UMASK definition in the workspace server, please refer to SAS Note 38040.

Another situation that can cause this issue is when a cube is imported to an environment in the same metadata folder using the same cube name. If you are importing a cube that already exists in a particular folder, you should use a PROC OLAP DELETE_PHYSICAL statement in order to remove the physcial files from the operating system before importing the cube. For information about the DELETE_PHYSICAL option, read the documentation for the PROC OLAP Statement in the OLAP Server User's Guide.

Operating System and Release Information