SAP Knowledge Base Article - Preview

1968540 - Errors reported after upgrading - SAP ASE

Symptom

  • Upgrading ASE with Traceflag (TF) 2810 enabled
  • Intallmaster fails with the following errors:

Updating Adaptive Server 'SERVERNAME'...
Running installmaster script...
installmaster: 10% complete.
installmaster: 20% complete.
installmaster: 30% complete.
installmaster: 40% complete.
installmaster: 50% complete.
installmaster: 60% complete.
installmaster: 70% complete.
installmaster: 80% complete.
installmaster: 100% complete.
Error fetching results for query: '
/* Drop and recreate the control table used by sp_monitor */
declare @retval int
exec @retval = sp_monitor_crt_mon_config @do_drop = 1
if (@retval != 0)
        select syb_quit()
'.  Error fetching results for query: '
/* Drop and recreate the control table used by sp_monitor */
declare @retval int
exec @retval = sp_monitor_crt_mon_config @do_drop = 1
if (@retval != 0)
        select syb_quit()
'. 

Another error when running installmaster:

Installing sp_monitor_enable
Msg 2714, Level 16,
State 1:Server 'myserver', Procedure 'sp_monitor_crt_mon_config',
Line 47:There is already an object named 'mon_config' in the database.
Installing sp_monitor_disable_usageInstalling sp_monitor_disable
Installing sp_monitor_disable_usage

If these errors are ignored it may periodically give errors:
sp_monitor
go

Msg 2849, Level 16, State 1:

Server 'myserver', Procedure 'sp_monitor', Line 194:
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.
(return status = -6)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • Sybase Adaptive Server Enterprise (ASE) 15.0

Product

SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise 15.0

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.