[umakantmirji]

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

[Martijnvs]

Check here for a fairly complete description of how to resolve this error.