Data conversion failed in SQL Server replication

Question

I am newbie to SQL Server. I have a transactional replication setup in my production environment. I am getting the below error while replicating from publisher to subscriber.

Conversion failed when converting the varchar value '* ' to data type int.
Error: 14151, Severity: 18, State: 1.

Kindly help me to fix this in replication setup.

what couldn't you understand in that error? `'* '` is not a valid data to cast from varchar to int. — Sankar, Jul 25 '17 at 04:41
I am new to sql server.So what i need to do fix this in replication @Sankar Raj — SujithTee, Jul 25 '17 at 04:44
if you are really not sure then try using try_parse to convert data from varchar to int. — ViKiNG, Jul 25 '17 at 04:47
for publisher and subscriber sql server 2008(SP4) @SankarRaj — SujithTee, Jul 25 '17 at 04:51

score 1 · Answer 1 · answered Jul 25 '17 at 04:57

1

Since you are using SQL SERVER 2008, You can use below query snippet to avoid this error

 SELECT
  CASE
    WHEN ISNUMERIC(@data) = 1 THEN CAST(@data AS int)
    ELSE NULL
  END

answered Jul 25 '17 at 04:57

Sankar

6,908
2
30
53

Data conversion failed in SQL Server replication

1 Answers1