Analysis Services 2000 Error - OlapObjects

Good day

I'm having trouble registering an AS 2000 server. The following is the error I receive:

"The cube 'OlapObjects' does not exist, or it is not processed"

Both servers have Service Pack 4 installed.

What does this mean? Google is not much help either.

You might need to post the exact step you are performing. Registering a server in Analysis Manager does not try to access any cubes so this error does not make sense. And OlapObjects is the name of the table in the OLAP repository for AS2000, but you should NEVER access that directly.

Analysis Server on Windows 2003

Hi all,
I am having trouble getting Analysis server to run on my Windows 2003, are
there any KNOWN compatibility issues?
Thanks...MWhat kind of problems are you running into?
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michelle" <smiley2211@.yahoo.com> wrote in message
news:eq8VC22SFHA.2916@.TK2MSFTNGP15.phx.gbl...
> Hi all,
> I am having trouble getting Analysis server to run on my Windows 2003, are
> there any KNOWN compatibility issues?
> Thanks...M
>|||Hi,
Check the article below
http://support.microsoft.com/defaul...kb;en-us;815486
HTH
Andreas
"Dave Wickert [MSFT]" wrote:

> What kind of problems are you running into?
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Michelle" <smiley2211@.yahoo.com> wrote in message
> news:eq8VC22SFHA.2916@.TK2MSFTNGP15.phx.gbl...
>
>|||Morning Dave,
We get the following error when trying to register AS...
"errors connecting to MYSERVER - incompatible repository"
Thanks...M
"Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote in
message news:E52B35EA-89EF-4FBF-AC5F-10E72A515300@.microsoft.com...[vbcol=seagreen]
> Hi,
> Check the article below
> http://support.microsoft.com/defaul...kb;en-us;815486
> HTH
> Andreas
> "Dave Wickert [MSFT]" wrote:
>|||Sorry. I've never heard of that one.
I'd post it on microsoft.public.sqlserver.olap and possible one of the PSS
engineers will pick it up.
The only other posting that I've seen is the kb article:
http://support.microsoft.com/defaul...kb;en-us;288890
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michelle" <smiley2211@.yahoo.com> wrote in message
news:%23UHMPB$SFHA.3392@.TK2MSFTNGP12.phx.gbl...
> Morning Dave,
> We get the following error when trying to register AS...
> "errors connecting to MYSERVER - incompatible repository"
> Thanks...M
> "Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote
in
> message news:E52B35EA-89EF-4FBF-AC5F-10E72A515300@.microsoft.com...
2003,[vbcol=seagreen]
>|||Hi All,
Thanks for your help...it was Andreas recommendation that solved my
problem...I needed SP3 for Analysis server installed.
---
Check the article below
---
Thanks...M
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message
news:%23MTJd$ETFHA.3212@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Sorry. I've never heard of that one.
> I'd post it on microsoft.public.sqlserver.olap and possible one of the PSS
> engineers will pick it up.
> The only other posting that I've seen is the kb article:
> http://support.microsoft.com/defaul...kb;en-us;288890
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Michelle" <smiley2211@.yahoo.com> wrote in message
> news:%23UHMPB$SFHA.3392@.TK2MSFTNGP12.phx.gbl...
> in
> 2003,
>

Analysis Server on Windows 2003

Hi all,
I am having trouble getting Analysis server to run on my Windows 2003, are
there any KNOWN compatibility issues?
Thanks...M
What kind of problems are you running into?
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michelle" <smiley2211@.yahoo.com> wrote in message
news:eq8VC22SFHA.2916@.TK2MSFTNGP15.phx.gbl...
> Hi all,
> I am having trouble getting Analysis server to run on my Windows 2003, are
> there any KNOWN compatibility issues?
> Thanks...M
>
|||Hi,
Check the article below
http://support.microsoft.com/default...b;en-us;815486
HTH
Andreas
"Dave Wickert [MSFT]" wrote:

