Error 21861
Contents |
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this
The Subscription Status Of The Object Could Not Be Changed
site About Us Learn more about Stack Overflow the company Business Learn more could not update the distribution database subscription table about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault
The Subscription Status Could Not Be Changed
is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The cannot drop the publication because at least one subscription exists for this publication best answers are voted up and rise to the top Can not drop subscription, probably due to stale publication articles up vote 0 down vote favorite I'm having trouble dropping a subscription from my replication setup. The subscriptions do not appear (in SSMS, at least) on the subscribers, but do on the publisher. When trying to drop the subscriptions via either SSMS or sp_dropsubscription, I sp_dropsubscription receive he following error message: Msg 14068, Level 16, State 1, Procedure sp_MSrepl_changesubstatus, Line 1353 The subscription status of the object could not be changed. I dropped all articles from the subscription in SSMS, reran sp_dropsubscription, and still received the same message. However, it appears now the only article that sp_helpsubscription is reporting is a table-valued function that does not exist anymore. A table does however exist with the same name. I tried renaming the table and re-adding the function, but this didn't work. The function did not show up as checked in the published articles list, and manually dropping it still didn't work, giving me the same error message. Any ideas? Our publisher is running SQL Server 2008 and our two subscribers are running 2005. sql-server replication share|improve this question asked Jan 19 '10 at 17:53 Stuart Branham 166210 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accepted Just dropped the whole damn distribution and started over. That's all I could figure out. share|improve this answer answered Jan 25 '10 at 16:19 Stuart Branham 166210 An easier approach - to try first - would be t
> SQL Transactional Replication Issue Discussion in 'Performance Tuning for SQL Server Replication' started by vivianlly, Aug 29, 2003. vivianlly New Member I set up transactional replication
Could Not Drop Article A Subscription Exists On It
on SQL 2K database. Some of the tables are replicated using store procedures while others are replicated using sql commands. Some of these tables also contains triggers. However, these triggers are coded with syntax "NOT FOR REPLICATION" All manipulation of data are done using ado transaction via the application. My problem is I get Error Executing a batch, Execution of individual commands succeeded. And then it just http://serverfault.com/questions/104253/can-not-drop-subscription-probably-due-to-stale-publication-articles stops after retrying for many times. It causes my replication to slow down whenever that happens. Then when error occurs I have to manually starts it or skip the error. I am wondering what could cause sql to execute individual commands /executing batch AND HOW TO PREVENT/SOLVE this problem. Your thoughts and help will be much appreciated. vivianlly, Aug 29, 2003 #2 satya Moderator What was the exact http://www.sql-server-performance.com/forum/threads/sql-transactional-replication-issue.17937/ error and service pack level on SQL? _________ Satya SKJ Moderator SQL-Server-Performance.Com satya, Aug 29, 2003 #2 vivianlly New Member There is no exact error except it just kept saying "Execution of Individual Commands" and it will retries many times if it hasn't succeed until either it gets tired of trying or it succeeded. When succeeded then it will says "Execution of Individual Commands Succeeded." else it just gives an error that says something about not wanting to retry anymore (sorry I forget to log down the exact error but I am pretty sure it's about tired of retrying) vivianlly, Sep 1, 2003 #2 vivianlly New Member Ok I manage to capture the exact error frm the Action Message that appears in a sequence: - Execution of individual commands succeeded. NOTE: The step was retried the requested number of times (10) without succeeding. The step failed. - Execution of individual comamnds succeeded. - Error executing a batch of commands. Retrying individual commands. vivianlly, Sep 1, 2003 #2 satya Moderator I don't see anything to suspect, recheck whether the replication process is working overall between the servers. _________ Satya SKJ Moderator SQL-Server-Performance.Com satya, Sep 2, 2003 #2 vivianlly New Member As mentioned
Sign in Pricing Blog Support Search GitHub This repository Watch 1,057 Star 29,539 Fork 14,103 Homebrew/legacy-homebrew Code Issues 5 Pull requests 0 Projects https://github.com/Homebrew/legacy-homebrew/issues/21861 0 Pulse Graphs Install erroring out on ./configure (checking whether C compiler works) #21861 Closed ianclarksmith opened this Issue Aug 13, 2013 · 3 comments Projects None yet https://books.google.com/books?id=NzRIDAAAQBAJ&pg=PA21&lpg=PA21&dq=error+21861&source=bl&ots=HCeB_2EjiH&sig=kE1u2Y1kMd97J6UY9sjGt-t0ZRQ&hl=en&sa=X&ved=0ahUKEwjP9vuh1sTPAhUrxoMKHRI9ABEQ6AEITTAI Labels None yet Milestone No milestone Assignees No one assigned 3 participants ianclarksmith commented Aug 13, 2013 I'm not sure exactly what is going wrong here. I've tried could not using --with-gcc which gives similar errors. It works flawlessly by just cd-ing and executing my ./configure line. It finds and uses gcc, gcc -O6 -fomit-frame-pointer does it's thing and then it's good to go. I'm not getting anything weird in brew doctor (unlinked emacs), brew is up to date itself as are all packages. GCC is installed obviously and the subscription status working fine, and cc/clang/... all seem to compile anything I give them outside of brew. What silly mistake am I making here? ==> ./configure --prefix=/usr/local/Cellar/julius/4.2.3 --enable-words-int --enable-gmm-vad --enable-decoder-vad --enable-power-reject checking host system type... i686-apple-darwin checking host specific optimization flag... support/cflags.i686-apple-darwin checking for gcc... cc checking whether the C compiler (cc -O6 -fomit-frame-pointer ) works... no configure: error: installation or configuration problem: C compiler cannot create executables. ...from Formula file... depends_on :x11 # if your formula requires any X11/XQuartz components depends_on 'zlib' depends_on 'flex' depends_on 'libsndfile' => :recommended def install system "./configure", "--disable-debug", "--disable-dependency-tracking", "--prefix=#{prefix}", "--enable-words-int", "--enable-gmm-vad", "--enable-decoder-vad", "--enable-power-reject" system "make", "make install" end config.log This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistake. configure:555: checking host system type configure:577: checking host specific optimization flag configure:593: checking for gcc configure:706: checking whether the C compiler (cc -O6 -fomit-frame-pointer ) works configure:722: cc -o conftest -O6 -fomit-frame-pointer conftest.c 1>&5 error: invalid value '6' in '-O6' configure: failed program was: #line 717 "configure" #include "confdefs.h" main(){return(0);} config.log (--with-gcc