Hi All,
I am experiencing some issues while adding articles at the time of creating publications in SQL Server replication in SQL 2014, Which is given below (Also attaching some screenshots related to this error) :-
- Adding article 185 of 185 (Error). Messages - SQL Server Management Studio could not create article 'myDemoTable'. (New Publication Wizard). ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) - Cannot insert the value NULL into column 'table_id', table 'myDemoDb.dbo.IHarticles'; column does not allow nulls. INSERT fails. Changed database context to 'myDemoDb'.
The statement has been terminated. (Microsoft SQL Server, Error: 515)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.00.2269&EvtSrc=MSSQLServer&EvtID=515&LinkId=20476 (For this error, we set default value of table_id to 0, but this is not the best solution). - Adding article 185 of 185 (Error). Messages - SQL Server Management Studio could not create article 'myDemoTable'. (New Publication Wizard). ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. Microsoft.SqlServer.ConnectionInfo). Cannot insert the value NULL into column 'publisher_id', table 'myDemoDb.dbo.IHarticles'; column does not allow nulls. INSERT fails.Changed database context to 'myDemoDb'.The statement has been terminated. (Microsoft SQL Server, Error: 515)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.00.2269&EvtSrc=MSSQLServer&EvtID=515&LinkId=20476 (For this error, we set default value of publisher_id to 0).
- Adding article 185 of 185 (Error). Messages - SQL Server Management Studio could not create article 'myDemoTable'. (New Publication Wizard). ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo). Update or insert of view or function 'dbo.sysarticlecolumns' failed because it contains a derived or constant field.Cannot generate a filter view or procedure. Verify that the value specified for the @filter_clause parameter of sp_addarticle can be added to the WHERE clause of a SELECT statement to produce a valid query.Changed database context to 'myDemoDb'.Msg 156, Level 15, State 1: Incorrect syntax near the keyword 'from'. (Microsoft SQL Server, Error: 4406)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.00.2269&EvtSrc=MSSQLServer&EvtID=4406&LinkId=20476
