Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM Server 2013 option set SQL server RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    We have a problem in our SQL database from CRM.
    Apparently, all our option sets are duplicated (in the database), but in CRM we only see 1 option set. (example: we created an option set language. In CRM it displays 1 option set, in the database 2 (same name, id, ...)

    Don't know how this happend, but it causes problems for our triggers to another database...

    Any idea why suddenly our option sets "copied" themselves?

    Thanks!

    Monday, February 10, 2014 2:21 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Maybe somebody changed the option set. Until it becomes published again it will be duplicated.

    You can check the version number and state in the database. Just use only the published one for your trigger.

    steve

    Steve Sämmang, Vienna, Austria
    Blog: xrm.io Website: simplic.at

    • Marked as answer by Alexander_DM Tuesday, February 11, 2014 7:20 AM
    Monday, February 10, 2014 3:43 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Update: for some reason, the second option set (the copied one) is gone again...

    Does anybody have an idea how this could happend?

    Monday, February 10, 2014 3:16 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Maybe somebody changed the option set. Until it becomes published again it will be duplicated.

    You can check the version number and state in the database. Just use only the published one for your trigger.

    steve

    Steve Sämmang, Vienna, Austria
    Blog: xrm.io Website: simplic.at

    • Marked as answer by Alexander_DM Tuesday, February 11, 2014 7:20 AM
    Monday, February 10, 2014 3:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks Steve, that's exactly what happend! :)
    Tuesday, February 11, 2014 7:21 AM