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.