[rt-users] Ticket Links missing post upgrade/conversion to Oracle 4.2.11.

[Hummer, Greg]

Good afternoon,

I can confirm it is most likely due to an organization. The organization in our System Configuration prior to the Conversion/Upgrade matches the setting after. This was confirmed though googles “Inspect Element” feature.

On the bad links I get the following:
<input type=“checkbox” class=“checkbox” id=“DeleteLink-fsck.com-rt://example.com/ticket/101611-RefersTo” name = “DeleteLink-fsck.com-rt://example.com/ticket/101611-RefersTo-: value=”1”>

On recently created- good links, I get this:
<input type=“checkbox” class=“checkbox” id=“DeleteLink-fsck.com-rt://abc.com/ticket/101611-RefersTo” name = “DeleteLink-fsck.com-rt://abc.com/ticket/101611-RefersTo-: value=”1”>


When we pulled two lines out of the Link table, we get the following:
15367 fsck.com-rt://example.com/ticket/100005 fsck.com-rt://abc.com/ticket/99902 MergedInto 99902 99902 184988 4/29/2014 4:10:48 PM 184988 4/29/2014 4:10:48 PM

In the sage account (which has all good links) this same ID shows up like this:
15367 fsck.com-rt://abc.com/ticket/100005 fsck.com-rt://abc.com/ticket/99902 MergedInto 99902 99902 184988 4/29/2014 4:10:48 PM 184988 4/29/2014 4:10:48 PM

So then we went about trying to fix it. We used RT-Validator with force, RT-Validator with links, and finally the MySQL below. Each time, with each of the previous three items, we got the following error:

ORA-00001: unique constraint (RT3EMTS.LINKS1) violated

Here is the MySQL we tried to use:
UPDATE links SET BASE = REPLACE(BASE,'example.com','abc.com') WHERE BASE LIKE '%example.com%';

Does anyone have any suggestions how to get around this Oracle error when trying to adjust the domain in the links?

Thanks for the help.

Greg

________________________________________
From: rt-users [rt-users-bounces at lists.bestpractical.com] on behalf of Hummer, Greg
Sent: Tuesday, October 27, 2015 7:47 AM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Ticket Links missing post upgrade/conversion to Oracle 4.2.11.

New tickets links, created post upgrade/conversion, are displayed correctly. It is only the old ticket links are not displaying correctly.

Greg

-----Original Message-----
From: rt-users [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Maik Nergert
Sent: Monday, October 26, 2015 4:05 AM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Ticket Links missing post upgrade/conversion to Oracle 4.2.11.

What about new links after the upgrade? Are they displayed correctly?

Do 'select * from links where localbase=TICKETID'
and compare the base and target value of old TICKETIDs (before upgrade)
and new Tickets. Both has to be fsck.com-rt://abc.com/ticket/...

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20151117/b1fb5739/attachment.htm>