ITsolutionWizard
asked on
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.
https://community.dynamics.com/crm/f/117/t/226832
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.c om/?p=opti onsetmanag er
Regards,
Chinmay.
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.c
Regards,
Chinmay.
Hi,
Can you post your query here?
Can you post your query here?
>>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.
I understood that. I was just wondering it if auto-committed or if there was some option/setting to commit the newly inserted data.
ASKER