Sample Header Ad - 728x90

Initial snapshot not yet available adding subscription issue

0 votes
1 answer
864 views
I am experiencing some issue with my subscription (transactional replication) recently as whenever I tried to add a new subscription to my existing publication either way I use Initialize when Immediately or At first synchronization I always encountered issue resulting unsuccessful subscription. When I select initialize when Immediately, after I hit the finish button, I encountered this error: Message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Command Text: sp_MSreplupdateschema Parameters: @object_name = [dbo].[myTableName] Stack: at Microsoft.SqlServer.Replication.AgentCore.ReMapSqlException(SqlException e, SqlCommand command) at Microsoft.SqlServer.Replication.AgentCore.AgentExecuteNonQuery(SqlCommand command, Int32 queryTimeout) at Microsoft.SqlServer.Replication.AgentCore.ExecuteDiscardResults(CommandSetupDelegate commandSetupDelegate, Int32 queryTimeout) at Microsoft.SqlServer.Replication.Snapshot.TransSnapshotProvider.ConcurrentPreArticleFilesGenerationTransaction(SqlConnection connection) at Microsoft.SqlServer.Replication.RetryableSqlServerTransactionManager.ExecuteTransaction(Boolean bLeaveTransactionOpen) at Microsoft.SqlServer.Replication.Snapshot.TransSnapshotProvider.DoConcurrentPreArticleFilesGenerationProcessing() at Microsoft.SqlServer.Replication.Snapshot.TransSnapshotProvider.DoPreArticleFilesGenerationProcessing() at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot() at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun() at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQLServer, Error number: -2) Get help: http://help/-2 Server MyServerName, Level 11, State 0, Procedure , Line 0 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Source: MSSQLServer, Error number: -2) Get help: http://help/-2 Source: Target Site: Message: The wait operation timed out Stack: (Source: , Error number: 0) Get help: http://help/0 enter image description here However if I select Initialize when At First Synchronization, it gives me the status of The initial snapshot for article myTableName is not yet available. enter image description here Furthermore, if I reinitialize the subscription nothing happens enter image description here Note: I am using SQL Server Standard 2019 Edition, Microsoft SQL Server Management Studio 2019 Here's also my Server specification: HP Proliant Gen10 + enter image description here and my current system utilization via task manager enter image description here
Asked by Caspersky12 (5 rep)
Oct 22, 2023, 03:21 PM
Last activity: Oct 28, 2023, 03:33 PM