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



29 comments:

  1. 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. 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
  3. 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

  4. 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
  5. 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
  6. 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
  7. The blog and data are excellent and often insightfuldata science course

    ReplyDelete
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. "Thanks for the Information.Interesting stuff to read.Great Article.
    I enjoyed reading your post, very nice share.data science training"

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

    ReplyDelete
  15. 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
  16. 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
  17. 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
  18. 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
  19. Nice blog. Informative and knowledgeable content. Keep sharing more articles with us. Thanks for sharing this article.
    Data Science Course with Placements in Hyderabad

    ReplyDelete