All,
I’ve been going back through our RT system and I’ve noticed that links between “old” tickets are missing/broken. I think that I understand the reason for this but I’d appreciate someone confirming it for me before I hack the database (and potentially break things).
When I look at the tickets, I see things like:
Fri Feb 01 12:00:46 2008 fred - Dependency by added
The system is reporting that there is a Dependency relationship but not picking up which ticket is at the other end of it.
Picking around in the database itsefl, I see that the relationships seem to be in the Links table and that the items added to the tickets are in the Transactions table. I also note that there is a difference between “Base”/“Target” and “LocalBase”/“LocalTarget” in that the former also contains the sitename. It is this that I think is causing the problems.
We moved domain name some time ago and I suspect that the problems arise from this. The sitename in the Links that are “missing” is the old site name.
So, am I on the right track here? If I do a global find/replace on the old sitename, converting it to the new one, will all my links spring into life again or will I just trash the whole system? If this is the way to go, apart from Links (Base|Target) and Transactions (NewValue) what else will I need to tweak?
Thanks in advance.
Later,
Andy
Yada, yada, yada…
The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336
Disclaimer: This e-mail and any attachments are confidential and intended solely for the use of the recipient(s) to whom they are addressed. If you have received it in error, please destroy all copies and inform the sender.
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.
All,
I’ve been going back through our RT system and I’ve noticed that
links between “old” tickets are missing/broken. I think that I
understand the reason for this but I’d appreciate someone confirming
it for me before I hack the database (and potentially break things).
If you’ve changed your Organization in your RT config, then yes, you
will need to repair your Links and Transactions table to have the
correct Organization. Ensure you have a proper backup before starting
of course.
-kevin
All,
I’ve been going back through our RT system and I’ve noticed that
links between “old” tickets are missing/broken. I think that I
understand the reason for this but I’d appreciate someone confirming
it for me before I hack the database (and potentially break things).
If you’ve changed your Organization in your RT config, then yes, you
will need to repair your Links and Transactions table to have the
correct Organization. Ensure you have a proper backup before starting
of course.
Thanks for that confirmation.
You would not believe what level/number of backups that I have :o} (it is a number far greater than zero).
In progressing this, I found that I had re-asserted some of the links and so I tripped up with duplicate keys in the Links table. I simply deleted the later records in each case but I suspect that I now have trailing records in the Transactions table. Do I need to clean those out or am I safe to just ignore them?
Later,
Andy
Yada, yada, yada…
The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336
Disclaimer: This e-mail and any attachments are confidential and intended solely for the use of the recipient(s) to whom they are addressed. If you have received it in error, please destroy all copies and inform the sender.
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.
All,
I’ve been going back through our RT system and I’ve noticed that
links between “old” tickets are missing/broken. I think that I
understand the reason for this but I’d appreciate someone confirming
it for me before I hack the database (and potentially break things).
If you’ve changed your Organization in your RT config, then yes, you
will need to repair your Links and Transactions table to have the
correct Organization. Ensure you have a proper backup before starting
of course.
Thanks for that confirmation.
You would not believe what level/number of backups that I have :o} (it is a number far greater than zero).
In progressing this, I found that I had re-asserted some of the links and so I tripped up with duplicate keys in the Links table. I simply deleted the later records in each case but I suspect that I now have trailing records in the Transactions table. Do I need to clean those out or am I safe to just ignore them?
To follow-up my own post, leaving the “orphan” records in the Transactions table causes no problems and results in the correct, double record of Link addition being reported in the Summary.
Thanks to Kevin (and Matthew - offlist) for their helpful replies.
Later,
Andy
Yada, yada, yada…
The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336
Disclaimer: This e-mail and any attachments are confidential and intended solely for the use of the recipient(s) to whom they are addressed. If you have received it in error, please destroy all copies and inform the sender.
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.