July 31, 2003 at 11:34 am
I'm getting the following error when trying to subscribe to a publication:
"Cannot insert the value NULL into column 'msrepl_synctran_ts', table 'hfnet1_0.dbo.fund_recent_assets'; column does not allow nulls. INSERT fails."
Using SQLServer2000, I am in control of the publication and subscribing database. I have copied the publication database and restored it to the subscription db before attempting to start the subscription. The snapshot is generated and then the applying begins. It always fails with the same error. I don't know why it would even be trying to insert NULL into the 'msrepl_synctran_ts' column.
Any help would be MUCH appreciated as I have no idea where to go from here!
Thank you so much!
-Sandy
August 2, 2003 at 9:16 am
MSrepl columns are added by replication, the problem is that it in this case the publisher doesn't expect to be inserting a value into that column. This happened because you did the restore rather than a snapshot. Delete the column from the subscriber and see what happens.
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply