https://communities.sas.com/t5/ODS-and-Base-Reporting/BI-Cube-Update/m-p/70748#M8106 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: <BR /> <BR /> ERROR: File is already locked by another user.<BR /> ERROR: The physical cube cannot be deleted.<BR /> NOTE: The SAS System stopped processing this step because of errors.<BR /> ERROR: Cube "HMMKT_ACQ_CMPGNS" exists. You must use the DELETE_PHYSICAL option in PROC OLAP to remove the physical cube before<BR /> NOTE: The SAS System stopped processing this step because of errors.<BR /> <BR /> We're essentially deleting the cube then rebuilding it with our new data.<BR /> 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?<BR /> <BR /> Thanks,<BR /> Casey Wed, 21 Jan 2009 21:24:54 GMT deleted_user 2009-01-21T21:24:54Z https://communities.sas.com/t5/ODS-and-Base-Reporting/BI-Cube-Update/m-p/70748#M8106 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: <BR /> <BR /> ERROR: File is already locked by another user.<BR /> ERROR: The physical cube cannot be deleted.<BR /> NOTE: The SAS System stopped processing this step because of errors.<BR /> ERROR: Cube "HMMKT_ACQ_CMPGNS" exists. You must use the DELETE_PHYSICAL option in PROC OLAP to remove the physical cube before<BR /> NOTE: The SAS System stopped processing this step because of errors.<BR /> <BR /> We're essentially deleting the cube then rebuilding it with our new data.<BR /> 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?<BR /> <BR /> Thanks,<BR /> Casey Wed, 21 Jan 2009 21:24:54 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/BI-Cube-Update/m-p/70748#M8106 deleted_user 2009-01-21T21:24:54Z https://communities.sas.com/t5/ODS-and-Base-Reporting/BI-Cube-Update/m-p/70749#M8107 Have a look at this paper "How to Update Cubes on an Active SAS® OLAP Server" <A href="http://support.sas.com/techsup/technote/ts712.pdf" target="_blank">http://support.sas.com/techsup/technote/ts712.pdf</A> Wed, 21 Jan 2009 22:40:16 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/BI-Cube-Update/m-p/70749#M8107 GertNissen 2009-01-21T22:40:16Z