This morning, one of the DTS job failed on the step where it processes the
cube.

The error message is as follows:
User BI\Administrator on computer bi.macnet-ad.mc.com has locked 'Repository'

Does anyone know what causes the repository lock. I am new to this. Any
kind of help is greatly appreciated.

Thank you

Hi There.

Hearing your problem is leading me to the assumption that you still
have your OLAP repository in the Access database. This is the default
for Analysis Services when you install the product. If this is the
case, then I would suggest that you migrate your Repository to SQL
Server. This is very easily done because there is a wizard that takes
you through the steps in Analysis Services. Just right click on your
server in Analysis Manager and choose "Migrate Repository".

If you can't migrate to SQL Server then your problem is likely that
your access database is locked for some reason. I believe there are
white papers on MSDN that talks about how to unlock it. However, if
the SQL Server is an option I highly recommend that you migrate
immediately.

V

PS One step that you have to do before migrating is to create a blank
database on your SQL Server. I usually just create a default database
called "OLAP Repository", but you can name it whatever you want. Good
luck!