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
[SOLVED] Ticket Deleted After a Merge?
Moderator: crythias
[SOLVED] Ticket Deleted After a Merge?
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
CentOS 6.3
PostgreSQL 8.4.13
Re: Ticket Deleted After a Merge?
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: Ticket Deleted After a Merge?
Okay, I will let the users know. Thank you for clarifying!
OTRS v3.2.3
CentOS 6.3
PostgreSQL 8.4.13
CentOS 6.3
PostgreSQL 8.4.13
-
- 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?
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
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
Re: [SOLVED] Ticket Deleted After a Merge?
Sorry, I should have mentioned it before. We are using Generic Agensts on the junk queues to clear them out regularly.crythias wrote:It is not likely that a ticket will be deleted without Generic Agent being used.
OTRS v3.2.3
CentOS 6.3
PostgreSQL 8.4.13
CentOS 6.3
PostgreSQL 8.4.13