Category: Troubleshooting

Specify all articles when subscribing to a publication using concurrent snapshot processing.

Chris Skorlinski [MSFT] Troubleshooting April 4, 2012

Share this PostI recently encountered this error when setting up Transactional Replication via SQL scripts. Msg 14100, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 533 Specify all articles when subscribing to a publication using concurrent snapshot processing. Looking at my create Publication script I see the default @sync_method = N’concurrent’ being set in sp_addpublication. Nothing
Read More »

Update Statistics fails with Error Number:–1073548784 “Could not allocate space for object ‘dbo.SORT”

Chris Skorlinski [MSFT] Troubleshooting September 25, 2011

Share this PostError Number: -1073548784 Executing the query “UPDATE STATISTICS [dbo].[***********] WITH FULLSCAN ” failed with the following error: “Could not allocate space for object ‘dbo.SORT temporary run storage: 142101814116352’ in database ‘tempdb’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to
Read More »

How to run sp_browsereplcmds on a Distribution db backup

Chris Skorlinski [MSFT] Inside Replication, Troubleshooting June 22, 2011

Share this PostFrom time to time we need to restore a customer’s Distribution database to a secondary server or to a lab server for testing. When you restore a distribution database it will not be configured to execute Replication commands such as sp_browsereplcmds. However, there is a simple solution. You can execute the command below
Read More »

REPLICATION: My distribution agent generates a dump when replicating with my Oracle Subscriber

ReplTalk Product Updates, Troubleshooting June 22, 2011

Share this Postreposting from Claudia Silva Microsoft SQL Escalation Services United Kingdom http://blogs.technet.com/b/claudia_silva/ PROBLEM: I have a SQL Server 2005 replicating with an Oracle 11 subscriber. After installing the OLEDB driver for Oracle 11, a minidump is created every time the distributor tries to connect to Oracle: Distrib.exe crashes with STACK_OVERFLOW exception. The issue occurs
Read More »

Replication: Unable to Synchronize subscribers via Web Synchronization

ReplTalk Best Practices, Troubleshooting June 22, 2011

Share this Postreposting from Claudia Silva Microsoft SQL Escalation Services United Kingdom http://blogs.technet.com/b/claudia_silva/ Problem: The upload message to be sent to Publisher ‘XXX’ is being generated The merge process is using Exchange ID ‘XXXXX’ for this web synchronization session. No data needed to be merged. Request message generated, now making it ready for upload. Upload
Read More »