Hi All Experts,

I am using the msmdarch utility to restore a cube on the production
server daily automatically. However, the msmdarch does not restore the cube
roles information. The cube roles boxes are all blank. I checked the log but
no error was found.

If I restore the same cube file using the Analysis Manager GUI, I see
all the cube roles correctly restored.

What could I do wrong? Any idea will help.

thanks,
Howan


Here is the restore log:

Restore log. SQL Server 2000 Analysis Services.
Friday, June 04, 2004 3:16:47 PM
Restoring database CW ADM DC Prod to server CWDSS03.
6/4/2004 3:16:47 PM Locking the database.
6/4/2004 3:16:47 PM File: Admit Date.Fiscal.dim (2KB)
6/4/2004 3:16:47 PM File: Admit Date.Fiscal.dimcr (0.0KB)
6/4/2004 3:16:47 PM File: Admit Date.Fiscal.dimprop (0.0KB)
6/4/2004 3:16:47 PM File: Admit Date.Fiscal.dimtree (242KB)
6/4/2004 3:16:47 PM File: Admit Dr Serv.dim (2KB)
........
6/4/2004 3:16:49 PM File: CW Adm Dc v3.fact.data (5,835KB)
6/4/2004 3:16:50 PM File: CW Adm Dc v3.pdr (31KB)
6/4/2004 3:16:50 PM File: CW Adm Dc v3.prt (393KB)
6/4/2004 3:16:50 PM File: OLAPDB.REP (126KB)
6/4/2004 3:16:50 PM Removing old database information.
6/4/2004 3:16:51 PM Updating repository.
6/4/2004 3:16:56 PM Updating DSO.
6/4/2004 3:16:57 PM Validating roles.
6/4/2004 3:16:59 PM Database successfully restored.