Replication Transaction Sequence Failing the Distribute data to Subcribers

Error: Command attempted:

if @@trancount > 0 rollback tran (Transaction sequence number: 0x00153E8800014B23001C00000000, Command ID: 3)
Error messages: Cannot insert the value NULL into column 'PageUID', table 'CMSPublished.dbo.cmsPage'; column does not allow nulls. UPDATE fails. (Source: MSSQLServer, Error number: 50000)

_______________________________________________

Resolution Guide line: Find the Trasaction: use [distribution]

go SELECT * FROM msrepl_commands WHERE xact_seqno = 0x00153E8800014B23001C00000000 AND command_id = 3

_______________________________________________

See more details

EXEC SP_BROWSEREPLCMDS @xact_seqno_start = '0x00153E8800014AB5001200000000', @xact_seqno_end = '0x00153E8800014AB5001200000000', @publisher_database_id = 22, -- this value can be found from the above query @article_id = 159, -- this value can be found from the above query @command_id= 3 -- this value can be found from the above query

Notice the transaction as

CALL [dbo].[sp_MSins_dbocmsPageContent] (4029206,278142,235770,15621,15761,1,0,NULL,NULL,NULL,NULL,1,2014-06-03 12:24:00,2014-06-03 12:24:00,1,'',0)} insert into ehcms..cmsContent (ContentID, ContentStatusID, ContentTypeID, SourceProductID, TrackingID, IsActive, DateCreated, DateModified, ModifiedBy)

Now what? You have 2 options Either you insert the data to the publisher table associate with that Your second option is to delete the transaction from the msrepl_commands table

__________________________________________

delete FROM msrepl_commands WHERE xact_seqno = 0x00153E8800014B23001C00000000 AND command_id = 3

______________________________________________

Email me in case you need help to understand the process.