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.
SAP Knowledge Base Article - Preview