Symptom
Running sap_teardown on primary RMA, but it failed due to following error which can be seen in standby RMA log,
xxxx-05-23 08:40:19 [INFO ] [Thread-19386:20957][RMA] - [HADRDemoteASE ] - Executing 'sp_hadr_admin standby, 'force'' on the ASE at <hostname>:4901. xxxx-05-23 08:40:19 [ERROR] [Thread-19386:20957][RMA] - [HADRDemoteASE ] - Task Demote the ASE - Failed with error message - Unable to execute the command to demote the ASE '<SID>_Site1' on host 'Site1' to a standby site. xxxx-05-23 08:40:19 [ERROR] [Thread-19386:20957][RMA] - [HADRDemoteASE ] - Task Demote the ASE - Failed with Exception - Message: 'The packet size (32768) specified at login time is illegal. Legal values are between 512 and 16384.' Cause: ''. xxxx-05-23 08:40:19 [TRACE] [Thread-19386:20957][RMA] - [HADRDemoteASE ] - Task Demote the ASE - Failed with Stack Trace - The packet size (32768) specified at login time is illegal. Legal values are between 512 and 16384. com.sybase.jdbc4.jdbc.SybSQLWarning: The packet size (32768) specified at login time is illegal. Legal values are between 512 and 16384. Due to this error, sap_teardown fails, since primary ASE has been deactivated, but fails to demote, and HADR can not be disabled now, so it causes primary ASE unaccessible unless re-activating primary ASE manually again. xxxx-05-23 08:40:19 [INFO ] [Thread-19386:20957][RMA] - [HADRDemoteASE ] - Task Demote the ASE - State - Error xxxx-05-23 08:40:19 [INFO ] [Thread-19386:20957][RMA] - [TearDownHADR ] - Task Tear Down HADR - State - Error xxxx-05-23 08:40:19 [TRACE] [Thread-19386:20957][RMA] - [ConnectionManager ] - Terminate connection <936687992(com.sybase.jdbc4.jdbc.SybConnection@38c5f494)>: jdbc_sybase_Tds_<hostname>_4901_master_<hostname>_4901_DR_admin_5d533d10485697e3173a816d1affe3 (s/r/a/w/t/o) (42621/0/0/0/0/0) xxxx-05-23 08:40:19 [INFO ] [Thread-19386:20957][RMA] - [TearDownRS ] - Task Tear Down Replication - State - Error xxxx-05-23 08:40:19 [INFO ] [Thread-19386:20957][RMA] - [TearDownRS ] - Task Tear Down Replication - Time task started - Thu May 23 08:39:26 GMT+01:00 xxxx xxxx-05-23 08:40:19 [INFO ] [Thread-19386:20957][RMA] - [TearDownRS ] - Task Tear Down Replication - Time task ended - Thu May 23 08:40:19 GMT+01:00 xxxx
Read more...
Environment
SAP Adaptive Server Enterprise Always-on (HADR)
Product
SAP Replication Server all versions
Keywords
CR 829470, packet size, sap_teardown, sp_hadr_admin standby, cis packet size, max network packet size
, KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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.
SAP Knowledge Base Article - Preview