SAP Knowledge Base Article - Preview

2240901 - Error 7952 "A text value with an invalid MAGIC NUMBER..." on system table spt_jext - SAP ASE

Symptom

  • The 'dbcc checktable (spt_jtext)' command reports Error 7952:

Msg 7952, Level 16, State 1:
Server 'SYBASE', Line 1:
A text value with an invalid MAGIC NUMBER has been found on page 2042, partition ID 249048892. Text values will not be checked for this table and the text page count will be inaccurate. Use DBCC FIX_TEXT to fix the text values.

  • This error is reported after the default character set in ASE changed to multi-byte from single-byte.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

dbcc, checkdb, master, text, charset, fix_text , KBA , 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.