SAP Knowledge Base Article - Preview

3167303 - Error section of the Replay report not breaking down the counts - SAP ASE

Symptom

  • Replay from Workload Analyzer (WLA) is showing large number of errors in analysis report
  • The Total Count in Errors show 62,717,403 for each error number, but the number of errors displayed in the list is only about 51,000
    • Based on the sp_sysmon and hotbufs are showing high usage of sysmessages
      SYSMON:
      Cache: Default Data Cache
                                        per sec      per xact       count  % of total
        -------------------------  ------------  ------------  ----------  ----------
          Spinlock Contention               n/a           n/a         n/a       4.9 %

          Utilization                       n/a           n/a         n/a       4.2 %

          Cache Searches
            Cache Hits                  38614.9           4.9     1158446     100.0 %
               Found in Wash                0.0           0.0           0       0.0 %
            Cache Misses                    0.0           0.0           0       0.0 %

      HOTBUF:
       PRINTING HOT BUFFERS for Data Cache :default data cache in Descending Order at the Cache Level.
       1.    pageno=1442 dbid=1 ptnid=36 indid=0 objname=sysmessages version=1 cache_spin=44555568 buf_spin=0

       2.    pageno=329 dbid=1 ptnid=36 indid=1 objname=sysmessages version=1 cache_spin=38577640 buf_spin=0

       3.    pageno=1441 dbid=1 ptnid=36 indid=0 objname=sysmessages version=1 cache_spin=3673611 buf_spin=0

       4.    pageno=1970 dbid=1 ptnid=36 indid=0 objname=sysmessages version=1 cache_spin=174926 buf_spin=0
  • The 62 million seems to be correct, but the details in the Error report is not reflecting all the information. 
    • Application Report is showing that there is clearly issues with some of the applications, if all the errors are added up from the “number of errors” reported the result is  exactly what is being reported in the Error section.
    • Sessions also adds up to the same 62,716,403 in the “number of errors” column


Read more...

Environment

SAP Adaptive Server Enterprise 16.0 

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.