> What kind of problems are you running into?
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Michelle" <smiley2211@.yahoo.com> wrote in message
> news:eq8VC22SFHA.2916@.TK2MSFTNGP15.phx.gbl...
>
>
|||Morning Dave,
We get the following error when trying to register AS...
"errors connecting to MYSERVER - incompatible repository"
Thanks...M
"Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote in
message news:E52B35EA-89EF-4FBF-AC5F-10E72A515300@.microsoft.com...[vbcol=seagreen]
> Hi,
> Check the article below
> http://support.microsoft.com/default...b;en-us;815486
> HTH
> Andreas
> "Dave Wickert [MSFT]" wrote:
|||Sorry. I've never heard of that one.
I'd post it on microsoft.public.sqlserver.olap and possible one of the PSS
engineers will pick it up.
The only other posting that I've seen is the kb article:
http://support.microsoft.com/default...b;en-us;288890
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michelle" <smiley2211@.yahoo.com> wrote in message
news:%23UHMPB$SFHA.3392@.TK2MSFTNGP12.phx.gbl...
> Morning Dave,
> We get the following error when trying to register AS...
> "errors connecting to MYSERVER - incompatible repository"
> Thanks...M
> "Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote
in[vbcol=seagreen]
> message news:E52B35EA-89EF-4FBF-AC5F-10E72A515300@.microsoft.com...
2003,
>
|||Hi All,
Thanks for your help...it was Andreas recommendation that solved my
problem...I needed SP3 for Analysis server installed.
Check the article below[vbcol=seagreen]
Thanks...M
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message
news:%23MTJd$ETFHA.3212@.TK2MSFTNGP10.phx.gbl...
> Sorry. I've never heard of that one.
> I'd post it on microsoft.public.sqlserver.olap and possible one of the PSS
> engineers will pick it up.
> The only other posting that I've seen is the kb article:
> http://support.microsoft.com/default...b;en-us;288890
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Michelle" <smiley2211@.yahoo.com> wrote in message
> news:%23UHMPB$SFHA.3392@.TK2MSFTNGP12.phx.gbl...
> in
> 2003,
>

AMO Role drop trouble

I've some trouble trying to drop roles with AMO and the following code:

Role oCurrentRole = oOLAPDB.Roles.GetByName(<role name>);
oCurrentRole.Drop(DropOptions.AlterOrDeleteDependents);

Most of the time it's OK but I've sometimes this error

Exception non gre : System.InvalidOperationException: Impossible de supprimer l'objet ? Role ?my role , il doit faire partie d'un objet Server connect.
à Microsoft.AnalysisServices.MajorObject.DropPrivate(DropOptions options, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
à Microsoft.AnalysisServices.MajorObject.Drop(DropOptions options)

(in english: Unhandled exception : System.InvalidOperationException: Unable to drop ? Role object ?my role , it must be part of a connected Server object)

I'm the only one connected to this server and I'm sure this role isn't used.

One thing to mention: It seems I've this error only with roles with members which are no more existing in the domain (they were when the role was created but get deleted later).

Any idea ? How could I drop these roles with AMO ?

David,

I created an account on my local system, JunkUser, and then created a role in Adventure Works DW called JunkRole. JunkUser is the lone member of this role. I then dropped the JunkUser account from my system.

In SSIS, I created a package with a single Script task. I added the AMO reference and an Imports statement to simplify my code. In Sub Main, I added this code:

Code Snippet

Dim MyServer As New Server

MyServer.Connect(".")

Dim MyDatabase As Database = MyServer.Databases.GetByName("Adventure Works DW")

Dim MyRole As Role = MyDatabase.Roles.GetByName("JunkRole")

MyRole.Drop(DropOptions.AlterOrDeleteDependents)

MyServer.Disconnect()

I executed the SSIS package. It completed successsfully and I verified the JunkRole had been dropped.

I am running on SP2.

Not sure what might else may be causing the problem you are seeing.

B.

|||My bad

You're right Bryan, it doens't matter if the user has been deleted or not

In fact, I had a nice
oServer.Disconnect();
just before my code... And of course, oServer is my OLAP Server object... Now that I'm thinking about it, the error message was quite explicit ("...connected Server")