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
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.
Furthermore, if I reinitialize the subscription nothing happens
Note:
I am using SQL Server Standard 2019 Edition, Microsoft SQL Server Management Studio 2019
Here's also my Server specification:
HP Proliant Gen10 +
and my current system utilization via task manager





Asked by Caspersky12
(5 rep)
Oct 22, 2023, 03:21 PM
Last activity: Oct 28, 2023, 03:33 PM
Last activity: Oct 28, 2023, 03:33 PM