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

[Aaron Guise]

Hi Greg,

This certainly sounds like a mismatch as Maik suggested.   This happens
when I refresh my test/dev instance of RT from production also.

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.

I simply import the database and then execute /opt/rt4/sbin/rt-validator
--check --resolve --force

Once that is completed all ticket links are working again.

*Regards,*

*Aaron Guise*




*   07 850 3231 027 704 5306 aaron at guise.net.nz <aaron at guise.net.nz>  *
      <http://nz.linkedin.com/pub/aaron-guise/35/953/b86>


On Wed, Oct 14, 2015 at 3:23 AM, Hummer, Greg <Greg_Hummer at sra.com> wrote:

> Good morning, Maik.
>
> 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 (*It must fit to the values of field "base" and
> "target" in table "links"*)*.*
>
>
>
> 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.
>
>
>
> 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 $Organization variable as the production account.
>
>
>
> Thanks for the help!
>
> Greg
>
> ________________________________________
> From: rt-users [rt-users-bounces at lists.bestpractical.com] on behalf of
> Maik Nergert [maik.nergert at uni-hamburg.de]
> Sent: Friday, October 09, 2015 2:12 AM
> To: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Ticket Links missing post upgrade/conversion to
> Oracle 4.2.11.
>
> Hey Greg,
>
> please check if your $Organization variable is set in RT_SiteConfig.pm
> It must fit to the values of field "base" and "target" in table "links"
>
> If your code snipped is correct then
> Set( $Organization, 'example.com' );
>
>
> best
> Maik
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20151022/9abba575/attachment.htm>