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