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 for Me (Login required).

Search for additional results

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