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.