Error Message: Need TicketID!

Moderator: crythias

Locked
djfinggaz
Znuny newbie
Posts: 17
Joined: 02 Oct 2012, 11:10
Znuny Version: 3.1.9
Real Name: Pompiliu Aranyos
Company: Bosch Communication Center

Error Message: Need TicketID!

Post by djfinggaz »

Help needed urgently please!!!
===================
Whenever our agents are trying to create a new ticket it gives them the error:
Error Message: Need TicketID!

Backend ERROR: OTRS-CGI-10 Perl: 5.12.3 OS: MSWin32 Time: Thu Feb 28 08:17:20
2013 Message: Need TicketID! Traceback (1540): Module:
Kernel::System::Ticket::Article::ArticleCreate (v1.311.2.2) Line: 120 Module:
Kernel::Modules::AgentTicketPhone::Run (v1.236.2.7) Line: 1104 Module:
Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868 Module:
ModPerl::ROOT::ModPerl::Registry::C_3a_Program_20Files_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler
(unknown version) Line: 49 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
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Error Message: Need TicketID!

Post by crythias »

did you run out of ticket numbers?
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
djfinggaz
Znuny newbie
Posts: 17
Joined: 02 Oct 2012, 11:10
Znuny Version: 3.1.9
Real Name: Pompiliu Aranyos
Company: Bosch Communication Center

Re: Error Message: Need TicketID!

Post by djfinggaz »

How can I check that?
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Error Message: Need TicketID!

Post by crythias »

what ticket number scheme are you using?
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
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Error Message: Need TicketID!

Post by jojo »

What did you change before you got the error
"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
djfinggaz
Znuny newbie
Posts: 17
Joined: 02 Oct 2012, 11:10
Znuny Version: 3.1.9
Real Name: Pompiliu Aranyos
Company: Bosch Communication Center

Re: Error Message: Need TicketID!

Post by djfinggaz »

I'm using AutoIncrement on Ticket::NumberGenerator and the value of Ticket::NumberGenerator::MinCounterSize is set to 5
I didn't change anything in the system before getting this error but it's odd to just get this error out of the blue.
djfinggaz
Znuny newbie
Posts: 17
Joined: 02 Oct 2012, 11:10
Znuny Version: 3.1.9
Real Name: Pompiliu Aranyos
Company: Bosch Communication Center

Re: Error Message: Need TicketID!

Post by djfinggaz »

I don't know if this makes any difference but the Ticket::NumberGenerator was set to its default value (DateChecksum) when I started getting the error and I only changed it after reading a post on the forum.
djfinggaz
Znuny newbie
Posts: 17
Joined: 02 Oct 2012, 11:10
Znuny Version: 3.1.9
Real Name: Pompiliu Aranyos
Company: Bosch Communication Center

Re: Error Message: Need TicketID!

Post by djfinggaz »

This is what I'm getting in the log file when I'm trying to create a ticket:

[Fri Mar 1 10:40:45 2013][Error][Kernel::System::DynamicField::Backend::ValueSet][434] Need ObjectID!
[Fri Mar 1 10:40:45 2013][Error][Kernel::System::DynamicField::Backend::ValueSet][434] Need ObjectID!
[Fri Mar 1 10:40:45 2013][Error][Kernel::System::DynamicField::Backend::ValueSet][434] Need ObjectID!
[Fri Mar 1 10:40:45 2013][Error][Kernel::System::DynamicField::Backend::ValueSet][434] Need ObjectID!
[Fri Mar 1 10:40:45 2013][Error][Kernel::System::DynamicField::Backend::ValueSet][434] Need ObjectID!
[Fri Mar 1 10:40:45 2013][Error][Kernel::System::DynamicField::Backend::ValueSet][434] Need ObjectID!
[Fri Mar 1 10:40:45 2013][Error][Kernel::System::Ticket::Article::ArticleCreate][120] Need TicketID!
[Error][Kernel::System::Ticket::TicketCreate][497] Duplicate entry '36536' for key 'PRIMARY', SQL: 'INSERT INTO ticket (tn, title, create_time_unix, type_id, queue_id, ticket_lock_id, user_id, responsible_user_id, group_id, ticket_priority_id, ticket_state_id, ticket_answered, escalation_time, escalation_update_time, escalation_response_time, escalation_solution_time, timeout, service_id, sla_id, until_time, valid_id, archive_flag, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 0, 0, 0, 0, 0, ?, ?, 0, ?, ?
djfinggaz
Znuny newbie
Posts: 17
Joined: 02 Oct 2012, 11:10
Znuny Version: 3.1.9
Real Name: Pompiliu Aranyos
Company: Bosch Communication Center

Re: Error Message: Need TicketID! SOLVED

Post by djfinggaz »

Problem got resolved - the thing was that OTRS generated a ticketID which was created incomplete in the database - the id 36536 existed in the table but it's key was corrupted somehow. So I made c copy of the table with the initial data, emptied the old table and copied the data back in the new table.
Locked