x

HI am getting below error while setting up transactional replication in Sql server 2012..can anyone help

Error messages: Source: Microsoft.SqlServer.ConnectionInfo Target Site: System.Data.SqlClient.SqlDataReader GetExecuteReader(System.Data.SqlClient.SqlCommand) Message: An exception occurred while executing a Transact-SQL statement or batch. Stack: at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command) at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query, SqlCommand& command) at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query) at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result) at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData() at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci) at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String propname, Boolean useDefaultValue)
at Microsoft.SqlServer.Management.Smo.PropertyCollection.RetrieveProperty(Int32 index, Boolean useDefaultOnMissingValue) at Microsoft.SqlServer.Management.Smo.PropertyCollection.GetValueWithNullReplacement(String propertyName, Boolean throwOnNullValue, Boolean useDefaultOnMissingValue) at Microsoft.SqlServer.Management.Smo.Index.get_IndexKeyType() at Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.TrimLogBasedArticleObjectForScripting(TransArticleWrapper articleWrapper, Table smoTable) at Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.GetTrimmedArticleScriptingBundle(ArticleScriptingBundle articleScriptingBundle) at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.GetTrimmedArticleScriptingBundleTimedWrapper(ArticleScriptingBundle articleScriptingBundle) at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.DoScripting() at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.DoScripting() at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot() at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun() at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: Microsoft.SqlServer.ConnectionInfo, Error number: 0) Get help: http://help/0 Server MNWIN8, Level 16, State 1, Procedure , Line 1 Invalid object name 'sys.selective_xml_index_paths'. (Source: MSSQLServer, Error number: 208) Get help: http://help/208

more ▼

asked May 14, 2013 at 03:39 PM in Default

avatar image

nirmalpavan
0 1 1 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Based on the ultimate error, "invalid object name 'sys.selective_xml_index_paths'" I can't help but wonder if you might have a corrupt database. You shouldn't see missing system tables, ever. And it's during the snapshot process, not after it's moving transactions. I'd suggest running DBCC to validate the database first. After that, I guess I'd need to see the steps you're taking.

more ▼

answered May 15, 2013 at 10:52 AM

avatar image

Grant Fritchey ♦♦
137k 20 44 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x398

asked: May 14, 2013 at 03:39 PM

Seen: 1313 times

Last Updated: May 15, 2013 at 10:52 AM

Copyright 2017 Redgate Software. Privacy Policy