Transactional Replication Snapshot Issues

• swoozie

  SSCrazy

  Points: 2770

  More actions

  February 1, 2016 at 11:20 am

  #307514

  Transactional Replication Snapshot Issues

  History:

  Friday New release, some schema Changes and Object additions and subtractions.

  changes were not picked up by replication

  Decided to rebuild the snapshot

  At 8:30pm ish something happened and the snapshot failed and permissions disappeared. had to rerun Group Policy which fixed that.

  restarted the Snapshot Creation

  then when everything gets to 97% in the rep Monitor, these errors pop up. the 1st is not displayed in rep Monitor only 2nd is

  I have 2 different errors occurring on my snapshot recreation.

  Message: A .NET Framework error occurred during execution of user-defined routine or aggregate "FunctionName": System.OverflowException: Arithmetic Overflow. System.OverflowException:

  at System.Data.SqlTypes.SqlDecimal..ctor(Double dVal)

  at #####.Core.SqlClr.Function.FunctionName(SqlString input) . Stack:

  Message: Failed to read from server

  Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)

  at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause)

  at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)

  at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()

  at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper()

  The process runs to about 97% then fails the "Failed to read from server" error.

  I have Checked the Drive Sizes for the Translogs and the snapshot location

  I have checked the permissions for the same items

  I have tried excluding the function from the snapshot

  I have rebuilt the process, reconfigured the process, etc.... several times.

  I have check the NIC, Speed, Duplex differences

  I have reviewed the function above, and it was already present in the previous snapshop.

  I have this weird feeling the answer shold be as plain as the nose on my face, but I can' seem to find it. Any help would be appreciated.