Posting error with SQL

kmkaotkmkaot Member Posts: 261
Dear all,

When I try to post I am getting error related to SQL. When I run DBCC function in SQL, it is showing error table sysobjvalue which tells there are duplicate keys on the table. Now I am unable to access the table.
anyone have idea, please help me
warm regards
Kris

Answers

  • loggerlogger Member Posts: 126
    Hi @kmkaot ,
    As I got, you have duplication in primary key in sysobjvalue table? Can you make e.g. select in SSMS for this table?
    Let's go!
  • kmkaotkmkaot Member Posts: 261
    I could not see the table. in select syntax.
  • loggerlogger Member Posts: 126
    @kmkaot ,
    could you attach a screenshot with error?
    Let's go!
  • kmkaotkmkaot Member Posts: 261
    zzo7wejuixnb.png
  • lubostlubost Member Posts: 611
    I experienced that debugging code with events can cause debugger failure with various kind of errors. Also setting breakpoint in event subscriber shuts down debugger. It is possible that something wrong in my installation. Suggestions:
    1. G/L Entry permission
    2. G/L Entry consistency
    3. G/L Entry reindex
    4. Some hanged process which holds locks
    5. Some background process interferes to your process
  • kmkaotkmkaot Member Posts: 261
    any solution for me please..
  • kmkaotkmkaot Member Posts: 261
    i could resolve the issue.

    using dbcc i repaired and later RE INDEX
    THANKS
  • bbrownbbrown Member Posts: 3,268
    If you ran DBCC with "Allow Data Loss", be sure to review the table for missing data. With this setting, the "repair" can involve any bad records being deleted.
    There are no bugs - only undocumented features.
Sign In or Register to comment.