Troubleshooting guide
ra_admin init
Your Replication Agent instance is now running and has been initialized.
Creating a Replication Server Connection to the Primary Database
Create a Replication Server connection to the primary database.
1.
In Replication Server, create a connection to the primary Microsoft SQL Server database:
create connection to pds.pdb
using profile rs_rs_to_msss_ra;standard
set username muser
set password mpwd
with log transfer on, dsi_suspended
go
where:
•
pds
is the value of the rs_source_ds parameter specified in Replication Agent.
•
pdb
is the value of rs_source_db specified in Replication Agent.
•
muser
is the maintenance user for the primary Microsoft SQL Server database.
•
mpwd
is the maintenance user password.
For information about the maintenance user, see the
Replication Server Heterogeneous
Replication Guide > Sybase Replication Products > Replication Server > Database
Connections > Maintenance User Purpose
.
2.
Use admin show_connections, 'primary' to display the primary connection you created.
Verifying the Replication Agent Replicating State
Verify the replicating state of Replication Agent.
1.
Enter:
resume
go
If the Replication Agent successfully transfers to a replicating state, you see:
State Action
----------- --------------------------
REPLICATING Ready to replicate data.
The Replication Agent goes to the REPLICATION DOWN state if an error occurs:
isql –Usa –Psa_pass –SSAMPLE_RS
1> resume
2> go
Msg 32000, Level 20, State 0:
Server 'myra', Procedure 'resume', Line 1:
Command <resume> failed - Desired state <REPLICATE>
could not be achieved. Current state: <REPLICATION
DOWN>
2.
The ra_status command returns the state of the Replication Agent. It is good practice to
verify that the Replication Agent remains in replicating state, even after the resume
command executes successfully.
CHAPTER 5: Microsoft SQL Server-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 73