Symptom
- dbcc checkcatalog for user SID db returns Error 2514 on ASE 160 SP03 PL03 and above:
Msg 2514, Level 16, State 1:
Server '<SID>', Line 1:
Table Corrupt: Type id 0 (type name = 0) does not match between systypes and syscolumns
- dbcc checktable on systypes and syscolumns is clean, there are no errors reported. This can be verified via isql:
isql -S<SID> -Usapsa -X -w1000
use <SID>
go
dbcc checktable (systypes)
go
dbcc checktable (syscolumns)
go
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL03 and above for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL03 and above for standalone ASE
Product
SAP ERP 6.0
Keywords
checkcatalog, 2514, type, syscolumns, systypes, CDS, functions, 817622, usertype , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.