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.

An internal consistency error occured (SQL-DMO(ODBC SQLState: 42000)

Hello!

I am trying to restore a dataset and I receive this error message
SQL-DMO(ODBC SQLState: 42000)
An internal consistency error occured.

Does anyone know what this means?
Could it be a different sort order? (But ususally then you receive an error saying something about the sort order.)

Thank you for any help!

marjoOriginally posted by marjo
Hello!

I am trying to restore a dataset and I receive this error message
SQL-DMO(ODBC SQLState: 42000)
An internal consistency error occured.

Does anyone know what this means?
Could it be a different sort order? (But ususally then you receive an error saying something about the sort order.)

Thank you for any help!

marjo

Hallo Marjo,Regarding this call did you receive a solution to this problem?I am experiencing the same issue with a user I am supporting

I would be very glad if you coukd assist|||Hallo Rutger,

I cannot remember what the solution was. But later I was able to restore it without errors. It was something I did wrong - the data/log file selection, size of the db or something like that-, but I am not sure anymore because this happened already months ago.

Groeten,
Marjo|||Check the SQL error logs to find out the error ... that is the best place to find out why this is happening|||Originally posted by marjo
Hallo Rutger,

I cannot remember what the solution was. But later I was able to restore it without errors. It was something I did wrong - the data/log file selection, size of the db or something like that-, but I am not sure anymore because this happened already months ago.

Groeten,
Marjo

thanks,for your assistance|||Originally posted by Enigma
Check the SQL error logs to find out the error ... that is the best place to find out why this is happening

Enigma,where would I find the error logs because I looked in the events.log but nothing is showing

Brgs
Rutger|||SQL server logs would be in the [Installation Directory]\MSSQL\LOG folder. Check the latest one i.e ERRORLOG|||What is the level of Service pack on SQL?|||Originally posted by Satya
What is the level of Service pack on SQL?

Good Day,I do not have any service pack loaded yet,I hope this is a solution

Regards|||Did you find anything in the error logs ??|||Originally posted by Enigma
Did you find anything in the error logs ??
Nothing which points out the error,the problem arose when the user crashed his hard disk and recovered the data,all backups from that disk give the same error time and time again

I tried to restore this disk on various other sql servers but the same thing,it looks like the data integrity is hindered

An exception was thrown while trying to delete a maintenance plan.

Receive a message that an exception was thrown while trying to delete a
maintenance plan.
SQL 2005 with spk 2aSQLdba wrote:
> Receive a message that an exception was thrown while trying to delete a
> maintenance plan.
> SQL 2005 with spk 2a
I posted a message yesterday regarding this problem. :-)
I believe you've created that maintenance plan under either different
user or the same user with different password. If former, connect with
the same user, if latter - change the password, delete the MP and then
change the password back.

An exception was thrown while trying to delete a maintenance plan.

Receive a message that an exception was thrown while trying to delete a
maintenance plan.
SQL 2005 with spk 2a
SQLdba wrote:
> Receive a message that an exception was thrown while trying to delete a
> maintenance plan.
> SQL 2005 with spk 2a
I posted a message yesterday regarding this problem. :-)
I believe you've created that maintenance plan under either different
user or the same user with different password. If former, connect with
the same user, if latter - change the password, delete the MP and then
change the password back.