Troubleshooting guide

EXEC Suspended 103(1) pds.pdb
DSI Suspended 103 pds.pdb
24 DIST Awaiting Wakeup 103 pds.pdb
25 SQT Awaiting Wakeup 103:1 DIST pds.pdb
23 SQM Awaiting Message 103:1 pds.pdb
22 SQM Awaiting Message 103:0 pds.pdb
62 REP AGENT Awaiting Command pds.pdb
Testing Replication
When you finish setting up the replication system, test that replication works as intended.
1.
Connect to the primary Microsoft SQL Server database as a regular user, rather than as the
maintenance user. Make sure the regular user also exists in the replicate database.
2.
At the primary Microsoft SQL Server database, create a table named ptab1 to replicate:
CREATE TABLE ptab1
(idno int PRIMARY KEY,
name varchar(20));
3.
Grant permissions to any new or existing object to be replicated in the primary database:
grant all on ptab1 to public;
4.
Connect to Replication Agent through isql, and mark the ptab1 table for replication:
pdb_setreptable ptab1, mark
go
5.
In Replication Agent, create a replication definition against the primary Microsoft SQL
Server database:
1> rs_create_repdef ptab1
2> go
Table/Procedure Name RepDef Name Status
----------------------- -------------- --------
<MSSQLTableOwner>.PTAB1 "<repdefname>" Created
(1 row affected)
Record the name of the replication definition for use later.
6.
At the replicate SAP HANA database instance, create a table named PTAB1:
CREATE TABLE <tableowner>.PTAB1
(IDNO INT PRIMARY KEY,
NAME VARCHAR(20));
Note: SAP HANA database is not case-sensitive and uses uppercase characters if
lowercase characters are provided.
If an owner is not specified with the tablename, the owner of the table— <tableowner> —is
the user that is signed on at the time the table is created.
7.
Grant permissions to any new or existing object to be replicated in the replicate database so
that the Replication Server maintenance user can update this table:
CHAPTER 5: Microsoft SQL Server-to-SAP HANA Database Replication Setup
Quick Start Guide for SAP HANA Database 75