SAP Knowledge Base Article - Preview

2000438 - master.dbo.spt_values does not have entry 'Create function' and 'Set Tracing' - 15.7 GA (Base Release) Only

Symptom

  • ASE 15.7 GA (base release).
  • 'Create Function' and 'Set Tracing' do not exist in spt_values.
  • The following two queries return 0 row:

    select * from master.dbo.spt_values where name='Create Function'
    go
    select * from master.dbo.spt_values where name='Set Tracing'
    go

  • The column 'number' in spt_values is associated with the column 'action' in sysprotects.  It indicates what permissions are granted to users. Missing ‘Create Function’ and ‘Set Tracing’ entries in spt_values cause integrity issues on spt_values and sysprotects.
     


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 GA Only

Product

SAP Adaptive Server Enterprise 15.7

Keywords

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.