Dynamics CRM 2011

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.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) 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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ITsolutionWizardAuthor Commented:
We need Dynamics CRM 2011 PRO to answer this question. But I do appreciate Slighwv helps.
Chinmay PatelChief Technology NinjaCommented:

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

Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:

Can you post your query here?
slightwv (䄆 Netminder) 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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.