SQL Replication Error

[sethmo]

I have a SQL 2005 database that replicates two a second server, also SQL Server 2005 that is getting an error. I do not now what table or field the error is coming from. The error is:

Error from Replication Monitor on the Publisher:
Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x00004F1C00000830004200000000, Command ID: 3)

Error messages:
Conversion failed when converting the varchar value '124.' to data type int. (Source: MSSQLServer, Error number: 245)
Get help: http://help/245
Conversion failed when converting the varchar value '124.' to data type int. (Source: MSSQLServer, Error number: 245)
Get help: http://help/245

Any suggestions? I looked at all the tables and fields being replicated at the time for both publisher and subscriber, but do not see any errors in the data.

 

[calebb]

Transactional replication? Try running SQL Server Profiler on the subscriber (use a text filter for '124.' or just capture all transactions and search for this value afterwards - then attempt to resume replication). This might give you an idea of which table to look at.


If replication is currently broken and hanging on this step, you might be able to find the transaction in a DMV on the publisher:

SELECT transaction_id
FROM sys.dm_tran_current_transaction
WHERE transaction_sequence_num = 0x00004F1C00000830004200000000;

If you're able to find the transaction_id, then check sys.dm_tran_database_transactions to get the LSN.

With the LSN, you can find the query that isn't replicating in your transaction logs.