On viewing a ticket or the full ticket history I am receive an error message:
Bizarre copy of UNKNOWN in sassign at /opt/rt4/share/html/Ticket/Elements/ShowMessageStanza line 95. Looks like the transaction contains a massive amount of data a user pasted into the ticket. I have a search on the RT at a glance page which returns the last reply in a ticket, which displays the content fine. First few lines of the content, in case it's relevant: Msg 2627, Level 14, State 1, Line 150 Violation of PRIMARY KEY constraint 'PK_tbl_SchemeAreaPostcodes_lkp'. Cannot insert duplicate key in object 'dbo.tbl_SchemeAreaPostcodes_lkp'. The duplicate key value is (170, CR06AA). The statement has been terminated.Msg 2627, Level 14, State 1, Line 151 Violation of PRIMARY KEY constraint 'PK_tbl_SchemeAreaPostcodes_lkp'. Cannot insert duplicate key in object 'dbo.tbl_SchemeAreaPostcodes_lkp'. The duplicate key value is (170, CR06AB). The statement has been terminated.Msg Any idea what has happened or how I can fix it to display the ticket correctly? Thanks.
-- RT Training in Seattle, June 19-20: http://bestpractical.com/training