0 Replies Latest reply on Jan 26, 2015 11:41 AM by bsisson

    Getting new error in SQL Server generated by login "Ignite"

    bsisson

      I just started getting the error below from DPA.  I'm running DPA on SQL Server 2012, monitoring SQL Server 2012.  I recently created some drive letters, all mapped to the same folder on disk in this environment, so I assume that has something to do with the error given its reference to drives.  The multiple drive letters were created so that the lower environments with only one physical drive would have folders mapped to the drive letters of the SAN in production so we don't have to change code that refers to the drives by letter.  Is the error something that needs to be corrected, or is it just going to be an annoyance?

       

      The drive mappings look like this in [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\DOS Devices] and work fine:

       

      "S:"="\\??\\D:"

      "T:"="\\??\\D:"

      "U:"="\\??\\D:"

      "V:"="\\??\\D:"

       

      Violation of PRIMARY KEY constraint 'PK__CONF_DRI__6784C9A4C4DD0C58'. Cannot insert duplicate key in object 'ignite.CONF_DRIVE_MAP_2'. The duplicate key value is (151).


      Thanks in advance for any help you can offer.