SAP Knowledge Base Article - Preview

2729470 - dbcc checkcatalog returns error Msg 2514 for Type id = 0 - SAP ASE

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 , SAP Business Suite on Sybase ASE Database Platform , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.