Re: [rt-users] "Hidden" tickets suddenly appear

2016-11-08 Thread Jeff Blaine
> You need to find out what is preventing the ticket from showing up in
> your query. One of your AND conditions may not be met so the ticket
> does not show up. Are you saving your Email that is creating the missed
> tickets? You could try submitting a similar Email to see if it has the
> same visibility problem. Also, do you have any customizations? Sometimes
> a change can have unusual ramifications down the line.

Another "hidden" ticket appeared last week (11/4) in the search results.
It is ~7 months old.

* Ticket has zero transactions
* Ticket is in 'new' status as expected. Never had a different
  state.
* Ticket is owned by 'Nobody in particular' (aka account name
  'Nobody') as expected for a ticket with no transactions. Never
  had a different owner.
* Ticket is in 'atcc-help' queue. Never had a different queue.
* All criteria above match the search query below fully:

Queue = 'atcc-help'
AND
   (
  Status = 'new'
  OR Status = 'open'
  OR Status = 'stalled'
   )
AND (
   Owner = 'Nobody'
   OR Owner = 'jbla...@our.org'
)

Yet it sat hidden for ~7 months, not showing in the search results,
and then popped into view Friday 11/4.

We do not have any homebrew customizations at all for *this* RT
instance.

We use RT::Extension::Nagios and RT::Extension:Assets.

I can't really picture how we could reproduce this failure scenario.

-- 
Jeff Blaine
kickflop.net
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017


Re: [rt-users] "Hidden" tickets suddenly appear

2016-10-27 Thread Kenneth Marshall
On Thu, Oct 27, 2016 at 03:21:51PM -0400, Jeff Blaine wrote:
> On 10/26/2016 4:27 AM, Martin Wheldon wrote:
> > Hi Jeff,
> > 
> > If you examine the ticket history of the problem ticket it should tell
> > you what happened
> > for it to be set back to the "new" status.
> > 
> > Is it being reopened by a reply to a email from the pervious ticket
> > corespondance perhaps??
> 
> Martin,
> 
> Right, that's where I first looked. There are zero transactions past the
> initial creation via email. Nothing has been done to the ticket.
> 
> Jeff

Hi Jeff,

You need to find out what is preventing the ticket from showing up in
your query. One of your AND conditions may not be met so the ticket
does not show up. Are you saving your Email that is creating the missed
tickets? You could try submitting a similar Email to see if it has the
same visibility problem. Also, do you have any customizations? Sometimes
a change can have unusual ramifications down the line.

Good luck,
Ken
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - Q1 2017


Re: [rt-users] "Hidden" tickets suddenly appear

2016-10-27 Thread Jeff Blaine
On 10/26/2016 4:27 AM, Martin Wheldon wrote:
> Hi Jeff,
> 
> If you examine the ticket history of the problem ticket it should tell
> you what happened
> for it to be set back to the "new" status.
> 
> Is it being reopened by a reply to a email from the pervious ticket
> corespondance perhaps??

Martin,

Right, that's where I first looked. There are zero transactions past the
initial creation via email. Nothing has been done to the ticket.

Jeff

> On 2016-10-25 16:00, Jeff Blaine wrote:
>> RT 4.2.13 backed by PostgreSQL, though I feel like we've been
>> experiencing the following for many versions.
>>
>> I've been suspect for quite some time, but thought maybe I was losing my
>> mind instead. I've confirmed finally that I am not losing my mind re: RT
>> in this specific case. We are definitely seeing the following situation.
>>
>> I'm curious if anyone has thoughts as to where to start debugging the
>> root cause.
>>
>> I use a simple saved search as my view into RT at work. Others using
>> this queue also use a similar one. The query is:
>>
>> Queue = 'atcc-help'
>> AND
>>(
>>   Status = 'new'
>>   OR Status = 'open'
>>   OR Status = 'stalled'
>>)
>> AND (
>>Owner = 'Nobody'
>>OR Owner = 'jbla...@our.org'
>> )
>>
>> The display settings for the search have "Rows: Unlimited"
>>
>> It results in a daily list of 70-120 tickets.
>>
>> We are seeing tickets appear in this list, where they have never
>> appeared in the list before, after some period of being in the queue. In
>> most cases, the mystery ticket has a "Created" date of more than a few
>> weeks ago. The most recent case was 5 months. That is, a ticket with
>> "Created" of around 5 months ago, and in "new" status, showed up in the
>> results of the search above where it never had shown up before.
>>
>> As you can imagine, this is terrible for customer service. Luckily it
>> seems pretty rare. I would estimate that we see this happen ~5 times per
>> year, and then have to start the very awkward conversation about how the
>> ticket "slipped through our cracks".
>>
>> Thoughts very welcome.
>>
>> Jeff
>> -
>> RT 4.4 and RTIR training sessions, and a new workshop day!
>> https://bestpractical.com/training
>> * Boston - October 24-26
>> * Los Angeles - Q1 2017
> -
> RT 4.4 and RTIR training sessions, and a new workshop day!
> https://bestpractical.com/training
> * Boston - October 24-26
> * Los Angeles - Q1 2017
> 

