[rt-users] Link Relationships Missing: RT 363 to 380 or 382

[O'Leary, Paul]

Hello

 

I am trying to upgrade from 3.6.3 to 3.8 or 3.8.2. I initially tried
going to 380, using the a copy of the same database that 363 was using
in Oracle. I ran the database upgrade scripts fine, and was able to
connect to it fine and do just about everything. I say just about, as I
noticed that all the links and child/parent relationships are gone from
the tickets. I checked the messages file and noticed that I get this
entry for a bunch of tickets. The look like the entries in the links
table, so I am assuming they are related to my dilemma. Can anyone tell
me what has happened to my links. I'll include an entry from the links
table from my production system and one from my current 380 dev system
for comparison. 

 

Current PROD system (running 363) link table entry: (sorry for the
formatting...sqlplus output is too wide) - this still works, links show
in tickets.

                                 

 

        ID

----------

BASE

------------------------------------------------------------------------
------------------------------------------------------------------------
--------------------------------------------------------

TARGET

------------------------------------------------------------------------
------------------------------------------------------------------------
--------------------------------------------------------

TYPE                 LOCALTARGET  LOCALBASE LASTUPDATEDBY LASTUPDAT
CREATOR CREATED

-------------------- ----------- ---------- ------------- ---------
---------- ---------

     35201

fsck.com-rt://BreconRidge.com/ticket/136735

fsck.com-rt://BreconRidge.com/ticket/138005

MemberOf                  138005     136735         93547 12-FEB-09
93547 12-FEB-09

 

 

Current DEV system running 382 (was 380):

 

        ID

----------

BASE

------------------------------------------------------------------------
------------------------------------------------------------------------
--------------------------------------------------------

TARGET

------------------------------------------------------------------------
------------------------------------------------------------------------
--------------------------------------------------------

TYPE                 LOCALTARGET  LOCALBASE LASTUPDATEDBY LASTUPDAT
CREATOR CREATED

-------------------- ----------- ---------- ------------- ---------
---------- ---------

     24760

fsck.com-rt://BreconRidge.com/ticket/133271

fsck.com-rt://BreconRidge.com/ticket/133270

MemberOf                  133270     133271          3015 12-SEP-08
3015 12-SEP-08

 

ERROR from messages file on DEV system:

 

Feb 12 13:34:57 brerttest RT: Resolver RT::URI::fsck_com_rt could not
parse fsck.com-rt://BreconRidge.com/ticket/115007
(/usr/local/rt/bin/../lib/RT/URI.pm:147)

 

I haven't seen too much documentation or threads on this in my seaches.
There was one from 2005 that went unanswered. This is the only issue
stopping from roling up to 382 right now. Any help would be appreciated.

 

Cheers

 

Paul



"This email is confidential. Any unauthorized use or disclosure is 
strictly prohibited."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090212/e08134ce/attachment.htm>