SAP Knowledge Base Article - Preview

2463960 - timeslice error in stu_findslot() - SAP ASE

Symptom

  • SAP ASE processes like REORG, UPDATE STATISTICS or CREATE INDEX on hyper-partitioned tables, terminate.
  • Corresponding error in the ASE errorlog is a timeslice error in the module stu_findslot() together with a stack trace:

timeslice -1501, current process infected at 0x10836de (stu_findslot+0x15e)

  • The stack trace includes the following functions:

stu_findslot
stat_frequency_reduction
stat_tuning_factor_reduction
stio_xformvirtual
st_writestatistics
sysstatistics_write

  Note: A complete stack trace is available under Attachments.

  • The optdiag utility shows one or more histograms with a step count in the thousands for the table involved.
  • On SAP BW systems, the offending tables are Infocube Fact tables contain more than 1000 partitions


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE) 15.7 and 16.0
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Warehouse

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition

Keywords

timeslice, "update index statistics", partitions, Infocube, compression, partitioned, hyper-partitioned, "histogram steps", CR807622, CR#807622, 807622 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Bug Filed

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.