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

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.