SAP Knowledge Base Article - Preview

2970277 - HADR: syntax error while using reserved word of components as database name - SRS

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

SAP Adaptive Server Enterprise all versions ; SAP Replication Server 15.7

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.