Thanks for your reply. I only have one queue and all agents have rw rights on it. If I maually modify the TicketCounter.log, the system picks a few tickets then again conks out. What's a more permanent solution? My setup is live and serves 250 internal users. The 2nd instance (which does not have the error) is still stable and serves all public queries. Michael. ________________________________ From: IT easyap To: User questions and discussions about OTRS. Sent: Wednesday, 30 September, 2009 12:22:11 Subject: Re: [otrs] OTRS Ticket Creation Error [Message: Need TicketID!] This error could bee because you are trying to create a ticket in a queue with out rights. For example: You have a queue 1 and insight it the queue 1-1, in the queue 1 you have read rights (or no rights) and in the queue 1-1 you have rw rights. If you try to create the ticket in the queue 1-1 everything works fine but if you try to create the ticket in the queue 1 you receive this error in the log and the ticket is missing. If you have this issue give enough rights to the parent queue. regards ________________________________ From:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Michael Mayaka Sent: miércoles, 30 de septiembre de 2009 7:47 To: otrs@otrs.org Subject: [otrs] OTRS Ticket Creation Error [Message: Need TicketID!] Hi, I've been using otrs since last year. I already upgraded to 2.4.4. Now I'm getting this error during ticket creation: ================================================================================================ [Error][Kernel::System::Ticket::TicketCreate][Line:447]: ORA-00001: unique constraint (IT_ADMIN.PK_TICKET) violated (DBD ERROR: OCIStmtExecute), 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, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 0, 0, 0, 0, 0, ?, ?, 0, ?, current_timestamp, ?, current_timestamp, ?)' Sep 30 08:46:42 imis-appsvr1 OTRS-CGI-11[1014]: [Error][Kernel::System::Ticket::TicketFreeTimeSet][Line:2900]: Need TicketID! Sep 30 08:46:42 imis-appsvr1 OTRS-CGI-11[1014]: [Error][Kernel::System::Ticket::Article::ArticleCreate][Line:109]: Need TicketID! ================================================================================================= My environment is as follows: ======================== -Operating System: CentOS 5 -DBMS: Oracle 10g -Perl: 5.8.8 I have two instances of otrs running under the same environment; the other one does not have any errors...PLEASE HELP! Michael

Hi, Thanks for the help, I have reset the otrs instance permissions (using SetPermissions.pl); restarted the Oracle Server and apache. So far I am creating new tickets successfully. However, at the backend, I'm getting the following error: ========================================= [Error][Kernel::System::Ticket::TicketNumberLookup][Line:637]: ERROR Database disconnected, SQL: 'SELECT tn FROM ticket WHERE id = ?' ============================================ What could this be? Michael

Hi Timo, Yes I think it could be a bug. Am wondering what could be triggering it; I have another instance of otrs 2.4.4 running on the same App Server and serving even more users but its not throwing that error. Michael ________________________________ From: Rupp Timo To: User questions and discussions about OTRS. Sent: Monday, 5 October, 2009 10:04:06 Subject: Re: [otrs] OTRS Ticket Creation Error [Message: Need TicketID!] Hi Michael, it looks a bit like the bug I’ve posted last week: http://bugs.otrs.org/show_bug.cgi?id=4367 Please check if generic agents are producing the error messages in your case, too. - Timo Von:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Michael Mayaka Gesendet: Freitag, 2. Oktober 2009 09:50 An: User questions and discussions about OTRS. Betreff: Re: [otrs] OTRS Ticket Creation Error [Message: Need TicketID!] Hi, Thanks for the help, I have reset the otrs instance permissions (using SetPermissions.pl); restarted the Oracle Server and apache. So far I am creating new tickets successfully. However, at the backend, I'm getting the following error: ========================================= [Error][Kernel::System::Ticket::TicketNumberLookup][Line:637]: ERROR Database disconnected, SQL: 'SELECT tn FROM ticket WHERE id = ?' ============================================ What could this be? Michael

I've tested my Generic agents and I notice its what triggers the error. Thanks for the insight. Guess it's the same bug then! Michael ________________________________ From: Rupp Timo To: User questions and discussions about OTRS. Sent: Monday, 5 October, 2009 10:57:40 Subject: Re: [otrs] OTRS Ticket Creation Error [Message: Need TicketID!] Hi, on my system it only comes up when running generic agents. If I disable the generic agents cronjob and do not use the generic agents admin GUI the error message does not appear. - Timo Von:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Michael Mayaka Gesendet: Montag, 5. Oktober 2009 09:26 An: User questions and discussions about OTRS. Betreff: Re: [otrs] OTRS Ticket Creation Error [Message: Need TicketID!] Hi Timo, Yes I think it could be a bug. Am wondering what could be triggering it; I have another instance of otrs 2.4.4 running on the same App Server and serving even more users but its not throwing that error. Michael ________________________________ From:Rupp Timo To: User questions and discussions about OTRS. Sent: Monday, 5 October, 2009 10:04:06 Subject: Re: [otrs] OTRS Ticket Creation Error [Message: Need TicketID!] Hi Michael, it looks a bit like the bug I’ve posted last week: http://bugs.otrs.org/show_bug.cgi?id=4367 Please check if generic agents are producing the error messages in your case, too. - Timo Von:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von Michael Mayaka Gesendet: Freitag, 2. Oktober 2009 09:50 An: User questions and discussions about OTRS. Betreff: Re: [otrs] OTRS Ticket Creation Error [Message: Need TicketID!] Hi, Thanks for the help, I have reset the otrs instance permissions (using SetPermissions.pl); restarted the Oracle Server and apache. So far I am creating new tickets successfully. However, at the backend, I'm getting the following error: ========================================= [Error][Kernel::System::Ticket::TicketNumberLookup][Line:637]: ERROR Database disconnected, SQL: 'SELECT tn FROM ticket WHERE id = ?' ============================================ What could this be? Michael