Symptom
- Use ASE Always-on Option (or HADR)
- A database name is a reserved word of ASE, SRS or ASA. For example, "ADMIN" is SRS reserved word and "refresh" is ASA (SQL Anywhere) reserved word.
- Try to add the "ADMIN" database to HADR, get incorrect syntax error
sap_update_replication add_db, ADMIN
go
TASKNAME TYPE VALUE
-------------------------------------- ----------------------------- ------------------------------------------------------------------------------------------------------
.....................................
CreateConnection Failing Command create connection to HA1_Site1.ADMIN set error class rs_sqlserver_error_class set function string class rs_sqlserver_function_class set username to DR_maint set password to '********' with log transfer on
CreateConnection Failing Command Return Code 2057
CreateConnection Failing Command Error Message Failed to create the connection from the Replication Server to the Database Server 'HA1_Site1.ADMIN'.
CreateConnection Failing Exception Message: 'Line 1, character 32: Incorrect syntax with the keyword 'ADMIN'.' Cause: ''.
.................................... - Run sap_host_available, get sytax error if the database is named as "refresh" which ASA reserved word
sap_host_available Site1
go
TASKNAME TYPE VALUE
-------------------------------------- ----------------------------- ------------------------------------------------------------------------------------------------------
...........................................................HostAvailable Failing Command rs_zeroltm SAP_CDS1DBALN_R1, refresh
HostAvailable Failing Command Return Code 102
HostAvailable Failing Command Error Message Error zeroing LTM Marker for ASE Server 'SAP_Site1_R1', database 'refresh'.
HostAvailable Failing Exception Message: 'SQL Anywhere Error -131: Syntax error near 'SAP_Site1_R1' on line 1' Cause: ''.
...........................................................
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)
- SAP Replication Server (SRS) 16.0
Product
Keywords
key word, HADR, reserved words, repserver. , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , 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