SOLVED:: systemlog errors : Need TicketID!

[jforrow]

I'm seeing errors in my system log following an upgrade to OTRS 4.0.14:

Code: Select all

Wed Dec 2 16:56:57 2015 	notice 	OTRS-CGI-10 	Permission denied (UserID: 5 'ro' on TicketID: 8390047166440283000)!
Wed Dec 2 16:56:57 2015 	error 	OTRS-CGI-10 	Need QueueID!
Wed Dec 2 16:56:57 2015 	error 	OTRS-CGI-10 	No such TicketID (8390047166440283000)!
Wed Dec 2 16:56:57 2015 	error 	OTRS-CGI-10 	No such TicketID (8390047166440283000)!

I can see a ticket in the table with ticket_id = 8390047166440283000

userid 5 is me and this error appears in the log just after I open a ticket and the first article changes from unread to read. I also see an onscreen error dialog:

Code: Select all

Error during AJAX communication. Status: parsererror, Error: SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data

I've tried rebuilding config, deleting cache & rebuilding indexes, but the error persists.

rebuildingindexes gave this error:

Code: Select all

[root@otrs log]# /opt/otrs/bin/otrs.RebuildTicketIndex.pl
ERROR: OTRS-otrs.RebuildTicketIndex.pl-10 Perl: 5.10.1 OS: linux Time: Wed Dec  2 17:04:36 2015

 Message: Need TicketID!

 Traceback (6322):
   Module: Kernel::System::Ticket::IndexAccelerator::StaticDB::TicketLockAcceleratorAdd Line: 288
   Module: Kernel::System::Ticket::IndexAccelerator::StaticDB::TicketAcceleratorRebuild Line: 574
   Module: /opt/otrs/bin/otrs.RebuildTicketIndex.pl Line: 41

[jforrow]

If anyone is interested I've found the problem.

The ID value in ticket table suddenly increased from 6 digits to 19 digits. As this field is a bigint datatype, it exceeded the PHP limit and started causing errors. Correcting the ID value to a 6 digit number and resetting the auto increment value stopped the error messages.