Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rcurrey
Starting Member
30 Posts |
 Posted - 2007-02-01 : 16:40:15
|
| We have backed up and restored 3 sql2k db's into a dev environment (win2k3) and are having issues getting a specific publication up and running. The table being replicated is approx 150,000,000 rows (46 bytes/row) with a char(18) col, 5 int cols, and a datetime col. When the article is initialized, snapshot agent fails with the error "Arithmetic overflow error converting expression to data type int.". Weird part is, this is all configured and working in Production.Any ideas???Thanks,Rich |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-01 : 17:03:23
|
| Check the DDL of the table on the subscription database. Perhaps the table wasn't created correctly, meaning an incorrect data type was used. If that's the case, fix the table, then run the snapshot making sure to select the option to not drop the table, just to copy the data over.Tara Kizer |
 |
|
|
rcurrey
Starting Member
30 Posts |
Posted - 2007-02-02 : 08:16:45
|
| Tara,Thanks for the response, but the table is being dropped/recreated on initialization. Also, the snapshot isn't being created, it's failing on the snapshot agent, not the distribution agent. I'm really stumped here, cause DDL shows that the tables are identical, even to the point that I scripted out the create on the source db and ran it on the target db.Thanks,Rich |
|
|
|
rcurrey
Starting Member
30 Posts |
Posted - 2007-02-05 : 08:47:50
|
| Thanks for the help. Issue ended up being a version issue. Applying SP4 to the instance resolved the problem.Thanks,Rich |
|
|
|
|
|
|
|
|
Transactional Replication - Snapshot creation is f