Error opening the LogReader

Niva Bupa Health Insurance Company Limited

• December 05, 2023 05:16

Hi ,

I made a connection with Oracle 19c and created some replications . It was working fine previously but now it is giving error that are below . Can you guys please help to resolve this issue. Thanks in advance.

Error opening the LogReader for connection 'MAXIMUSP_PROD' (Replication: 'MR_CONTRACT')

 

System.FormatException: Input string was not in a correct format.
   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
   at System.String.System.IConvertible.ToInt32(IFormatProvider provider)
   at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
   at m.a(Int32 A_0, Type A_1)
   at m.b(Int32 i)
   at jo.a(am A_0)
   at oi.d()
   at oi.a(Boolean& A_0)
   at ai.f()

1

• 

  Eric Weldon

  • December 18, 2023 03:47

  Hi Niva,

  For specific assistance, you should open a support ticket. From this error message, it looks like you are trying to convert a string to a number and if your data has non-numeric characters in it (like e, a through z, etc..) this will fail. You could either a) convert your data type to be nvarchar on your target instead of a number or b) filter out the records that cannot be converted (i.e. where field not like '%[a-z]%') on the replication. 

  0

Please sign in to leave a comment.