Wednesday, 24 June 2015

Quick Tip Generic SQL Error CRM Plugin C#

A quick tip here, just for sharing what happened.

Once you get this Generic SQL Error, beside you can check the event viewer, DB Log, or SQL Tracing or even your Plugin Tracing, I want to share that there are two conditions triggering this error that is actually simple but not anticipated before.

There are:

1. I tried to set a field text that is actually max length = 100, but I give more than 100.
This is commonly happening once you try to set a name as primary field that it is good to not leave it blank, so you use combination of the important fields since CRM cannot use any other than text field to be primary key.

2. Try to create child record or associated record before parent record is created.
This was happening that time I forgot to set the Plugin to Post-event creation instead of Pre-event one.

Hope this can help you, I waste time to see what happened, while I was trying to debug, in fact those two simple cases causing the trouble.

You have any other simple one causing the trouble? Let us know!

Thank you.

128 comments:

  1. Given so much information in it. its very useful .perfect explanation about Dot net framework.Thanks for your valuable information. dot net training in chennai velachery | dot net training institute in velachery

    ReplyDelete
  2. It is really a great work and the way in which u r sharing the knowledge is excellent.
    Thanks for helping me to understand basic concepts. As a beginner in Dot Net programming your post help me a lot.Thanks for your informative article.. dot net training and placement in chennai | best dot net training in chennai

    ReplyDelete
  3. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from Dot Net Training in Chennai. or learn thru ASP.NET Essential Training Online . Nowadays Dot Net has tons of job opportunities on various vertical industry.
    or Javascript Training in Chennai. Nowadays JavaScript has tons of job opportunities on various vertical industry.

    ReplyDelete
  4. Good post and I like it very much. By the way, anybody try this app development company for iOS and Android? I find it is so professional to help me boost app ranking and increase app downloads.

    ReplyDelete
  5. Great Blog to read,Its gives more useful information. Thanks for sharing.
    Selenium Training in Chennai

    ReplyDelete
  6. This blog gives very important info about .Net Thanks for sharing
    .Net Online Training Hyderabad

    ReplyDelete
  7. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.
    Click here:
    angularjs training in bangalore

    ReplyDelete
  8. Wonderful bloggers like yourself who would positively reply encouraged me to be more open and engaging in commenting.So know it's helpful.
    Click here:
    Microsoft Azure training in online

    ReplyDelete
  9. 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.

    rpa Training in Chennai

    rpa Training in bangalore

    rpa Training in pune

    blueprism Training in Chennai

    blueprism Training in bangalore

    blueprism Training in pune

    rpa online training

    ReplyDelete
  10. It's interesting that many of the bloggers to helped clarify a few things for me as well as giving.Most of ideas can be nice content.The people to give them a good shake to get your point and across the command

    rpa Training in tambaram

    blueprism Training in tambaram

    automation anywhere training in tambaram

    iot Training in tambaram

    rpa training in sholinganallur

    blue prism training in sholinganallur

    automation anywhere training in sholinganallur

    iot training in sholinganallur

    ReplyDelete
  11. 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.

    rpa Training in Chennai

    rpa Training in bangalore

    rpa Training in pune

    blueprism Training in Chennai

    blueprism Training in bangalore

    blueprism Training in pune

    rpa online training

    ReplyDelete
  12. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    Devops training in tambaram|Devops training in velachery|Devops training in annanagar|Devops training in sholinganallur

    ReplyDelete
  13. This is good site and nice point of view.I learnt lots of useful information.
    python training in pune
    python online training
    python training in OMR

    ReplyDelete
  14. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own BlogEngine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it.
    python training in pune
    python online training
    python training in OMR

    ReplyDelete
  15. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 
    Devops Training in Chennai

    Devops Training in Bangalore

    Devops Training in pune

    ReplyDelete
  16. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 
    Devops Training in Chennai

    Devops Training in Bangalore

    Devops Training in pune

    ReplyDelete
  17. That was a great message in my carrier, and It's wonderful commands like mind relaxes with understand words of knowledge by information's.
    Blueprism training in tambaram

    Blueprism training in annanagar

    Blueprism training in velachery

    ReplyDelete
  18. Thanks Admin for sharing such a useful post, I hope it’s useful to many individuals for developing their skill to get good career.
    Blueprism training in tambaram

    Blueprism training in annanagar

    Blueprism training in velachery

    ReplyDelete
  19. Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    Blueprism training in tambaram

    Blueprism training in annanagar

    Blueprism training in velachery

    ReplyDelete
  20. Really great post, Thank you for sharing This knowledge.Excellently written article, if only all bloggers offered the same level of content as you, the internet would be a much better place. Please keep it up!

    angularjs Training in chennai

    angularjs-Training in chennai

    angularjs Training in chennai

    angularjs-Training in tambaram

    angularjs-Training in sholinganallur

    ReplyDelete
  21. Thank you much for this tutorial; this is an informative and valuable blog. Visit for
    Outsourced Web Hosting Support

    ReplyDelete
  22. I am really happy with your blog because your article is very unique and powerful for new reader.
    Click here:
    selenium training in chennai
    selenium training in bangalore
    selenium training in Pune
    selenium training in pune
    Selenium Online Training

    https://maxood-android-corner.blogspot.com/2011/01/tutorial-android-mind-games.html

    ReplyDelete
  23. Amazon has a simple web services interface that you can use to store and retrieve any amount of data, at any time, from anywhere on the web. Amazon Web Services (AWS) is a secure cloud services platform, offering compute power, database storage, content delivery and other functionality to help businesses scale and grow.For more information visit.
    aws online training
    aws training in hyderabad
    aws online training in hyderabad

    ReplyDelete
  24. I accept there are numerous more pleasurable open doors ahead for people that took a gander at your site.we are providing ReactJs training in Chennai.
    For more details: ReactJs training in Velachery | ReactJs training in chennai

    ReplyDelete
  25. Very nice post here and thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's.
    rpa training in bangalore
    best rpa training in bangalore
    RPA training in bangalore
    rpa course in bangalore
    rpa training in chennai
    rpa online training

    ReplyDelete
  26. This comment has been removed by the author.

    ReplyDelete
  27. Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live. I have bookmarked more article from this website. Such a nice blog you are providing ! Kindly Visit Us @ Best Travels in Madurai | Tours and Travels in Madurai | Madurai Travels

    ReplyDelete
  28. Very interesting,good job and thanks for sharing such a good blog.your article is so convincing that I never stop myself to say something about it.You’re doing a great job.Keep it up.
    Blue prism training in pune
    Blue prism training

    ReplyDelete

  29. Whoa! I’m enjoying the template/theme of this website. It’s simple, yet effective. A lot of times it’s very hard to get that “perfect balance” between superb usability and visual appeal. I must say you’ve done a very good job with this.

    AWS Training in Bangalore | Best AWS Amazon Web Services…
    Amazon Web Services (AWS) Training in Pune India
    AWS Training | AWS Training and Certification | AWS online training
    AWS Training in Bangalore cost| Aws training in Bangalore with placements

    ReplyDelete
  30. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    python course institute in bangalore
    python Course in bangalore
    python training institute in bangalore

    ReplyDelete
  31. Nice tutorial. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated tutorials…
    AWS Training in Bangalore
    AWS training in sholinganallur
    AWS training in Tambaram
    AWS training in Velachery

    ReplyDelete
  32. This comment has been removed by the author.

    ReplyDelete
  33. Information from this blog is very useful for me, am very happy to read this blog Kindly visit us @ Luxury Watch Box | Shoe Box Manufacturer |  Candle Packaging Boxes

    ReplyDelete
  34. 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.
    mobile service center in vadapalani
    mobile service center in porur
    best mobile service center

    ReplyDelete

  35. It has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted.
    Data Science Course in Chennai | NO.1 Data Science Training in Chennai
    Python Course in Chennai | NO.1 Python Training Institutes in Chennai
    RPA Course in Chennai | NO.1 RPA Training in Chennai
    Digital Marketing Course in Chennai | NO.1 Digital Marketing Training in Chennai

    ReplyDelete
  36. Thanks for giving great kind of information. So useful and practical for me. Thanks for your excellent blog, nice work keep it up thanks for sharing the knowledge.
    lenovo service center in velachery
    lenovo service center in porur
    lenovo service center in vadapalani

    ReplyDelete
  37. I found this informative and interesting blog so i think so its very useful and knowledge able.I would like to thank you for the efforts you have made in writing this article.

    devops online training

    aws online training

    data science with python online training

    data science online training

    rpa online training

    ReplyDelete
  38. Nice post. I learned some new information. Thanks for sharing.

    karnatakapucresult
    Guest posting sites

    ReplyDelete
  39. Nice post. Thanks for sharing! I want people to know just how good this information is in your article. It’s interesting content and Great work.
    Thanks & Regards,
    VRIT Professionals,
    No.1 Leading Web Designing Training Institute In Chennai.

    And also those who are looking for
    Web Designing Training Institute in Chennai
    SEO Training Institute in Chennai
    Photoshop Training Institute in Chennai
    PHP & Mysql Training Institute in Chennai
    Android Training Institute in Chennai

    ReplyDelete
  40. Hey, would you mind if I share your blog with my twitter group? There’s a lot of folks that I think would enjoy your content. Please let me know. Thank you.
    blue prism training in chennai | blue prism course in chennai | best blue prism training institute in chennai | blue prism course in chennai | blue prism automation in chennai | blue prism certification in chennai

    ReplyDelete
  41. Just saying thanks will not just be sufficient, for the fantasti c lucidity in your writing. I will instantly grab Python classes in pune your rss feed to stay informed of any updates.

    ReplyDelete
  42. Great Explanation with lots of useful information about aws and great explanation in this blog.

    AWS Training in Chennai | SAP Training in Chennai

    ReplyDelete
  43. Attractive section of content. I just stumbled upon your web site
    and in accession capital to assert that I get in fact enjoyed account
    your blog posts. Any way I will be subscribing to your feeds and even I achievement you access consistently quickly.
    https://www.zonetechsupport.com/activate-espn-on-roku/

    ReplyDelete
  44. I learned World's Trending Technology from certified experts for free of cost. I Got a job in decent Top MNC Company with handsome 14 LPA salary, I have learned the World's Trending Technology from Python training in pune experts who know advanced concepts which can help to solve any type of Real-time issues in the field of Python. Really worth trying instant approval blog commenting sites

    ReplyDelete
  45. Good
    https://www.wikitechy.com/interview-questions/aptitude/permutation-and-combination/how-many-groups-of-6-persons-can-be-formed

    https://www.wikitechy.com/tutorials/oracle/oracle-delete

    https://www.wikitechy.com/interview-questions/aptitude/time-and-work/a-alone-can-do-1-4-of-the-work-in-2-days

    https://www.wikitechy.com/technology/chrome-flags-complete-guide-enhance-browsing-experience/

    https://www.wikitechy.com/interview-questions/programming/recursion-and-iteration/integer-a-40-b-35-c-20-d-10-comment-about-the-output-of-the-following-two-statements

    https://www.wikitechy.com/tutorials/apache-pig/apache-pig-subtract-function

    https://www.wikitechy.com/errors-and-fixes/csharp/xml-serializer-there-was-an-error-reflecting-type

    https://www.wikitechy.com/interview-questions/aptitude/simple-interest/if-the-simple-interest-on-a-certain-sum-of-money

    https://www.wikitechy.com/interview-questions/aptitude/compound-interest/rs-5887-is-divided-between-shyam-and-ram

    https://www.wikitechy.com/letters/tag/specimen-presentation-of-letters-issued-by-company/

    ReplyDelete
  46. Great Article. As I read the blog I felt a tug on the heartstrings. it exhibits how much effort has been put into this.
    IEEE Projects for CSE in Big Data

    Spring Framework Corporate TRaining

    Final Year Project Centers in Chennai

    JavaScript Training in Chennai

    ReplyDelete
  47. thanks for sharing this such types of topics.
    AWS Solutions Architect Training in Bangalore
    https://onlineidealab.com/aws-training-in-bangalore/

    ReplyDelete
  48. thanks for informing us about this articles.
    AWS Certification course
    https://onlineidealab.com/aws-certification/

    ReplyDelete
  49. Nice Blog Thank you for sharing..
    Really nice and interesting.Automation Anywhere Training in Bangalore



    ReplyDelete
  50. This is most informative and also this post most user friendly and super navigation to all posts. Thank you so much for giving this information to me.microsoft azure training in bangalore





    ReplyDelete
  51. A lot of thanks, this information was pretty useful for me!!!

    ReplyDelete
  52. I must appreciate you for providing such a valuable content for us. This is one amazing piece of article. Helped a lot in increasing my knowledge.

    oracle training in bangalore

    ReplyDelete
  53. keep up the good work. this is an Assam post. this to helpful, i have reading here all post. i am impressed. thank you. this is our digital marketing training center. This is an online certificate course
    digital marketing training in bangalore | https://www.excelr.com/digital-marketing-training-in-bangalore

    ReplyDelete
  54. thank you sharing this blog, it is very useful information.
    Data science training bangalore

    ReplyDelete
  55. Best Web design and development company in Brampton
    A team of experience and energetic professionals expertise in all sort of web designing, web development, e-commerce and SEO marketing services.

    ReplyDelete
  56. Chauffeur cab service in Melbourne
    Silver Executive Cab is becoming the first choice of the people. It is only because of the best quality chauffeur cars & limos Melbourne. Our own VHA Chauffeur Cars & Limos network Melbourne.

    ReplyDelete
  57. Mortgage Broker in Gta Toronto
    We work with Canada's premium financial institutions to offer you the best mortgages in the market and the lowest interest rates. Names such as Royal Bank, Scotia Bank, Bank of Montreal, TD Canada Trust, CIBC, National Bank, and more, guarantee the best service and highest savings for you.

    ReplyDelete
  58. Best Real Estate Realtor in Toronto
    Many of you now need in home but you might be thinking where to spend because your home is your largest investment because generally home cost approx 500k Dollar and home is the place where you have to spend almost half of your life in the home so to choose right home for you we are here best real estate in Toronto.

    ReplyDelete
  59. Best Place For visit in India
    You are our priority. Our dedicated and trained team of customer care executives resolves all your queries and matters swiftly so that you can have delightful experience.

    ReplyDelete
  60. Travel Tours in India
    Within a short span of its existence LITEWINGS Travels, has emerged as a name to reckon with in the business of Inbound/outbound Tourism. We have adapted our operations to the fast-paced cyber world and bring you India, online. Now you have access to a wealth of information at your desktop just a click away

    ReplyDelete
  61. This is a splendid website! I"m extremely content with the remarks!.
    ExcelR Solutions

    ReplyDelete

My Name is..