Thursday, February 8, 2018

The multi-part identifier "syncobj_" could not be bound


We recently got the below error while executing the a procedure on SQLServer

The multi-part identifier "syncobj_0x3946443335424338.DF_286" could not be bound. (Tested Started By)
Processing...           TAB(13) Complaints 2 - V_TAB_13
The multi-part identifier "syncobj_0x3946443335424338.DF_455" could not be bound. (Test Completed By)
Processing...           TAB(14) Complaints 3 - V_TAB_14
The multi-part identifier "syncobj_0x3946443335424338.DF_280" could not be bound. (Test Submitted By)
Processing...           TAB(15) ASR - V_TAB_15
The multi-part identifier "syncobj_0x3946443335424338.DF_445" could not be bound. (Test Approved By)

The error is confusing becoz the “syncobj_” are related to replication snapshot. Why the procedure calling those objects.

After investigation found that user querying column info from  information_schema.columns in the procedure and there is no filter.

We have added a filter “table_name not like 'syncobj%' " to exclude the “syncobj_” and the procedure is working fine without any issues.

The issue has been resolved.

Thanks,
Satishbabu Gunukula
http://sqlserver-expert.com



Posted by at
Labels: , , , , ,

38 comments:

  1. LeoneKhunzeApril 11, 2019 at 9:23 PM

    Thanks for another magnificent post. Where else could anyone get that kind of information in such an ideal way of writing? I have a presentation next week, and I'm on the look for such information. webdesigning singapore

    ReplyDelete
  2. Riyas FathinApril 12, 2019 at 7:32 AM

    Your very own commitment to getting the message throughout came to be rather powerful and have consistently enabled employees just like me to arrive at their desired goals.
    Web Designing Training in Chennai | Best Web Designing Training Institute in Chennai
    SQL Server Training in Chennai | Best SQL Server Training Institute in Chennai
    Digital Marketing Training in Chennai |Best Digital Marketing Training Institute in Chennai
    Java Training in Chennai | Best Java Training Institute in Chennai
    C C++ Training in Chennai |Best C C++ Training Institute in Chennai

    ReplyDelete
  3. WintyWenApril 12, 2019 at 8:27 AM

    Oh my goodness! an amazing article dude. Thanks However I am experiencing subject with ur rss . Don’t know why Unable to subscribe to it. Is there anyone getting equivalent rss drawback? Anyone who is aware of kindly respond. 个人陈述

    ReplyDelete
  4. UnknownMay 28, 2019 at 3:33 AM

    I 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.
    Azure Training in Chennai

    ReplyDelete
  5. RajeshJuly 15, 2019 at 11:05 PM

    this is a nice post Blue Prism Training in Bangalore
    Blue Prism Training in BTM
    RPA Training in BTM
    RPA Training in Bangalore
    Android Training in Bangalore
    Android Training in Bangalore
    Google Cloud Training in Bangalore
    Azure DevOps training in Bangalore

    ReplyDelete
  6. htopJuly 17, 2019 at 11:31 PM

    nice post this is useful message
    aws training center in chennai
    aws training in chennai
    aws training institute in chennai
    best angularjs training in chennai
    angular js training in sholinganallur
    angularjs training in chennai
    azure training in chennai

    ReplyDelete
  7. PriyankaSeptember 20, 2019 at 2:56 AM

    Attend The Analytics Course in Bangalore From ExcelR. Practical Analytics Course in Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Analytics Course in Bangalore.
    ExcelR Analytics Course in Bangalore

    ReplyDelete
  8. PriyankaOctober 21, 2019 at 5:48 AM

    Attend The PMP Certification From ExcelR. Practical PMP Certification Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The PMP Certification.
    ExcelR PMP Certification

    ReplyDelete
  9. digitaltucrNovember 19, 2019 at 9:33 PM


    You actually make it look so easy with your performance but I find this matter to be actually something which I think I would never comprehend. It seems too complicated and extremely broad for me. I'm looking forward for your next post, I’ll try to get the hang of it!
    ExcelR ai training in bangalore

    ReplyDelete
  10. Data Science Courses In MumbaiNovember 20, 2019 at 12:45 AM

    After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article.
    ExcelR data analytics courses

    ReplyDelete
  11. datasciencecourseNovember 27, 2019 at 1:37 AM

    I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
    data science course in mumbai

    ReplyDelete
  12. ideaswebDecember 26, 2019 at 12:20 AM

    I am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here. Legal Entity Identifier Number

    ReplyDelete
  13. 360DigiTMGFebruary 14, 2020 at 2:45 AM

    I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful.
    courses in data analytics
    data science course
    business analytics course

    ReplyDelete
  14. Data Science CourseMarch 13, 2020 at 8:17 AM

    Awesome Post!!! I really enjoyed reading this article. It's really a nice experience to read your post. Thanks for sharing.
    Data Science Course
    Data Science Course in Marathahalli

    ReplyDelete
  15. DataScience SpecialistJune 19, 2020 at 8:48 AM

    It is perfect time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I desire to suggest you few interesting things or tips. Perhaps you could write next articles referring to this article. I want to read more things about it!
    Data Science Course in Bangalore

    ReplyDelete
  16. DataScience SpecialistJune 19, 2020 at 8:48 AM

    I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.
    Data Science Training in Bangalore

    ReplyDelete
  17. tejaswiniAugust 12, 2020 at 9:26 PM

    The blog and data are excellent and often insightfuldata science course

    ReplyDelete
  18. tejaswiniAugust 12, 2020 at 9:27 PM

    Wow what a perfect World Day Knowledge its incredibly enjoyable educational message. The debt of appreciation for that post is in place.data science course

    ReplyDelete
  19. Data Science Training August 28, 2020 at 3:51 AM

    Thanks for the Information.Interesting stuff to read.Great Article.
    I enjoyed reading your post, very nice share.
    Data Science Course Training in Hyderabad

    ReplyDelete
  20. PriyankaSeptember 1, 2020 at 3:08 AM

    Attend The Data Analyst Course From ExcelR. Practical Data Analyst Course Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Data Analyst Course.
    Data Analyst Course

    ReplyDelete
  21. 360digitmgdelhiSeptember 7, 2020 at 2:21 AM

    This post is incredibly simple to examine and recognize without disregarding any nuances. Inconceivable work!
    data science course in delhi

    ReplyDelete
  22. invincible01September 21, 2020 at 5:35 AM

    Amazing Article, Really useful information to all So, I hope you will share more information to be check and share here.


    Internship near me
    Inplant Training for cse
    Inplant Training for IT
    Inplant Training for ECE Students
    Inplant Training for EEE Students
    Inplant Training for MECHANICAL Students
    inplant Training for CIVIL Students
    Inplant Training for Aeronautical Engineering Students
    Inplant Training for ICE Students
    Inplant Training for BIOMEDICAL Engineering Students

    ReplyDelete
  23. AnonymousSeptember 23, 2020 at 2:51 AM

    feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it
    360DigiTMG data science

    ReplyDelete
  24. RohiniSeptember 28, 2020 at 10:36 PM

    A good blog always comes-up with new and exciting information and while reading I have feel that this blog is really have all those quality that qualify a blog to be a one.
    artificial intelligence course in bangalore

    ReplyDelete
  25. riyaOctober 1, 2020 at 8:51 AM

    Super article

    What is Cyber Security
    Types of Cyber Attacks
    Types of Cyber Attackers
    Cyber Security Technology
    Cyber Security Tools
    Cyber Security Standards
    What is Google Adwords
    Google Adwords tutorial
    Google Keyword Planner
    How to Advertise on Google

    ReplyDelete
  26. 360digitmgNovember 18, 2020 at 1:50 AM

    I am a new user of this site so here i saw multiple articles and posts posted by this site,I curious more interest in some of them hope you will give more information on this topics in your next articles.
    Best Institute for Data Science in Hyderabad

    ReplyDelete
  27. PMP CertificationNovember 19, 2020 at 2:11 AM

    It is the expect to give noteworthy information and best takes a shot at, including a perception of the regulatory cycle.
    ai course in malaysia

    ReplyDelete
  28. EXCELRNovember 26, 2020 at 3:28 AM

    Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work.data science course in Hyderabad

    ReplyDelete
  29. EXCELRDecember 8, 2020 at 3:54 AM

    "Thanks for the Information.Interesting stuff to read.Great Article.
    I enjoyed reading your post, very nice share.data science training"

    ReplyDelete
  30. DeviDecember 10, 2020 at 10:46 PM

    This article shares a lot of good information.
    uses of python programming
    high paying skills to learn
    how to learn programming language easily
    hadoop learning path
    java interview questions and answers for freshers

    ReplyDelete
  31. dataanalyticscourseDecember 13, 2020 at 11:13 PM

    We very much appreciate your hard work as knowledge provider, which has helped us through a difficult period.
    machine learning training

    ReplyDelete
  32. JamesDecember 14, 2020 at 10:51 AM

    There are online courses available on the internet which teaches whole data science technology through video tutorials and theory as well. There would be assignments which you have to complete. data science course in india

    ReplyDelete
  33. dataanalyticscourseDecember 15, 2020 at 12:27 AM

    Thank you for always speaking up in team meetings and providing a unique perspective.
    https://360digitmg.com/course/certification-program-on-big-data-with-hadoop-spark

    ReplyDelete
  34. 360digiTMG TrainingJanuary 5, 2021 at 10:38 PM

    I recently found many useful information in your website especially this blog page. Among the lots of comments on your articles. Thanks for sharing.
    Best Digital Marketing Institute in Hyderabad

    ReplyDelete
  35. Excelr TuhinJanuary 31, 2021 at 9:05 AM

    I've read this post and if I could I desire to suggest you some interesting things or suggestions. Perhaps you could write next articles referring to this article. I want to read more things about it!
    Data Science courses

    ReplyDelete
  36. FloraFebruary 3, 2021 at 3:23 AM

    I am glad to see your article. Very interesting to read your article.
    merits and demerits of artificial intelligence
    applications of .net
    applications of hadoop
    open source devops tools
    selenium questions and answers
    digital marketing interview questions and answers for experienced

    ReplyDelete
  37. 360DigiTMGNoidaFebruary 17, 2021 at 1:30 AM

    Wow, amazing post! Really engaging, thank you.
    data science training in noida

    ReplyDelete

Subscribe to: Post Comments (Atom)