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

AMO: list of cubes using a dim

Hello!

I'm trying to get a list of all cubes which are using a specific dimension with AMO. I could get a list of all cubes, then all dimensions used by each cube and check where my dimension is used but I feel there must be a more elegent solution ;-)
There is a GetReferences method in the Dimension object but I don't know how to use it, any idea or a better way to get my list ?

Other question: is there a way to automatically do a full or update process on each dim of a cube when we process this cube without having to list them all before ?

Thx!

I suggest to write the code that you mentioned: iterate over all Cubes and their CubeDimensions, checking which CubeDimension points to your Dimension. Because one Dimension can be included multiple times in a Cube (role-playing dimensions feature), you won't be able to use the cube.Dimensions.Contain(...) method (because that method is based on the ID of the CubeDimension which is not necessarily the same as the ID of the Dimension). When checking if a CubeDimension points to your Dimension, it's faster to compare the string IDs (CubeDimension.DimensionID with Dimension.ID, case insensitive compare), than to use the CubeDimension.Dimension property (because that does a lookup).

The GetReferences method will do the same iterations over all the Cubes and their CubeDimensions, plus more (so it won't be faster than your code).

Adrian

|||Thx for your help Adrian!

AMO: list of cubes using a dim

Hello!

I'm trying to get a list of all cubes which are using a specific dimension with AMO. I could get a list of all cubes, then all dimensions used by each cube and check where my dimension is used but I feel there must be a more elegent solution ;-)
There is a GetReferences method in the Dimension object but I don't know how to use it, any idea or a better way to get my list ?

Other question: is there a way to automatically do a full or update process on each dim of a cube when we process this cube without having to list them all before ?

Thx!

I suggest to write the code that you mentioned: iterate over all Cubes and their CubeDimensions, checking which CubeDimension points to your Dimension. Because one Dimension can be included multiple times in a Cube (role-playing dimensions feature), you won't be able to use the cube.Dimensions.Contain(...) method (because that method is based on the ID of the CubeDimension which is not necessarily the same as the ID of the Dimension). When checking if a CubeDimension points to your Dimension, it's faster to compare the string IDs (CubeDimension.DimensionID with Dimension.ID, case insensitive compare), than to use the CubeDimension.Dimension property (because that does a lookup).

The GetReferences method will do the same iterations over all the Cubes and their CubeDimensions, plus more (so it won't be faster than your code).

Adrian

|||Thx for your help Adrian!

AMO: list of cubes using a dim

Hello!

I'm trying to get a list of all cubes which are using a specific dimension with AMO. I could get a list of all cubes, then all dimensions used by each cube and check where my dimension is used but I feel there must be a more elegent solution ;-)
There is a GetReferences method in the Dimension object but I don't know how to use it, any idea or a better way to get my list ?

Other question: is there a way to automatically do a full or update process on each dim of a cube when we process this cube without having to list them all before ?

Thx!

I suggest to write the code that you mentioned: iterate over all Cubes and their CubeDimensions, checking which CubeDimension points to your Dimension. Because one Dimension can be included multiple times in a Cube (role-playing dimensions feature), you won't be able to use the cube.Dimensions.Contain(...) method (because that method is based on the ID of the CubeDimension which is not necessarily the same as the ID of the Dimension). When checking if a CubeDimension points to your Dimension, it's faster to compare the string IDs (CubeDimension.DimensionID with Dimension.ID, case insensitive compare), than to use the CubeDimension.Dimension property (because that does a lookup).

The GetReferences method will do the same iterations over all the Cubes and their CubeDimensions, plus more (so it won't be faster than your code).

Adrian

|||Thx for your help Adrian!