Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

arithmetic overflow when setting up replication

Status
Not open for further replies.

cocopud

Technical User
Jan 8, 2002
139
US
I am trying to set up replication but when I try and push the publication to the subscriber it says that is was successful, but as soon as it starts I get the following error in the log reader:

arithmetic overflow error converting expression to data type int. The step failed.

I have searched on info about this error, but can't find anything regarding replication.

We are using SQL Server 7 and had this set up correctly last week, but then the subscriber went down so I am trying to set it up again. Also, I am able to get to the subscriber by replication from another test system.

Does anyone know what this means and how to fix it? Thank you



 
I also found this info, but we don't have any tables with over 80,000 rows. Also, I cannot find the sp_MSestimatesnapshotworkload stored procedures, but I may not be looking in the right place
-----
The initial snapshot generation may fail with the following error message if the rowcount of a published table is in the hundreds of millions:

SourceTypeId = 5
SourceName = SQL2K\Named1
ErrorCode = 8115
ErrorText = Arithmetic overflow error converting expression to data type int.
Repl Agent Status: 6
Disconnecting from Publisher 'SQL2K\Named1'
The error message is more prominent when the published tables contain 100 million or more rows.
CAUSE
This error occurs when the rowcount of the table is greater than 100 million because the value that is being passed to a variable in the sp_MSestimatesnapshotworkload stored procedure exceeds the size limitations for an int data type, which then causes an overflow error to occur
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top