March 11, 2008 at 11:50 pm
Hi all,
I have a grave problem while setting up my transactional replication between two servers.
The Snapshot history shows that it has completed generation successfully. The distribution_history shows that the delivery of the snapshot was done successfully. But the next message shows -
Delivered snapshot from the 'unc\SON1834_TDB4X_TEST_10MAR_RPLN_TDB4X_TEST_10MAR\20080311190730\' sub-folder in 5347578 milliseconds
Error executing a batch of commands. Retrying individual commands.
Error converting data type varchar to bit.
The log file viewer shows -
Date 3/12/2008 10:15:33 AM
Log Job History (SON1834-TDB4X_Test_10Mar-rpln_TDB4X_Test_10-SON1841-TDB4X_Test_10Mar-D1FBEDD3-A47F-4BB2-90A2-6F227F0A5E7B)
Step ID 1
Server SON1841
Job Name SON1834-TDB4X_Test_10Mar-rpln_TDB4X_Test_10-SON1841-TDB4X_Test_10Mar-D1FBEDD3-A47F-4BB2-90A2-6F227F0A5E7B
Step Name Run agent.
Duration 00:01:28
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
2008-03-12 04:46:15.724 Disconnecting from Subscriber 'SON1841'
2008-03-12 04:46:15.724 Connecting to Subscriber 'SON1841'
2008-03-12 04:46:15.724 Error executing a batch of commands. Retrying individual commands.
2008-03-12 04:46:35.772 Disconnecting from Subscriber 'SON1841'
2008-03-12 04:46:35.772 Connecting to Subscriber 'SON1841'
2008-03-12 04:46:35.772 Error executing a batch of commands. Retrying individual commands.
2008-03-12 04:47:00.820 Disconnecting from Subscriber 'SON1841'
2008-03-12 04:47:00.820 Connecting to Subscriber 'SON1841'
2008-03-12 04:47:00.835 Error executing a batch of commands. Retrying individual commands.
2008-03-12 04:47:01.054 Agent message code 8114. Error converting data type varchar to bit.
2008-03-12 04:47:01.367 Category:COMMAND
Source: Failed Command
Number:
Message: if @@trancount > 0 rollback tran
2008-03-12 04:47:01.367 Category:NULL
Source: Microsoft SQL Native Client
Number: 8114
Message: Error converting data type varchar to bit.
And ultimately I suppose the replication fails. Please help.
Thanks in advance.
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
March 12, 2008 at 8:41 am
It seems to be an informational error in converting data type. When you setup your replication, did you use Create New Schema? If so, the replication will re-create any existing objects in subscribers to keep consistency between publisher/distributor and the subscribers.
March 13, 2008 at 1:36 am
I deleted the subscription and publication and disabled distributor. Then I have setup the replication once more. Now a different problem seems to crop up.
The snapshot is delivered and then it gives an error as follows -
Delivered snapshot from the 'unc\SON1834_TDB4X_TEST_10MAR_RPLN_TDB4X_TEST_10MAR\20080312195924\' sub-folder in 5156812 milliseconds
Error executing a batch of commands. Retrying individual commands.
Procedure or function sp_MSdel_dboATI_Markets has too many arguments specified.
How can this happen? Please help.
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply