help in updating mssql db from 3.0.9 to 3.1.1

Moderator: crythias

Post Reply
waikiki83
Znuny newbie
Posts: 28
Joined: 25 Jul 2011, 09:15
Znuny Version: 3.0.9

help in updating mssql db from 3.0.9 to 3.1.1

Post by waikiki83 »

hi i am encountering errors when running the DBUpdate-to-3.1.mssql, the error message is:

The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.ticket_flag' and the index name 'ticket_flag_per_user'. The duplicate key value is (3234, Seen, 28).
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.


Please help...

Thanks in advance...
OTRS 3.3.1 Windows Server 2008, Apache, MS SQL Server 2008
mikecs
Znuny newbie
Posts: 9
Joined: 25 Jan 2012, 19:41
Znuny Version: 3.0.11
Real Name: Mike

Re: help in updating mssql db from 3.0.9 to 3.1.1

Post by mikecs »

Hello,

same error here, any hints if this is problematic? or how to resolve?

Versiono 3.0.11 to 3.1.2

DB Update to 3.1 mssql
OTRS 3.1.2
MSSQL
IIS7.5
Post Reply