[rt-users] That ticket has unresolved dependencies - [Pork] Email found in subject

[Ben Robson]

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.

BenR



-----Original Message-----
From: Kenneth Crocker [mailto:KFCrocker at lbl.gov] 
Sent: Wednesday, 27 February 2008 4:43 AM
To: Ben Robson
Cc: rt-users at 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

On 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.*
> 
>  
> 
> <http://www.tlcit.biz> 
> 
> 
>
------------------------------------------------------------------------
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com