dbTalk Databases Forums  

DTS Package Automate Cube update

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss DTS Package Automate Cube update in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
MiMi
 
Posts: n/a

Default DTS Package Automate Cube update - 01-10-2005 , 02:11 PM






This is cluster box, active passive cluster. But the Analysis Service on
the server is not clustered.
The SQL Server is on the same box as the analysis service. The two cluster
server name is DWDBA & DWDBB. The database instance name is DWDB.
The analysis service is installed at the B node.

I created a DTS successfully to automatically reprocess the cube. It works
fine from the DTS Package. But it does not work from the scheduled job. The
user "OfficeDomain\MiMi" belongs a member of the OLAP Administrators group
on this server. I got the following error:

"The Job failed. The The Job was invoked by OfficeDomain\MiMi. The last
step to run was step 1 (1)."
"Executed as user: OfficeDomain\svc-nqagt. ...nStart:
DTSStep_DTSOlapProcess.Task_1 DTSRun OnError:
DTSStep_DTSOlapProcess.Task_1, Error = -2147221455 (80040031) "
"Error string: Unable to connect to the registry on the server (DWDBB), or
you are not a member of the OLAP Administrators group on this server."

Any clue about what is going on ?

Appreciate the help. Thanks.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.