SAP Knowledge Base Article - Preview

3295425 - sp_sysmon reports 2849 error after upgrading ASE from 15.7 to 16.0 - ASE

Symptom

  • Any logins running sp_sysmon report error 2849:

Number (2849) Severity (16) State (1) Server (cmx6082) Procedure (sp_sysmon:333) EXECUTE AS OWNER procedures cannot be executed if created by an alias or with the SETUSER command when the procedure has SQL statements that reference objects across databases. Drop and recreate the procedure from a non-impersonated session

  •  sp_version shows the same version for installmaster as @@version shows for the dataserver binary.
  • Re-runnning installmaster as sa does not fix the 2849 error
  • sp_helpdb on sybsystemprocs shows the correct owner sa
  • sp_help on sp_sysmons shows correct owner as dbo and Object_statas as "execute as owner"
  •  Running the following query in sysbsystemprocs..sysobjects shows the following for sp_sysmon:

1> select uid, loginame from sysobjects where name = "sp_sysmon"   
2> go           

uid          loginame
1              login1


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.x

Product

SAP Adaptive Server Enterprise 16.0

Keywords

alias, execute as owner,  permission , 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.