July 17, 2008 at 3:15 am
HI all,
I am getting one error in my Replication. Replication model is
Transactional. I have setup of two servers
Server A--------> Publisher resides
Server B--------> Subscriber and distributor database resides
Issue is that after articles are getting replicated distributor job is failing to run.
Error message which I get daily is
Executed as user: DOMAIN\username. Error converting data type
nvarchar to
int. [SQLSTATE 42000] (Error 8114) Could not remove directory
'\\Server\DISTRIBUTOR\unc\dbname\20080710012702\'. Check the security
context of xp_cmdshell and close other processes that may be accessing
the
directory. [SQLSTATE 42000] (Error 20015) [Email address protected]
parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only
check rowcou: agent [Email address protected] parameter must be the
value
0,1, or 2. 0=7.0 compatible checksum. 1=only scheduled for retry. Could
not
clean up the distribution transaction tables. [SQLSTATE 01000] (Message
14152). The step failed
July 18, 2008 at 7:17 am
You have two errors.
1. Data type conversion. You need to check your data and see whether or not they are convertible.
2. Try to avoid other users accessing your unc path.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply