Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    14

    Unanswered: DBCC CHECKCATALOG error

    Hi,
    While running DBCC CHECKCATALAOG , the following error is
    seen , how to go about resolving ? any help in this regard
    is highly appriciated.

    We are using ASE 12.0 on Solaris 10

    Table Corrupt: Procedure id 1143115263 (procedure name =
    1143115263) does
    not match between Sysprocedures and Sysobjects
    Msg 2517, Level 16, State 1:
    Server 'ppegSun3', Line 1:
    Table Corrupt: Procedure id 1143115263 (procedure name =
    1143115263) does
    not match between Sysprocedures and Sysobjects
    Msg 2517, Level 16, State 1:
    Server 'ppegSun3', Line 1:
    Table Corrupt: Procedure id 1143115263 (procedure name =
    1143115263) does not match between Sysprocedures and
    Sysobjects
    Msg 2517, Level 16, State 1:
    Server 'ppegSun3', Line 1:
    Table Corrupt: Procedure id 1143115263 (procedure name =
    1143115263) does
    not match between Sysprocedures and Sysobjects
    The following segments have been defined for database 4



    I used the following steps to find out the procedure name
    but Not Successful.

    1> select object_name (1143115263)
    2>

    ------------------------------
    NULL

    (1 row affected)


    But when I check in sysprocedures I find 4 rows with the
    particular id.


    1> select * from sysprocedures where id=1143115263
    2>
    type id sequence status number version
    ------ ----------- -------- ------ ------ -----------
    2 1143115263 52 0 1 NULL
    2 1143115263 53 0 1 NULL
    2 1143115263 54 0 1 NULL
    2 1143115263 55 0 1 NULL

    (4 rows affected)
    Execution Time (ms.): 0 Clock Time (ms.):
    0


    And it is Not available in sysobjects


    1> select * from sysobjects where id=1143115263
    2>
    name id uid type
    userstat
    sysstat indexdel schemacnt sysstat2 crdate
    expdate deltrig
    instrig updtrig seltrig ckfirst
    cache
    audflags objspare versionts loginame
    ------------------------------ ----------- ------ ----
    --------
    ------- -------- --------- -----------
    --------------------------
    -------------------------- -----------
    ----------- ----------- ----------- -----------
    ------
    ----------- ----------- --------------------------
    ------------------------------


    *-----------------------------------------------------------*
    Can I delete the rows from sysprocedures ?...
    *-----------------------------------------------------------*

    Thanks and regards
    Umakant P Mirji

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Check here for a fairly complete description of how to resolve this error.
    I'm not crazy, I'm an aeroplane!

Posting Permissions

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