Hi, Maybe you have some problems with either:
- rights on the TicketCounter.log file, does your webuser (apache?) have write rights? - Does the sequence and triggers in the Oracle Database are OK? for instance PK_TICKET Regards, 2009/9/30 Michael Mayaka <[email protected]> > 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 <[email protected]> > *To:* User questions and discussions about OTRS. <[email protected]> > *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:* [email protected] [mailto:[email protected]] *On Behalf Of > *Michael Mayaka > *Sent:* miércoles, 30 de septiembre de 2009 7:47 > *To:* [email protected] > *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 > > > > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > http://www.otrs.com/en/support/enterprise-subscription/ >
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
