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.

99 comments:

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

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

    ReplyDelete
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. This comment has been removed by the author.

    ReplyDelete
  11. 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
  12. 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
  13. 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
  14. This comment has been removed by the author.

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

  16. 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
  17. 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
  18. 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
  19. 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
  20. For Devops Training In Bangalore Visit: Devops Training in Bangalore

    ReplyDelete
  21. 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
  22. thanks for sharing this such types of topics.
    AWS Solutions Architect Training in Bangalore
    https://onlineidealab.com/aws-training-in-bangalore/

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

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

    ReplyDelete
  25. 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
  26. thank you sharing this blog, it is very useful information.
    Data science training bangalore

    ReplyDelete
  27. 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
  28. 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
  29. 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
  30. 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
  31. 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
  32. 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
  33. 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. keep share a lot
    Ai & Artificial Intelligence Course in Chennai
    PHP Training in Chennai
    Ethical Hacking Course in Chennai Blue Prism Training in Chennai
    UiPath Training in Chennai

    ReplyDelete
  34. Learn Amazon Web Services for making your career towards a sky-high with Infycle Technologies. Infycle Technologies is the best AWS training center in Chennai, providing courses for the AWS Training in Chennai in 200% hands-on practical training with professional trainers in the domain. Apart from the coaching, the placement interviews will be arranged for the students, so that they can set their career without any struggle. Of all that, 100% placement assurance will be given here. To have the best career, call 7502633633 to Infycle Technologies and grab a free demo to know more.Best AWS Training in Chennai

    ReplyDelete
  35. Techforce services is a Salesforce Consulting Services in Australia Specialising in delivering end to end Salesforce solutions ,Consulting, Implementation DevOps partners in australia We deliver applications and services more rapidly and reliably, but it’s more than a methodology – it cuts to the very core.Salesforce Data Analytics let us help you become a data driven organisation and ensure your data is working hard for your business This includes implementi
    Techforce services in Australia
    Salesforce Consulting Services in Australia
    Salesforce Staff Augmentation in Australia
    Salesforce Data Analytics
    DevOps Partners in Australia
    Managed Projects Salesforce Australia

    ReplyDelete
  36. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…

    DevOps Training in Hyderabad

    ReplyDelete
  37. Thanks For Sharing The Information The Information Shared Is Very Valuable Please Keep Updating Us
    by cognex is the AWS Training in Chennai

    ReplyDelete
  38. Thanks For Sharing The Information The Information Shared Is Very Valuable Please Keep Updating Us
    by cloudi5 is the best Web Design Company in Coimbatore

    ReplyDelete
  39. Nice Content If you are looking best business accountant software then you can click on
    quickbooks customer service +18557297482

    ReplyDelete
  40. Amazing! What an incredible blog. Are you facing problems quickbooks issue , just dial 
    quickbooks customer service +1 855-675-3194

    ReplyDelete
  41. Your blog great If you are looking for answer about your Quickbooks questions then you can call at
    quickbooks customer service+1 855-428-7237

    ReplyDelete
  42. Very good information if you are looking for help Quickbooks software then you can contact our team at quickbooks customer service+1 347-982-0046

    ReplyDelete
  43. Good Content We re also Providing QuickBooks Customer Service team +18559773297 that
    they helps the customers with the problems they face in their accounting software.

    ReplyDelete
  44. Very Informative Blog Thanks For Sharing Get Technical Quickbooks Support at our t Supportive team at quickbooks customer service+1 855-377-7767

    ReplyDelete
  45. Very good and inspired Content If you are looking Good Service For Quicken Books, then contact your Quickbooks representative for details at
    Quickbooks Support+1 877-755-5046

    ReplyDelete
  46. Hello Nice Blog ! If you are searching accounting service then you can contact for instant help at Quickbooks Customer Service+1 717-844-9353

    ReplyDelete
  47. Our Full Stack Training Centre Hands-on training is a critical component of Full stack training and Full stack training institute , provide students with the opportunity to work on real-world projects. These projects help students gain practical experience in developing Full stack applications and prepare them for a career in Full stack development.

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

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

    ReplyDelete
  50. Very good Informations ! If you are looking Regarding Quickbooks Issue you can get instant help in the at Quickbooks Customer Service +18663062642

    ReplyDelete
  51. I m very happy After Read Your Blog !! If you are looking Professional
    Quickbooks Customer Service+18554442233 to get best technical solutions for QuickBooks errors.

    ReplyDelete
  52. QuickBooks is best Software for your managing business Financial Task f you're looking for help in using it, just dial Quickbooks Customer Support +18663062642

    ReplyDelete
  53. very impressive blog ! QuickBooks most trusted accounting software s. If you are looking for help with QuickBooks, then call them at Quickbooks customer service: +1 717-844-9353

    ReplyDelete
  54. QuickBooks is effective and popular accounting software that helps you manage all the finance and accounting related tasks of business.if you have any questions related to their Quickbooks Software then contact our team at
    Quickbooks Customer Support+1 855-604-1500

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

    ReplyDelete
  56. QuickBooks is popular accounting software .It also tracks sales, accounts receivable, payroll, inventory, and much more Dialling
    Quickbooks Customer Support +1 855-377-7767 will provide answers to your questions

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

    ReplyDelete
  58. Get Quickbooks Customer Support+18777555046 For Financial need for youe business

    ReplyDelete
  59. Here is an amazing Blog Informations !If you are struggling with a QuickBooks issue, Dialing the number of the
    Quickbooks Customer Support +1 267-773-4333

    ReplyDelete
  60. QuickBooks is a very famous accounting software that can help you keep track of your expenses, income, and cash flow you can contact us
    Quickbooks Customer Support : +1 855-377-7767

    ReplyDelete
  61. if you still want quick help from QuickBooks,, you can dial the QuickBooks helpline on
    QuickBooks Customer Service +18559411563 and talk to one of their representatives.

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

    ReplyDelete
  63. Quickbooks is amazing software in the world. For more information about Quickbooks then dial Quickbooks customer service +1 602-362-8345 and get help from a professional.Quickbooks is amazing software in the world. For more information about Quickbooks then dial Quickbooks customer service +1 602-362-8345 and get help from a professional.

    ReplyDelete
  64. If you’re looking popular accounting Software then you can click on
    QuickBooks customer service +1 877-755-5046 to get the solution

    ReplyDelete
  65. By Dialing QuickBooks customer service +1 267-773-4333 for online customer Service to resolve your QuickBooks

    ReplyDelete
  66. Nice post Thanks !The QuickBooks customer service representatives are very helpful and friendly. If you are going through any issue while operating the software, connect with an expert team at QuickBooks and get the best hindering solutions. customer service +1 855-377-7767

    ReplyDelete
  67. QuickBooks is a software program that makes managing the finances of a small business If you are looking for contact information for QuickBooks then be sure to give them a call QuickBooks customer service +1 855-941-1563

    ReplyDelete
  68. Thanks for sharing such informative and useful blog.
    SQL training in Pune

    ReplyDelete
  69. Nice blog ! If you have any query regarding your QuickBooks Software then you can connect with

    QuickBooks Customer Service +1 833-738-9721 to get best solutions

    ReplyDelete

My Name is..