SAP Knowledge Base Article - Preview

2113798 - Tempdb error 1105 - Sysstatistics table of tempdb gets filled with entries which have no corresponding entries in sysobjects - SAP 15.7 SP100

Symptom

  • Error 1105 occurs in tempdb as space in tempdb gets filled up automatically
  • sysstatistics keeps growing with entries which have no corresponding entries in sysobjects.
  • The following query can be executed in the problematic temporary database to ensure that the above symptom is shown
               

select count(*) from sysstatistics where id NOT IN (select id from sysobjects)
            go
If this returns any results, the symptom is shown.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 SP 110 onwards.

Product

SAP Adaptive Server Enterprise 15.7

Keywords

phantom entries, capture missing statistics , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.