BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi, our team has a series of cubes that we have update on a nightly basis, we've recently been running into errors (error code 1012) during our update cycle (which occurs at 2am), we receive the following error:

ERROR: File is already locked by another user.
ERROR: The physical cube cannot be deleted.
NOTE: The SAS System stopped processing this step because of errors.
ERROR: Cube "HMMKT_ACQ_CMPGNS" exists. You must use the DELETE_PHYSICAL option in PROC OLAP to remove the physical cube before
NOTE: The SAS System stopped processing this step because of errors.

We're essentially deleting the cube then rebuilding it with our new data.
Is there a way for us to somehow determine if our cube is being used before our update kicks off, also, if we can; can we then terminate the connection so we can proceed with our normal update procedure?

Thanks,
Casey
1 REPLY 1
GertNissen
Barite | Level 11
Have a look at this paper "How to Update Cubes on an Active SAS® OLAP Server" http://support.sas.com/techsup/technote/ts712.pdf

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 663 views
  • 0 likes
  • 2 in conversation