Error Message: No TicketID is given!

[Hannelie]

Oops! An Error occurred.
Error Message: No TicketID is given!
Please contact the admin..
You can Send a bugreport or go back to the previous page.

Error Details

ackend ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: linux Time: Thu Sep 25 11:37:18 2014 Message: No TicketID is given! Traceback (24768): Module: Kernel::Output::HTML::Layout::Error (v1.375) Line: 1142 Module: Kernel::Output::HTML::Layout::ErrorScreen (v1.375) Line: 1125 Module: Kernel::Modules::AgentTicketZoom::Run (v1.165) Line: 99 Module: Kernel::System::Web::InterfaceAgent::Run (v1.62) Line: 865 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46 Module: (eval) (v1.90) Line: 204 Module: ModPerl::RegistryCooker::run (v1.90) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.90) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31

This error message form part of my ticket list and I am not able to delete it it shows that it is locked and I cannot unlock it (no Option) and I cannot delete it either.

[crythias]

Welcome to the OTRS forums! Please take a moment to read my Need help? link in my signature and update your signature.

On topic: Did your system run out of disk space? Are tables marked as crashed? Do you have backups?

[Hannelie]

Afternoon

Answers on your questions:

Yes I did run out of disk space.
I am not sure about the tables that crashed.
Yes I have backups.



Will it help if I purge events from the database older than 1 year and if yes
how will I go about doing that?

Regards

Hannelie

[crythias]

You should check tables in your database and repair them.

[Hannelie]

So if I repair the tables will this empty ticket that is currently in the queue disappear?

Because I cannot close or delete this empty ticket!

[crythias]

Note that your tables are likely crashed so repair may truncate them to a point of repair. This doesn't mean your tables will be empty, just possibly reduced in size.

The only one who can answer your question is you within your environment.

[Hannelie]

Thank you for your input.

My only problem is, i am not a DBA so i do not have the knowledge to repair the tables so that I do not carry this empty ticket till Kingdom come in my ticket queue as a open ticket. It is going to influence my stats at the end of the month!

[crythias]

If one ticket is going to throw your stats off that much, you may have worse issues than can be addressed herein.

That said, a major search engine has information how to check and repair your tables even if you aren't a dba. This isn't a forum for that. Check error logs for other reasons that you might be having this issue, search for ways to repair your database or hire someone to assist you or revert your backup (at your own risk and risk tolerance).

[Hannelie]

Thanks for your assistance

I will do just that!