SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Transactional replication - can't create publication


Transactional replication - can't create publication

Author
Message
Dave-739983
Dave-739983
SSC Rookie
SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)

Group: General Forum Members
Points: 48 Visits: 204
Hi all,

I have a newly created Windows 2008R2 (64bit) server with MSSQL 2012 standard edition installed, acting as it's own distributor.

I have just gone to create the first publication on this particular server and I am getting an error with the snapshot agent.
"A .NET Framework error occurred during execution of user-defined routine or aggregate "sp_scriptdropinsreconciliationproc_sqlclr":"
I can be pretty sure it has nothing to do with the subscription, because I didn't even get to that stage.

I have done some browsing and all that I can find is something about a known problem after applying the .Net update KB2840628...
the only problem is my server has not had the update applied.

Any help would be greatly appreciated.
David
RatanDeep Saha
RatanDeep Saha
Right there with Babe
Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)Right there with Babe (770 reputation)

Group: General Forum Members
Points: 770 Visits: 693
Run the below and paste the results .

Select * from sys.dm_clr_loaded_assemblies

select * from sys.dm_clr_task

Most of the CLR issues causes due to memory spike, .net DLLs supporting SQL to run are currupted.

The immediate solution will be restarting the SQL services.
david.bianco
david.bianco
SSC-Addicted
SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)

Group: General Forum Members
Points: 468 Visits: 1666
This occurred for us due to Windows Updates. A specific .NET update caused our replication and SharePoint systems to break. Uninstalling the update fixed it immediately.

The update that caused this issue in our case was KB2840628
Dave-739983
Dave-739983
SSC Rookie
SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)

Group: General Forum Members
Points: 48 Visits: 204
Hi sqldba725 and david.bianco

thank you both for your replies. I have fixed the problem... well I will say so far so good.

One of the possible cause I found on the internet was windows update KB2840628, the only problem was I did not have it installed.

Anyway to cut a long story short, I cloned the VM's involved and ran ALL the Windows updates to do with .Net Framework... tested and replication now works. I will spend some time of the next couple of days testing/reviewing before changing the actual production VM's. "fingers crossed"

Thanks for the replies greatly appreciated.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search