Symptom
- The following error occurred in ASE_Suite.log during upgrade. It's not HA environment.
MSG>>> 07-05-17 12:54:42 : Executing /opt/sybase/ASE-16_0/bin/updatease -D/opt/sybase -Stest...
MSG>>> 07-05-17 13:18:03 : Exit status = 4
ERROR>>> 07-05-17 13:18:03 : The installer could not update SAP ASE 'test'. Correct the errors described in output file '/opt/sybase/log/updatease.out', then run '/opt/sybase/ASE-16_0/bin/updatease -D/opt/sybase -Stest'. - In updatease.out, query 'dbcc ha_admin (' ', 'state_machine', 'halt')' got failed as below:
SAP Adaptive Server Enterprise message: 'Message number: 10353, Severity 14, State 23, Line 1
Server 'test'
Message String: You must have any of the following role(s) to execute this command/procedure: 'ha_role' . Please contact a user with the appropriate role for help.'.
Error in query: 'dbcc ha_admin (' ', 'state_machine', 'halt')'.
Open Client message: 'ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect'.
Open Client message: 'ct_cancel(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect'.
Open Client message: 'ct_cmd_drop(): user api layer: external error: The connection has been marked dead.'. - We can see upgrade has finished in database 'dbname' generated successfully in ASE error log.
00:0000:00000:00002:2017/07/05 13:38:49.68 server Upgrade has finished in database 'master'. ASE is now updating table level statistics for its system tables. Please be patient.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
HA,dbcc ha_admin , 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.