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 [[email protected]] on behalf of Hummer, Greg Sent: Tuesday, October 27, 2015 7:47 AM To: [email protected] 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:[email protected]] On Behalf Of Maik Nergert Sent: Monday, October 26, 2015 4:05 AM To: [email protected] 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/...
