locked
CRM Server 2013 option set SQL server RRS feed

  • Question

  • 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

  • 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

  • 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
  • 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
  • Thanks Steve, that's exactly what happend! :)
    Tuesday, February 11, 2014 7:21 AM