We have a couple of tickets that are not allowing us to resolve them,
reporting “That ticket has unresolved dependencies”. Looking at the
ticket Links there are no dependencies listed.
Does anyone have any suggestions about how to either resolve the
offending tickets, or locate any linked tickets that it may think are
dependencies but for some reason are not being shown?
Thanks for the assist.
BenR
Ben,
I would look at the DataBase. Try this SQL:
select * from LIMKS
where LOCALTARGET = 99999
or LOCALBASE = 99999;
99999 is the ticket id in question. Anyway, once you have that little
query up, look to see if there is some records that shows the
dependency. The TYPE field will indicate what’s up. Hope this helps.
Kenn
LBNLOn 2/25/2008 6:03 PM, Ben Robson wrote:
We have a couple of tickets that are not allowing us to resolve them,
reporting �That ticket has unresolved dependencies�. Looking at the
ticket Links there are no dependencies listed.Does anyone have any suggestions about how to either resolve the
offending tickets, or locate any linked tickets that it may think are
dependencies but for some reason are not being shown?Thanks for the assist.
BenR
The information contained in this communication is intended solely
for the use of the individual or entity to whom it is addressed and
others authorised to receive it. It may contain confidential or legally
privileged information. If you are not the intended recipient you are
hereby notified that any disclosure, copying, distribution or taking any
action in reliance on the contents of this information is strictly
prohibited and may be unlawful. If you have received this communication
in error, please notify us immediately by responding to this email and
then delete it, and any associated attachments, from your system. Thank
you.
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Ben,
Sorry. I meant LINKS not LIMKS. HA! fat fingers again.
Kenn
LBNLOn 2/26/2008 9:43 AM, Kenneth Crocker wrote:
Ben,
I would look at the DataBase. Try this SQL:
select * from LIMKS
where LOCALTARGET = 99999
or LOCALBASE = 99999;99999 is the ticket id in question. Anyway, once you have that little
query up, look to see if there is some records that shows the
dependency. The TYPE field will indicate what’s up. Hope this helps.Kenn
LBNLOn 2/25/2008 6:03 PM, Ben Robson wrote:
We have a couple of tickets that are not allowing us to resolve them,
reporting �That ticket has unresolved dependencies�. Looking at the
ticket Links there are no dependencies listed.Does anyone have any suggestions about how to either resolve the
offending tickets, or locate any linked tickets that it may think are
dependencies but for some reason are not being shown?Thanks for the assist.
BenR
The information contained in this communication is intended solely
for the use of the individual or entity to whom it is addressed and
others authorised to receive it. It may contain confidential or legally
privileged information. If you are not the intended recipient you are
hereby notified that any disclosure, copying, distribution or taking any
action in reliance on the contents of this information is strictly
prohibited and may be unlawful. If you have received this communication
in error, please notify us immediately by responding to this email and
then delete it, and any associated attachments, from your system. Thank
you.
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Kenn,
Thanks for this. I have done as you suggested and have had the
following results, but can not see what might be causing the issue
(unless there is some confusion within RT for assets in the AT addon.
Any additional guidance you (or others) can provide would be greatly
appreciated.
Result from query: select * from Links where localtarget=425 or
localbase=425;
| id | Base | Target
| Type | LocalTarget | LocalBase | LastUpdatedBy | LastUpdated
| Creator | Created |
| 544 | at://tlcdatasecurity.com.au/asset/425 |
at://tlcdatasecurity.com.au/asset/424 | DependsOn | 424 |
425 | 52 | 2007-12-14 05:27:07 | 52 | 2007-12-14
05:27:07 |
| 549 | fsck.com-rt://tlcdatasecurity.com.au/ticket/349 |
at://tlcdatasecurity.com.au/asset/425 | RefersTo | 425 |
349 | 52 | 2007-12-14 05:30:24 | 52 | 2007-12-14
05:30:24 |
| 635 | at://tlcdatasecurity.com.au/asset/521 |
at://tlcdatasecurity.com.au/asset/425 | ComponentOf | 425 |
521 | 52 | 2008-02-05 05:53:23 | 52 | 2008-02-05
05:53:23 |
| 636 | at://tlcdatasecurity.com.au/asset/522 |
at://tlcdatasecurity.com.au/asset/425 | ComponentOf | 425 |
522 | 52 | 2008-02-05 05:57:49 | 52 | 2008-02-05
05:57:49 |
| 714 | fsck.com-rt://tlcdatasecurity.com.au/ticket/425 |
at://tlcdatasecurity.com.au/asset/137 | RefersTo | 137 |
425 | 1912 | 2008-02-26 22:33:33 | 1912 | 2008-02-26
22:33:33 |
Thanks heaps for this.
BenRFrom: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Wednesday, 27 February 2008 4:43 AM
To: Ben Robson
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] That ticket has unresolved dependencies - [Pork]
Email found in subject
Ben,
I would look at the DataBase. Try this SQL:
select * from LIMKS
where LOCALTARGET = 99999
or LOCALBASE = 99999;
99999 is the ticket id in question. Anyway, once you have that
little
query up, look to see if there is some records that shows the
dependency. The TYPE field will indicate what’s up. Hope this helps.
Kenn
LBNL
We have a couple of tickets that are not allowing us to resolve them,
reporting “That ticket has unresolved dependencies”. Looking at the
ticket Links there are no dependencies listed.Does anyone have any suggestions about how to either resolve the
offending tickets, or locate any linked tickets that it may think are
dependencies but for some reason are not being shown?Thanks for the assist.
BenR
*The information contained in this communication is intended solely
for the use of the individual or entity to whom it is addressed and
others authorised to receive it. It may contain confidential or
legally
privileged information. If you are not the intended recipient you are
hereby notified that any disclosure, copying, distribution or taking
any
action in reliance on the contents of this information is strictly
prohibited and may be unlawful. If you have received this
communication
in error, please notify us immediately by responding to this email and
then delete it, and any associated attachments, from your system.
Thank
you.*
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.comDiscover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com