rep agent not starting

Hi All,

I am doing some testing on replication server and having a tough time
in starting the rep agent . Please find the details
Replication server = PRIM_REP
Primary DB = archive_data
RSSD = PRS_RSSD
Secondary DB = RRS_DB
Rep agent user = PRIM_REP_ra
Rep agent user's password = PRIM_REP_ra_ps


Primary DB, replication server and RSSD is residing on one data server
i.e facetupg
Replicate DB on another data server = facetmrg

Below attaching the output of all logs and commands which I ran .
Please advise where I am going wrong.



COMMANDS GIVEN AT REPLICATION SERVER

STEP 1 : Make sure Rep agent user can connect to replication server.
facetupg(LOCAL:rep125)/home/rep125 $ isql -UPRIM_REP_ra
-PPRIM_REP_ra_ps -SPRIM_REP
1>

STEP 2 : Enabling the log transfer .
1> alter connection to facetupg.archive_data
2> set log transfer to on
3>

STEP 3 : Granting connect source permissions to Rep agent user
(PRIM_REP_ra)
1> grant connect source to PRIM_REP_ra
2>
Permission granted to user 'PRIM_REP_ra'.

COMMANDS GIVEN ON PRIMARY DATA SERVER

STEP 1 : Enabling rep agent
sp_configure 'enable rep agent threads', 1

STEP2 : Configuring database for replication
1> use archive_data
2>
1> sp_config_rep_agent
"archive_data",'enable',"PRIM_REP","PRIM_REP_ra","PRIM_REP_ra_ps"
2>

STEP3 : Started rep agent for the database.
1> sp_start_rep_agent "archive_data"
2>
Replication Agent thread is started for database 'archive_data'.
(return status = 0)

===========================================================================================
Outputs of log files

1> select * from sysservers
2>
srvid srvstatus srvname srvnetname
srvclass srvsecmech
------ --------- ------------------------------
-------------------------------- --------
------------------------------
0 8 facetupg facetupg
0 NULL
1 8 SYB_BACKUP facetupg_back
7 NULL
2 8 facettst facettst
7 NULL
3 8 local facetupg
7 NULL

(4 rows affected)
1>use PRS_RSSD
2>
1> select * from rs_users
2>
username uid password
permissions use_enc_password enc_password
------------------------------ ------------------
------------------------------ ----------- ----------------
--------------------
PRIM_REP_id_user 0x0100006502000068 PRIM_REP_id_passwd
0 0 NULL
PRIM_REP_ra 0x0100006502000067 PRIM_REP_ra_ps
2 0 NULL
PRIM_REP_rsi 0x0100006502000066 PRIM_REP_rsi_ps
2 0 NULL
PRS_RSSD_prim 0x0100006502000065 PRS_RSSD_prim_ps
10 0 NULL
sa 0x0000000002000001 NULL
1 0 NULL

1>use PRS_RSSD
2>
1> select * from rs_maintusers
2>
destid username password
use_enc_password enc_password
----------- ------------------------------
------------------------------ ----------------
---------------------------------------
101 PRS_RSSD_maint PRS_RSSD_maint_ps
0 NULL
102 archive_data_maint archive_data_maint_ps
0 NULL

(2 rows affected)


1> admin who
2>
Spid Name State Info

---- ---------- --------------------
----------------------------------------
13 DSI EXEC Awaiting Command 101(1) facetupg.PRS_RSSD

8 DSI Awaiting Message 101 facetupg.PRS_RSSD

12 SQM Awaiting Message 101:0 facetupg.PRS_RSSD

21 DSI EXEC Awaiting Command 102(1) facetupg.archive_data

20 DSI Awaiting Message 102 facetupg.archive_data

24 DIST Awaiting Wakeup 102 facetupg.archive_data

25 SQT Awaiting Wakeup 102:1 DIST facetupg.archive_data

23 SQM Awaiting Message 102:1 facetupg.archive_data

19 SQM Awaiting Message 102:0 facetupg.archive_data

REP AGENT Down facetupg.archive_data

9 dSUB Sleeping

6 dCM Awaiting Message

7 dAIO Awaiting Message

10 dREC Sleeping dREC

11 dSTATS Sleeping

29 USER Active sa

5 dALARM Awaiting Wakeup


Primary Dataserver LOG

