<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style id="owaParaStyle" type="text/css">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
P {margin-top:0;margin-bottom:0;}</style>
</head>
<body ocsi="0" fpstyle="1">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;"><br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<div style="direction: ltr;" id="divRpF626018"><font color="#000000" size="2" face="Tahoma"></font><br>
</div>
<div></div>
<div>Good afternoon,<br>
<br>
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.
<br>
<br>
<b>On the bad links I get the following:</b><br>
<i><input type=“checkbox” class=“checkbox” id=“DeleteLink-fsck.com-rt://<b>example.com</b>/ticket/101611-RefersTo” name = “DeleteLink-fsck.com-rt://<b>example.com</b>/ticket/101611-RefersTo-: value=”1”></i><br>
<br>
<b>On recently created- good links, I get this:</b><br>
<i><input type=“checkbox” class=“checkbox” id=“DeleteLink-fsck.com-rt://<b>abc.com</b>/ticket/101611-RefersTo” name = “DeleteLink-fsck.com-rt://<b>abc.com/</b>ticket/101611-RefersTo-: value=”1”></i><br>
<br>
<br>
When we pulled two lines out of the Link table, we get the following:<br>
<i>15367 fsck.com-rt://<b>example.com</b>/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
</i><br>
<br>
In the sage account (which has all good links) this same ID shows up like this:<br>
<i>15367 fsck.com-rt://<b>abc.com</b>/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</i><br>
<br>
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:<br>
<i><br>
ORA-00001: unique constraint (RT3EMTS.LINKS1) violated</i><br>
<br>
Here is the MySQL we tried to use:<br>
UPDATE links SET BASE = REPLACE(BASE,'example.com','abc.com') WHERE BASE LIKE '%example.com%';<br>
<br>
Does anyone have any suggestions how to get around this Oracle error when trying to adjust the domain in the links?<br>
<br>
Thanks for the help.<br>
<br>
Greg<br>
<br>
________________________________________<br>
From: rt-users [rt-users-bounces@lists.bestpractical.com] on behalf of Hummer, Greg<br>
Sent: Tuesday, October 27, 2015 7:47 AM<br>
To: rt-users@lists.bestpractical.com<br>
Subject: Re: [rt-users] Ticket Links missing post upgrade/conversion to Oracle 4.2.11.<br>
<br>
New tickets links, created post upgrade/conversion, are displayed correctly. It is only the old ticket links are not displaying correctly.<br>
<br>
Greg<br>
<br>
-----Original Message-----<br>
From: rt-users [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Maik Nergert<br>
Sent: Monday, October 26, 2015 4:05 AM<br>
To: rt-users@lists.bestpractical.com<br>
Subject: Re: [rt-users] Ticket Links missing post upgrade/conversion to Oracle 4.2.11.<br>
<br>
What about new links after the upgrade? Are they displayed correctly?<br>
<br>
Do 'select * from links where localbase=TICKETID'<br>
and compare the base and target value of old TICKETIDs (before upgrade)<br>
and new Tickets. Both has to be fsck.com-rt://abc.com/ticket/...<br>
<br>
</div>
</div>
</div>
</body>
</html>