-- 
Jeff Blaine
kickflop.net
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - Q1 2017


Re: [rt-users] "Hidden" tickets suddenly appear

2016-10-26 Thread Martin Wheldon

Hi Jeff,

If you examine the ticket history of the problem ticket it should tell 
you what happened

for it to be set back to the "new" status.

Is it being reopened by a reply to a email from the pervious ticket 
corespondance perhaps??


Best Regards

Martin

On 2016-10-25 16:00, Jeff Blaine wrote:

RT 4.2.13 backed by PostgreSQL, though I feel like we've been
experiencing the following for many versions.

I've been suspect for quite some time, but thought maybe I was losing 
my
mind instead. I've confirmed finally that I am not losing my mind re: 
RT
in this specific case. We are definitely seeing the following 
situation.


I'm curious if anyone has thoughts as to where to start debugging the
root cause.

I use a simple saved search as my view into RT at work. Others using
this queue also use a similar one. The query is:

Queue = 'atcc-help'
AND
   (
  Status = 'new'
  OR Status = 'open'
  OR Status = 'stalled'
   )
AND (
   Owner = 'Nobody'
   OR Owner = 'jbla...@our.org'
)

The display settings for the search have "Rows: Unlimited"

It results in a daily list of 70-120 tickets.

We are seeing tickets appear in this list, where they have never
appeared in the list before, after some period of being in the queue. 
In

most cases, the mystery ticket has a "Created" date of more than a few
weeks ago. The most recent case was 5 months. That is, a ticket with
"Created" of around 5 months ago, and in "new" status, showed up in the
results of the search above where it never had shown up before.

As you can imagine, this is terrible for customer service. Luckily it
seems pretty rare. I would estimate that we see this happen ~5 times 
per
year, and then have to start the very awkward conversation about how 
the

ticket "slipped through our cracks".

Thoughts very welcome.

Jeff
-
RT 4.4 and RTIR training sessions, and a new workshop day!
https://bestpractical.com/training
* Boston - October 24-26
* Los Angeles - Q1 2017

-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Boston - October 24-26
* Los Angeles - Q1 2017


[rt-users] "Hidden" tickets suddenly appear

2016-10-25 Thread Jeff Blaine
RT 4.2.13 backed by PostgreSQL, though I feel like we've been
experiencing the following for many versions.

I've been suspect for quite some time, but thought maybe I was losing my
mind instead. I've confirmed finally that I am not losing my mind re: RT
in this specific case. We are definitely seeing the following situation.

I'm curious if anyone has thoughts as to where to start debugging the
root cause.

I use a simple saved search as my view into RT at work. Others using
this queue also use a similar one. The query is:

Queue = 'atcc-help'
AND
   (
  Status = 'new'
  OR Status = 'open'
  OR Status = 'stalled'
   )
AND (
   Owner = 'Nobody'
   OR Owner = 'jbla...@our.org'
)

The display settings for the search have "Rows: Unlimited"

It results in a daily list of 70-120 tickets.

We are seeing tickets appear in this list, where they have never
appeared in the list before, after some period of being in the queue. In
most cases, the mystery ticket has a "Created" date of more than a few
weeks ago. The most recent case was 5 months. That is, a ticket with
"Created" of around 5 months ago, and in "new" status, showed up in the
results of the search above where it never had shown up before.

As you can imagine, this is terrible for customer service. Luckily it
seems pretty rare. I would estimate that we see this happen ~5 times per
year, and then have to start the very awkward conversation about how the
ticket "slipped through our cracks".

Thoughts very welcome.

Jeff
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Boston - October 24-26
* Los Angeles - Q1 2017