Unique constraint error on SQL server (OD-622)
Robin Shen opened 4 years ago

It seems that there is a problem with database field o_Project.o_serviceDeskName (in case of using MSSQL as DBMS). The problem is in unique constraint: as you may know in MSSQL NULL is treated as distinct value and having two projects with o_serviceDeskName = NULL lead to constraint violation. Also there is no means to enter this value in UI. The workarounds are to setup this value straight inside database or change (remove) this unique constraint. I know that in other databases unique constraints allow to have multiple NULL values (Oracle, MySQL,...) and I believe that this is logical and correct behavior. But sadly we are forced to use MSSQL for now...

  • Robin Shen changed fields 4 years ago
    Name Previous Value Current Value
    Priority
    Normal
    Major
  • OneDev changed state to 'Closed' 4 years ago
    Previous Value Current Value
    Open
    Closed
  • OneDev commented 4 years ago

    State changed as code fixing the issue is committed

  • OneDev changed state to 'Released' 4 years ago
    Previous Value Current Value
    Closed
    Released
  • OneDev commented 4 years ago

    State changed as build #2369 is successful

issue 1/1
Type
Bug
Priority
Major
Assignee
Affected Versions
Not Found
Issue Votes (1)
Watchers (4)
Reference
OD-622
Please wait...
Connection lost or session expired, reload to recover
Page is in error, reload to recover