Troubleshooting guide

The majority of configuration values required to create and initialize a Replication Agent
can be recorded and stored in a resource file. Using a resource file provides a means to
record or retain the configuration information for a Replication Agent instance, allowing
an instance to be removed and re-created.
The Microsoft SQL Server resource file template is at %SYBASE%\RAX-15_5\init
\mssql.rs.
2.
Create an instance resource file:
Copy the resource file template %SYBASE%\RAX-15_5\init\mssql.rs to another
file, for example, myra.rs.
Change the values assigned to properties in the resource file so they match the values
required for your environment. The majority of these values are host, port, user, and
password information for the Microsoft SQL Server, Replication Server, and RSSD
connections.
• Set the value of rs_source_ds to the value you chose for rax and pds in previous
procedures.
• Set the value of rs_source_db to the value you chose for test and pdb in previous
procedures.
• When you create a Replication Agent instance with a resource file:
• The asa_password configuration parameter value must not contain single quotes,
double quotes, or a semicolon.
• The pds_username and pds_password configuration parameter values must not
contain single or double quotes if the create_pds_username parameter is set to
yes.
The resource file is self-documenting, with each parameter described. See the Replication
Agent Administration Guide .
Warning! The combined values of rs_source_ds and rs_source_db must match the
{pds.pdb} values of the Replication Server primary connection name.
Table 3. Resource File Parameters
Parameter Description Example values
instance name Any valid name. myra
admin_port Port number that Replication Agent uses. 9030 (if in use, select a different
port number)
ltm_admin_user User name for administering the Replication
Agent instance.
sa
CHAPTER 5: Microsoft SQL Server-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 67