[SOLVED] Ticket Deleted After a Merge?

Moderator: crythias

Locked
interploy
Znuny newbie
Posts: 30
Joined: 24 Sep 2012, 21:10
Znuny Version: 3.2.3

[SOLVED] Ticket Deleted After a Merge?

Post by interploy »

Hello,

A user reported that a ticket was no longer displaying in OTRS. Here is what I found:

1. The provided ticket number was not in the ticket table.
2. The user said other tickets had been merged into it. I reviewed the ticket_history table and found entries for four other tickets had been merged into the missing ticket.
3. However, the missing ticket itself was not in the history_table. The only references are from the other tickets indicating the merge. If users got to those tickets now, there is only the mention that it was merged into the missing ticket.
4. The user mentioned that at least two other people had touched the ticket. Naturally no one knows what happened.

My guess is that the ticket was accidentally moved into the trash queue and deleted. But, if that is the case, shouldn't the history table reflect that? Or, if a ticket is deleted, is it completely erased from the database, history and all?

Is it possible there was a glitch during one of the merges and it destroyed the ticket?

Any insight would be appreciated. I'll be happy to provide what details that I can.

Thanks,
-interploy
Last edited by interploy on 28 Oct 2014, 22:46, edited 1 time in total.
OTRS v3.2.3
CentOS 6.3
PostgreSQL 8.4.13
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Ticket Deleted After a Merge?

Post by jojo »

if a ticket is deleted everthing (history, attachments etc) will be deleted
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
interploy
Znuny newbie
Posts: 30
Joined: 24 Sep 2012, 21:10
Znuny Version: 3.2.3

Re: Ticket Deleted After a Merge?

Post by interploy »

Okay, I will let the users know. Thank you for clarifying!
OTRS v3.2.3
CentOS 6.3
PostgreSQL 8.4.13
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: [SOLVED] Ticket Deleted After a Merge?

Post by crythias »

It is not likely that a ticket will be deleted without Generic Agent being used.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
interploy
Znuny newbie
Posts: 30
Joined: 24 Sep 2012, 21:10
Znuny Version: 3.2.3

Re: [SOLVED] Ticket Deleted After a Merge?

Post by interploy »

crythias wrote:It is not likely that a ticket will be deleted without Generic Agent being used.
Sorry, I should have mentioned it before. We are using Generic Agensts on the junk queues to clear them out regularly.
OTRS v3.2.3
CentOS 6.3
PostgreSQL 8.4.13
Locked