<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(102,102,102)">Hi Greg, <br><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(102,102,102)">This certainly sounds like a mismatch as Maik suggested. This happens when I refresh my test/dev instance of RT from production also. <br><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(102,102,102)">I then run the rt-validator over the database and this corrects all the mismatched links. This is needed as I use the server hostname as the Organization and this does differ between environments. <br><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(102,102,102)">I simply import the database and then execute /opt/rt4/sbin/rt-validator --check --resolve --force <br><br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(102,102,102)">Once that is completed all ticket links are working again.<br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><b>Regards,</b><br><br><b>Aaron Guise</b><br><div dir="ltr"><div><blockquote style="margin:1.5em 0pt"><p><b>
<img src="http://www.guise.net.nz/images/signatures/ph.jpg" border="0" height="22" width="25">
07 850 3231<br>
<img src="http://www.guise.net.nz/images/signatures/mob.gif" border="0" height="24" width="30">027 704 5306<br>
<img src="http://www.guise.net.nz/images/signatures/email.gif" border="0" height="26" width="29"><a href="mailto:aaron@guise.net.nz" target="_blank">aaron@guise.net.nz</a><br>
</b><br>
<img src="http://www.guise.net.nz/images/signatures/itil_logo.gif" height="30"> <img src="http://www.guise.net.nz/images/signatures/officiallogo-nd-25.jpg"> <img src="http://www.guise.net.nz/images/signatures/ubuntu.png" height="30"> <a href="http://nz.linkedin.com/pub/aaron-guise/35/953/b86" target="_blank"><img src="http://www.linkedin.com/img/webpromo/btn_profile_greytxt_80x15.png"></a></p></blockquote></div></div></div></div></div>
<br><div class="gmail_quote">On Wed, Oct 14, 2015 at 3:23 AM, Hummer, Greg <span dir="ltr"><<a href="mailto:Greg_Hummer@sra.com" target="_blank">Greg_Hummer@sra.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div style="direction:ltr;font-family:Tahoma;color:#000000;font-size:10pt">
<div>
<p class="MsoNormal" style="margin-bottom:0.0001pt"><span style="font-size:10pt;font-family:Tahoma,sans-serif">Good morning, Maik.<br>
<br>
My technical team checked our production RT and found the $organization variable. It appeared to be correct, however, they were unsure what you meant when you said (</span><i><span style="font-size:10pt;font-family:Tahoma,sans-serif">It must fit to the
values of field "base" and "target" in table "links"</span></i><span style="font-size:10pt;font-family:Tahoma,sans-serif">)</span><i><span style="font-size:10pt;font-family:Tahoma,sans-serif">.</span></i><span style="font-size:10pt;font-family:Tahoma,sans-serif"> </span><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-bottom:0.0001pt"><span style="font-size:10pt;font-family:Tahoma,sans-serif"> </span></p>
<p class="MsoNormal" style="margin-bottom:0.0001pt"><span style="font-size:10pt;font-family:Tahoma,sans-serif">Can you provide more directions on what you meant? The more specific you can be, the better it would be for my non-Request Tracker DBA's. <u></u><u></u></span></p>
<p class="MsoNormal" style="margin-bottom:0.0001pt"><span style="font-size:10pt;font-family:Tahoma,sans-serif"> </span></p>
<p class="MsoNormal" style="margin-bottom:0.0001pt"><font face="Tahoma, sans-serif"><span style="font-size:10pt">Some additional information: we have a stage server that is currently running the same version of request tracker (4.2.11 Oracle). It is a copy
of our production database from a few months ago. It is showing the ticket links and has the same $</span>Organization<span style="font-size:10pt"> variable as the production account.<u></u><u></u></span></font></p>
<p class="MsoNormal" style="margin-bottom:0.0001pt"><span style="font-size:10pt;font-family:Tahoma,sans-serif"> </span></p>
<p class="MsoNormal" style="margin-bottom:0.0001pt"><span style="font-size:10pt;font-family:Tahoma,sans-serif">Thanks for the help!<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-bottom:0.0001pt"><span style="font-size:10pt;font-family:Tahoma,sans-serif">Greg<u></u><u></u></span></p>
<br>
________________________________________<br>
From: rt-users [<a href="mailto:rt-users-bounces@lists.bestpractical.com" target="_blank">rt-users-bounces@lists.bestpractical.com</a>] on behalf of Maik Nergert [<a href="mailto:maik.nergert@uni-hamburg.de" target="_blank">maik.nergert@uni-hamburg.de</a>]<br>
Sent: Friday, October 09, 2015 2:12 AM<br>
To: <a href="mailto:rt-users@lists.bestpractical.com" target="_blank">rt-users@lists.bestpractical.com</a><br>
Subject: Re: [rt-users] Ticket Links missing post upgrade/conversion to Oracle 4.2.11.<br>
<br>
Hey Greg,<br>
<br>
please check if your $Organization variable is set in RT_SiteConfig.pm<br>
It must fit to the values of field "base" and "target" in table "links"<br>
<br>
If your code snipped is correct then<br>
Set( $Organization, '<a href="http://example.com" target="_blank">example.com</a>' );<br>
<br>
<br>
best<br>
Maik<br>
<br>
</div>
</div>
</div>
</blockquote></div><br></div>