04:00000:00020:2005/11/03 09:22:07.91 server Started Rep Agent on
database, 'archive_data' (dbid = 6).
04:00000:00020:2005/11/03 09:22:07.94 server RepAgent(6): Received the
following communications error message: Msg 06080503: ct_con
nect(): directory service layer: internal directory control layer
error: Requested server name not found..
04:00000:00020:2005/11/03 09:22:07.94 server Error: 9214, Severity:
16, State: 0
04:00000:00020:2005/11/03 09:22:07.94 server RepAgent(6): Failed to
connect to Replication Server. Please check the Replication Ser
ver, username, and password specified to sp_config_rep_agent. RepSvr =
PRIM_REP, user = PRIM_REP_ra).
04:00000:00020:2005/11/03 09:22:07.94 server Error: 9261, Severity:
20, State: 0
04:00000:00020:2005/11/03 09:22:07.94 server RepAgent(6): This Rep
Agent Thread is aborting due to an unrecoverable communications
or Replication Server error.
04:00000:00020:2005/11/03 09:22:07.94 server Rep Agent Thread for
database 'archive_data' (dbid = 6) terminated abnormally with err
or. (major 92, minor 61)
05:00000:00023:2005/11/03 09:32:40.72 server Started Rep Agent on
database, 'archive_data' (dbid = 6).
05:00000:00023:2005/11/03 09:32:40.72 server RepAgent(6): Received the
following communications error message: Msg 06080503: ct_con
nect(): directory service layer: internal directory control layer
error: Requested server name not found..
05:00000:00023:2005/11/03 09:32:40.72 server Error: 9214, Severity:
16, State: 0
05:00000:00023:2005/11/03 09:32:40.72 server RepAgent(6): Failed to
connect to Replication Server. Please check the Replication Server,
username, and password specified to sp_config_rep_agent. RepSvr =
PRIM_REP, user = PRIM_REP_ra).
05:00000:00023:2005/11/03 09:32:40.72 server Error: 9261, Severity:
20, State: 0
05:00000:00023:2005/11/03 09:32:40.72 server RepAgent(6): This Rep
Agent Thread is aborting due to an unrecoverable communications or
Replication Server error.
05:00000:00023:2005/11/03 09:32:40.72 server Rep Agent Thread for
database 'archive_data' (dbid = 6) terminated abnormally with error.
(major 92, minor 61)


Interface File

facetupg
master tcp ether facetupg 3300
query tcp ether facetupg 3300

facetupg_back
master tcp ether facetupg 3400
query tcp ether facetupg 3400

facetmerge
master tcp ether facetmrg 4101
query tcp ether facetmrg 4101

PRIM_REP
master tcp ether facetupg 4501
query tcp ether facetupg 4501

PRS_RSSD
master tcp ether facetupg 3300
query tcp ether facetupg 3300

REPLICATION LOG

I. 2005/11/01 17:38:34. SMP capability is set to : 'off'
I. 2005/11/01 17:38:34. Server using Open Server version Sybase
Server-Library/12.5.1/P/DRV.12.5.1.0/hpux/HP-UX 11.0 Native Threads/
BUILD1251-004/OPT/Mon Nov 10 18:20:57 2003
I. 2005/11/01 17:38:34. Server using Open Client version Sybase
Client-Library/12.5.1/P/DRV.12.5.1.0/hpux/HP-UX 11.0 Native Threads/
BUILD1251-004/OPT/Mon Nov 10 18:15:37 2003
I. 2005/11/01 17:38:34. Server site id is '16777317'.
I. 2005/11/01 17:38:34. Embedded database id is '101'.
I. 2005/11/01 17:38:35. The site version has been set to '1260'.
W. 2005/11/01 17:38:35. WARNING #6131 GLOBAL RS(GLOBAL RS) -
qm/sqmsp.c(2689)
Replication Server has no partitions.
I. 2005/11/01 17:38:35. Replication Server 'PRIM_REP' is started.
I. 2005/11/01 17:38:35. The DSI thread for database 'facetupg.PRS_RSSD'
is started.
I. 2005/11/01 17:38:35. SQM starting: 101:0 facetupg.PRS_RSSD
I. 2005/11/01 17:38:36. Open partition '/home/rep125/stabledev/p1.dat'
with sqm_write_flush 'on'.
I. 2005/11/01 17:38:53. Partition 'P1' is added.
I. 2005/11/02 09:56:12. SQM starting: 102:0 facetupg.archive_data
I. 2005/11/02 09:56:12. The DSI thread for database
'facetupg.archive_data' is started.
I. 2005/11/02 10:35:36. SQM starting: 102:1 facetupg.archive_data
I. 2005/11/02 10:35:36. DIST for 'facetupg.archive_data' is Starting
E. 2005/11/02 10:36:44. ERROR #14024 USER(sa) - /execint.c(1221)
Executor does not allow the entered command in the current
mode.
E. 2005/11/02 10:46:25. ERROR #14024 USER(PRIM_REP_ra) -
/execint.c(1221)
Executor does not allow the entered command in the

.