0

I've got 2 databases with the exact same design and I'm receiving an error from SymmetricDS when trying to insert specific records from the Active database to the Passive.

I'm getting the following error: 'Numeric overflow in conversion of value 211 to type Tinyint'. The data has no problem going into the Active database from our application, but the replication to the Passive is raising an error. Also, I'm able to insert the same values in the passive database manually.

Is SymmetricDS doing some type of data conversion during the insert? I'm trying to understand where and why this could be happening.

Thanks, Kaleb

Kaleb
  • 1
  • 2
  • more can be deduced about the problem from symmetricds's logs on the target database. you'll see the exact insert statement and the concrete data – Boris Pavlović Jan 08 '15 at 06:15
  • From what I can gather there is an issue with the default behaviour of how TINYINT is handled by SQL Server (0 to 255) and JDBC (-128 to 127). I am able to take the insert statement from the log and run it just fine in SSMS. – Kaleb Jan 08 '15 at 19:56
  • If nothing else you can implement your own 'DatabaseWriterFilterAdapter` and manipulate the data so it's successfully inserted by JDBC – Boris Pavlović Jan 09 '15 at 10:01
  • 1
    I was also talking to support about this. Confirmed as a new bug and they already have a fix that will be built in the next point release which should be early this week. Thanks Boris. – Kaleb Jan 11 '15 at 19:56
  • 2
    This has been taken care of in version 3.7.1. – Kaleb Jan 14 '15 at 02:19

0 Answers0