Dynamics CRM 2011

ITsolutionWizard
ITsolutionWizard used Ask the Experts™
on
CRM2011 - Problem with Option Set values not showing in the DB.

Basically, i insert a record to optionset and on crm 2011 - i see everything but when i query database. I do not see new record.
any one has idea how to fix it?

Please read below and you know the problem exactly.

https://community.dynamics.com/crm/f/117/t/226832
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
I don't know anything about CRM 2011.  I just wanted to mention that when something inserts data into a database and can see it and nothing else can, it is almost always a commit issue.

Generally, the session that inserts data is the only one that can see it until it is committed.

Author

Commented:
We need Dynamics CRM 2011 PRO to answer this question. But I do appreciate Slighwv helps.
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
Hi,

Interesting issue. So the question is similar to yours OR it is your question on MSDN Social?
I just want to know so I can avoid asking the repeat questions.

Also, as suggested in original post did you try publishing all customizations one more time? OR even better, restart the server/s themselves. CRM 2011 is one of the most used version out there and was full of such surprises. I have few more suggestions but first things first,
1. As suggested in original post, do a Publish All.
2. Check StringMap table and find out if the OptionSet exists or not?
3. If possible, share the query you are using - we might be able to figure out something that we don't see it right now.
4. If possible, Restart IIS, Restart Async Service - Never underestimate what Async Service can do - it looks very innocent and acts innocent - but it is generally the culprit to WHAT IN THE WORLD kind of situations in CRM 2011.
5. Did you try to do any unsupported customizations i.e. did you make any changes directly database (maybe not you, but someone else)
6. Was there any other OptionSet value before this one with similar value/text within the same OptionSet?

A colleague of mine wrote an OptionSet Manager, you can download it from CodePlex, you can download it from here: https://archive.codeplex.com/?p=optionsetmanager

Regards,
Chinmay.
Rikin ShahMicrosoft Dynamics CRM Consultant

Commented:
Hi,

Can you post your query here?
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>We need Dynamics CRM 2011 PRO to answer this question.

I understood that.  I was just wondering it if auto-committed or if there was some option/setting to commit the newly inserted data.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial