Error Daemon Cron

Moderator: crythias

Locked
machadoa
Znuny advanced
Posts: 101
Joined: 11 Dec 2015, 17:36
Znuny Version: 5.0.5

Error Daemon Cron

Post by machadoa »

Hello

I get this message regularly :

Code: Select all

ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-32 Perl: 5.18.2 OS: linux Time: Thu Apr 14 23:03:07 2016

 Message: No such TicketID (40)!

 Traceback (6568):
   Module: Kernel::System::Ticket::TicketGet Line: 1178
   Module: Kernel::System::Ticket::HistoryAdd Line: 5626
   Module: Kernel::System::Ticket::TicketCreate Line: 523
   Module: Kernel::System::PostMaster::NewTicket::Run Line: 229
   Module: Kernel::System::PostMaster::Run Line: 372
   Module: Kernel::System::MailAccount::IMAP::_Fetch Line: 222
   Module: Kernel::System::MailAccount::IMAP::Fetch Line: 86
   Module: Kernel::System::MailAccount::MailAccountFetch Line: 440
   Module: Kernel::System::Console::Command::Maint::PostMaster::MailAccountFetch::Run Line: 94
   Module: (eval) Line: 444
   Module: Kernel::System::Console::BaseCommand::Execute Line: 438
   Module: (eval) Line: 147
   Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Cron::Run Line: 131
   Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Run Line: 259
   Module: (eval) Line: 316
   Module: main::Start Line: 316
   Module: /opt/otrs//bin/otrs.Daemon.pl Line: 138

[Thu Apr 14 23:03:07 2016] otrs.Daemon.pl: DBD::mysql::db do failed: Column 'queue_id' cannot be null at /opt/otrs/Kernel/System/DB.pm line 449.
ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-32 Perl: 5.18.2 OS: linux Time: Thu Apr 14 23:03:07 2016

 Message: Column 'queue_id' cannot be null, SQL: 'INSERT INTO ticket_history  (name, history_type_id, ticket_id, article_id, queue_id, owner_id,  priority_id, state_id, type_id,  create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,
        '2016-04-14 23:03:07'
    , ?,
        '2016-04-14 23:03:07'
    , ?)'
I can not solve the problem. Help please !
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: Error Daemon Cron

Post by reneeb »

Is the queue you have configured for the new tickets valid?
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
machadoa
Znuny advanced
Posts: 101
Joined: 11 Dec 2015, 17:36
Znuny Version: 5.0.5

Re: Error Daemon Cron

Post by machadoa »

I don't understand.
Where should I set this up?
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: Error Daemon Cron

Post by reneeb »

1) SysConfig option PostmasterDefaultQueue
2) Queues assigned to the mail accounts
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
machadoa
Znuny advanced
Posts: 101
Joined: 11 Dec 2015, 17:36
Znuny Version: 5.0.5

Re: Error Daemon Cron

Post by machadoa »

I've defined a new queue named "IAAS" but I do not see where the problem comes
Locked