SAP Knowledge Base Article - Preview

2378231 - dbcc checkcatalog reports Error 2514 on tUDF objects - SAP ASE for Business Suite

Symptom

You run dbcc checkcatalog at runtime or in preparation for an upgrade. dbcc checkcatalog on the <SID> database reports the following error (possibly many times):

Msg 2514, Level 16, State 1:
Server 'XXX', Line 1:
Table Corrupt: Type id 56 (type name = 56) does not match between systypes and syscolumns

dbcc checkcatalog(<DB_name>,fixall) does not clear the errors.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL04 for Business Suite

Product

SAP Adaptive Server Enterprise 16.0

Keywords

2514, dbcc checkcatalog, tUDF, type, syscolumns, systypes, CDS, functions, 799064 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.