Symptom
- When executing a change using sp_configure, receive an error:
sp_configure 'enable real time messaging', 1
go
Msg 5849, Level 16, State 1:Server 'servername', Procedure 'sp_configure', Line 1312:Verification failed for parameter 'enable real time messaging'. - dbcc sqltext also shows:
Executing procedure: sp_configure Subordinate
SQL Text: select @status = case
when (@is_equal = 1) then 1
else config_admin(@cmd, @confignum, @configvalue, @value, NULL, @configvalue2)
end
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
QUERY PLAN FOR STATEMENT 300 (at line 1312).
STEP 1 The type of query is SELECT.
Total estimated I/O cost for statement 300 (at line 1312): 0.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
sp_configure error, Msg 5849, enable real time messaging, server.cfg file, configuration update, verification failed, database platform, sp_configure commands, error message, system administrator role, DBCC execution, server reboot, parameter verification , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
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.
SAP Knowledge Base Article - Preview