Ever tried to add a new subscription to an existing publication, using the "replication support only" or "initialize from backup" methods and go the following error?
The process could not execute 'sp_MSadd_replcmds' on <'Distribution Server>'. (Source: MSSQLServer, Error number: 1007)
Conversion failed when converting the nvarchar value '.' to data type int. (Source: MSSQLServer, Error number: 1007)
Batches were not committed to the Distributor. (Source: MSSQL_REPL, Error number: MSSQL_REPL22020)
The last step did not log any message! (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)
If so, you will know the internet is absolutely useless, filled with worthless workarounds or advice to just "rebuild replication"
Well, if you want an actual solution, just read on. Between SQL 2012 RTM and SQL 2012 SP4 there was a change made to the Distributor proc sp_MSadd_replcmds. This change was to facilitate a change in the format of log buffer, probably related to the number of publications you can have.
In the RTM version, the code that actually fails is as follows
select @originator_publication_id = CAST(CAST(substring(@cmdText, 1, 4) AS nvarchar) AS int),
@next_valid_lsn_from_log = CAST(substring(@cmdText, 5, 10) AS binary(10))
In 2012 SP4 this becomes
-- if most high bit is set to 1 then interprete buffer as a new format 99 <= 0xFFFFFF9D (supports 2^32 ids), otherwise it's a backward compatibility for 99 <= ca (this is max id)
select @originator_publication_id = CASE WHEN CAST(substring(@cmdText, 1, 4) AS int) <= 0 THEN -CAST(substring(@cmdText, 1, 4) AS int) ELSE CAST(CAST(substring(@cmdText, 1, 4) AS nvarchar) AS int) END,
@next_valid_lsn_from_log = CAST(substring(@cmdText, 5, 10) AS binary(10))
You can see now why you get the error in the log reader. As far as I can tell, having the publisher ahead of the distributor on point releases is what causes this - this makes sense since it is the log reader that fails. I don't believe the version of the subscriber has any effect here.
Anyway so now you know - always make sure you distributor patches in lock step with your publisher, even if the major version is the same.
Thanks a lot for sharing us about this update. Hope you will not get tired on making posts as informative as this.
ReplyDeleteJava training in Chennai | Java training institute in Chennai | Java course in Chennai
Java training in Bangalore | Java training institute in Bangalore | Java course in Bangalore
Java online training | Java Certification Online course-Gangboard
Java training in Pune
Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.
ReplyDeletepython course in pune
python course in chennai
python course in Bangalore
Thank you so much. This was really helpful. I have been setting up permissions and playing around with log reader, but no luck. Your tip helped to resolve the issue.
ReplyDeleteI simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.
ReplyDeleteBest Devops training in sholinganallur
Devops training in velachery
Devops training in annanagar
Devops training in tambaram
This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
ReplyDeleterpa training in bangalore | best rpa training in bangalore | rpa course in bangalore | rpa training institute in bangalore | rpa training in bangalore | rpa online training | rpa training in Chennai
Hello! This is my first visit to your blog! We are a team of volunteers and starting a new initiative in a community in the same niche. Your blog provided us useful information to work on. You have done an outstanding job.
ReplyDeleteAdvanced AWS Training in Chennai | Best Amazon Web Services Training in Chennai
Best Amazon Web Services Training Course in Bangalore | AWS Training in Bangalore
AWS Online Training and Certification | AWS Certification Course
Thanks for the informative article. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.
ReplyDeleteangularjs-Training in pune
angularjs Training in bangalore
angularjs Training in bangalore
angularjs Training in chennai
automation anywhere online Training
angularjs interview questions and answers
Nice useful information. Thanks for spending your valuable time to share thanks blog with us.
ReplyDeleteBest Spoken English Class in Chennai
Spoken English Course in Chennai
Best Spoken English Classes in Chennai
Spoken English Training near me
Best Spoken English Institute in Chennai
English Coaching Class in Chennai
English Courses in Chennai
This is exceedingly helpful information, very good work. Thanks for sharing and let me wait for further updates.
ReplyDeleteAWS Training in Chennai
AWS course in Chennai
DevOps certification in Chennai
DevOps Training in Chennai
Data Science Course in Chennai
Data Science Training in Chennai
AWS Training in OMR
AWS Training in Adyar
whatsapp group links
ReplyDelete
ReplyDeleteThis is quite educational arrange. It has famous breeding about what I rarity to vouch.
Colossal proverb. This trumpet is a famous tone to nab to troths. Congratulations on a career well achieved.
This arrange is synchronous s informative impolite festivity to pity. I appreciated what you ok extremely here.
Selenium training in bangalore
Selenium training in Chennai
Selenium training in Bangalore
Selenium training in Pune
Selenium Online training
Selenium interview questions and answers
Thank you so much for providing information on this. It was very useful.
ReplyDeleteAviation Academy in Chennai
Air hostess training in Chennai
Airport management courses in Chennai
Ground staff training in Chennai
aviation training in chennai
air hostess institute in chennai
aircraft maintenance course in chennai
airport ground staff training in chennai
Hearty thanks to you admin, your blog is awesome and helpful. Keep your blog with latest information.
ReplyDeleteRPA Training in Chennai
Robotics Process Automation Training in Chennai
Blue Prism Training in Chennai
UiPath Training in Chennai
Data Science Course in Chennai
RPA Training in Anna Nagar
RPA Training in Chennai
RPA course in Chennai
Excellent post for the people who really need information for this technology.
ReplyDeleteGerman Classes in Chennai
spoken german classes in chennai
IELTS Coaching in OMR
TOEFL Coaching Centres in Chennai
french classes
pearson vue
IELTS Coaching in anna nagar
ielts coaching in chennai anna nagar
ReplyDeleteAnd indeed, I’m just always astounded concerning the remarkable things served by you. Some four facts on this page are undeniably the most effective I’ve had.
C C++ Training in Chennai |Best C C++ Training course in Chennai
linux Training in Chennai | Best linux Training in Chennai
Unix Training in Chennai | Best Unix Training in Chennai
uipath training in chennai | Best uipath training in chennai
Rprogramming Training in Chennai | Best Rprogramming Training in Chennai
I really happy to read your great post and I anxiously waiting for your next post. Please updating...!
ReplyDeleteLinux Training in Chennai
Linux Course in Chennai
Excel Training in Chennai
Oracle Training in Chennai
Unix Training in Chennai
Tableau Training in Chennai
Embedded System Course Chennai
Oracle DBA Training in Chennai
Primavera Training in Chennai
Power BI Training in Chennai
Interesting blog. Got a lotb of information about this technology.
ReplyDeleteSpoken English Classes in Chennai
English Coaching Classes in Chennai
IELTS Training in Chennai
Japanese Language Course in Chennai
TOEFL Training in Chennai
French Language Classes in Chennai
Spoken English Classes in Porur
Spoken English Classes in Adyar
Great, Useful information..
ReplyDeleteSpoken English in chennai
Personality development in chennai
IELTS in chennai
TOEFL in Chennai
American Accent Training in chennai
Call centre training in chennai
Thanks for sharing this wonderful and useful information...
ReplyDeleteRPA Training in Kalyan Nagar
Data Science with Python Training Bangalore
AWS Training in Kalyan Nagar
RPA training in bellandur
AWS Training in bellandur
Marathahalli AWS Training Institues
Kalyan nagar AWS training in institutes
Data Science Training in bellandur
Data Science Training in Kalyan Nagar
Data science training in marathahalli
For Data Science training training in Bangalore, Visit:
ReplyDeleteData Science training in bangalore
For Blockchain training in bangalore, Visit:
ReplyDeleteBlockchain training in bangalore
VISIT HERE -> Big data and Hadoop training in bangalore
ReplyDeleteVisit here -> DEVOPS TRAINING IN BANGALORE
ReplyDeleteI would definitely thank the admin of this blog for sharing this information with us. Waiting for more updates from this blog admin.
ReplyDeletesalesforce Training in Bangalore
uipath Training in Bangalore
blueprism Training in Bangalore
Your post is just outstanding! thanx for such a post,its really going great and great work.
ReplyDeletepython training in kalyan nagar|python training in marathahalli
selenium training in marathahalli|selenium training in bangalore
devops training in kalyan nagar|devops training in bellandur
phthon training in bangalore
Great Article
ReplyDeleteIEEE Projects on Cloud Computing
Final Year Projects for CSE
Wonderful Blog!!! Your post is very informative about the latest technology. Thank you for sharing the article with us
ReplyDeleteaws Training in Bangalore
python Training in Bangalore
hadoop Training in Bangalore
angular js Training in Bangalore
bigdata analytics Training in Bangalore
Very nice post here and thanks for it .I always like and such a super blog of these post.Excellent and very cool idea and great blog of different kinds of the valuable information's.
ReplyDeleteaws Training in Bangalore
python Training in Bangalore
hadoop Training in Bangalore
angular js Training in Bangalore
bigdata analytics Training in Bangalore
I am impressed by the way of writing your blog and topics which you covered. I read all your post which is useful and informative.
ReplyDeleteaws Training in Bangalore
python Training in Bangalore
hadoop Training in Bangalore
angular js Training in Bangalore
bigdata analytics Training in Bangalore
Great Article
ReplyDeleteData Mining Projects
Python Training in Chennai
Project Centers in Chennai
Python Training in Chennai
Really i found this article more informative, thanks for sharing this article! Also Check here
ReplyDeleteDownload and install Vidmate App which is the best HD video downloader software available for Android. Get free latest HD movies, songs, and your favorite TV shows
Vidmate App Download
Vidmate apk for Android devices
Vidmate App
download Vidmate for Windows PC
download Vidmate for Windows PC Free
Vidmate Download for Windows 10
Download Vidmate for iOS
Download Vidmate for Blackberry
Vidmate For IOS and Blackberry OS
Sach janiye
ReplyDeleteMrinalini Sarabhai
Sandeep Maheshwari
dr sarvepalli radhakrishnan
Arun Gawli
Rani Padmini
Sushruta
Harshavardhana
Nanaji Deshmukh
Tansen
And also thanks for sharing this informative. Keep it Sir and I am waiting for your next post on your site blog.
ReplyDeleteBest Training Institute in Bangalore BTM. My Class Training Bangalore training center for certified course, learning on Software Training Course by expert faculties, also provides job placement for fresher, experience job seekers.
Software Training Institute in Bangalore
subrahmanyan chandrasekhar
ReplyDeleteMithali Raj
Durgabai Deshmukh
Sumitranandan Pant
Pandit Deendayal Upadhyay
Manya Surve
Philip Larkin
Razia Sultan
Gautam Adani
Surdas
Really very happy to say, your post is very interesting to read. I never stop myself to say something about it. You’re doing a great job. Keep it up...
ReplyDeleteLearn Hadoop Training from the Industry Experts we bridge the gap between the need of the industry. Softgen Infotech provide the Best Hadoop Training in Bangalore with 100% Placement Assistance. Book a Free Demo Today.
Big Data Analytics Training in Bangalore
Tableau Training in Bangalore
Data Science Training in Bangalore
Workday Training in Bangalore
Data Science Course
ReplyDeleteData Science Course in Marathahalli
Data Science Course Training in Bangalore
wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
ReplyDeleteData Science Course
This comment has been removed by the author.
ReplyDeleteVery interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
ReplyDeleteCorrelation vs Covariance
Simple linear regression
wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
ReplyDeleteAWS training in chennai | AWS training in annanagar | AWS training in omr | AWS training in porur | AWS training in tambaram | AWS training in velachery
Very much interesting topic.Gained a lot of stuff.
ReplyDeleteJava training in Chennai
Java training in Bangalore
Java training in Hyderabad
Java Training in Coimbatore
Java Online Training
This is a very useful blog.we are knowing a great content and also lots of information.
ReplyDeleteWeb Designing Training Course in Chennai | Certification | Online Training Course | Web Designing Training Course in Bangalore | Certification | Online Training Course | Web Designing Training Course in Hyderabad | Certification | Online Training Course | Web Designing Training Course in Coimbatore | Certification | Online Training Course | Web Designing Training Course in Online | Certification | Online Training Course
This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.
ReplyDeleteSimple Linear Regression
Correlation vs Covariance
I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
ReplyDeleteCorrelation vs Covariance
Simple linear regression
data science interview questions
python training in bangalore | python online Training
ReplyDeleteartificial intelligence training in bangalore | artificial intelligence online training
machine learning training in bangalore | machine learning online training
uipath-training-in-bangalore | uipath online training
blockchain training in bangalore | blockchain online training
aws training in Bangalore | aws online training
data science training in bangalore | data science online training
hadoop training in bangalore | hadoop online training
ReplyDeleteiot training in bangalore | iot online training
devops training in banaglore | devops online training
Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
ReplyDeleteCorrelation vs Covariance
Simple Linear Regression
data science interview questions
KNN Algorithm
Logistic Regression explained
Very nice blogs!!! i have to learning for lot of information for this sites…Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing, data sciecne course in hyderabad
ReplyDeleteExcellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking Best data science courses in hyerabad
ReplyDeleteThis is most informative and also this post most user friendly and super navigation to all posts.
ReplyDeleteData Science
Selenium
ETL Testing
AWS
Python Online Classes
Awesome article, it was exceptionally helpful! I simply began in this and I'm becoming more acquainted with it better! Cheers, keep doing awesome!
ReplyDeleteWeb Design Company Cheltenham
SEO Agency Cheltenham
This is one of the most incredible blogs Ive read in a very long time.
ReplyDeletethoi gian bay tu tphcm den trung quoc
vé máy bay đi quảng châu bao nhiêu tiền
sân bay thượng hải
giá vé máy bay đi anh quốc
giá vé máy bay đi mỹ
cách mua vé máy bay giá rẻ từ mỹ về việt nam