Results 1 to 11 of 11
  1. #1
    Join Date
    Oct 2002
    Posts
    3

    Red face Unanswered: 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!

    marjo

  2. #2
    Join Date
    Nov 2003
    Location
    south africa
    Posts
    6

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

    Originally 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

  3. #3
    Join Date
    Oct 2002
    Posts
    3

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

    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

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Check the SQL error logs to find out the error ... that is the best place to find out why this is happening
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  5. #5
    Join Date
    Nov 2003
    Location
    south africa
    Posts
    6

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

    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

  6. #6
    Join Date
    Nov 2003
    Location
    south africa
    Posts
    6

    Question error logs

    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

  7. #7
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    SQL server logs would be in the [Installation Directory]\MSSQL\LOG folder. Check the latest one i.e ERRORLOG
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  8. #8
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What is the level of Service pack on SQL?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  9. #9
    Join Date
    Nov 2003
    Location
    south africa
    Posts
    6
    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

  10. #10
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Did you find anything in the error logs ??
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  11. #11
    Join Date
    Nov 2003
    Location
    south africa
    Posts
    6

    Arrow

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •