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
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.