Bizarre error message - RT 4.0.5

RT Users
1

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.

2

Hi,

This error is usually indication of bug in perl itself or a module that
uses binary parts. The correct way is to upgrade perl to a newer version
and/or rebuild all module with binary components.On Wed, Jun 5, 2013 at 6:43 PM, Alex Young AlexYoung@housingpartners.co.ukwrote:

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

Best regards, Ruslan.