I'm not receiving new ticket notifications. I see the following error in the var/otrs.log file:
[Thu Jul 7 10:38:07 2011][Error][Kernel::System::Notification::NotificationGet][177] Can't find notification for Agent::NewTicket and en!
[Thu Jul 7 10:38:07 2011][Error][Kernel::System::HTMLUtils::DocumentComplete][601] Need Charset!
[Thu Jul 7 10:38:07 2011][Error][Kernel::System::Email::Send][174] Need Body!
[Thu Jul 7 10:38:07 2011][Notice][Kernel::System::Ticket::Article::SendAgentNotification] Sent agent 'NewTicket' notification to 'n.campbell@dalsym.com'.
[Thu Jul 7 10:38:07 2011][Error][Kernel::System::NotificationEvent::NotificationGet][171] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'comments'. (SQL-42S22) [state was 42S22 now 42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000), SQL: 'SELECT id, name, subject, text, content_type, charset, valid_id, comments, create_time, create_by, change_time, change_by FROM notification_event WHERE id = ?'
[Thu Jul 7 10:38:07 2011][Error][Kernel::System::NotificationEvent::NotificationGet][171] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'comments'. (SQL-42S22) [state was 42S22 now 42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000), SQL: 'SELECT id, name, subject, text, content_type, charset, valid_id, comments, create_time, create_by, change_time, change_by FROM notification_event WHERE id = ?'
I have a New Ticket notification event created and it has body text, so not sure what to do about that or the charset error. Also the invalid column name is throwing me off a bit - I'll check the database and verify that the column is in that table and named properly.
Any assistance appreciated.
Thanks,
Windows 2008
SQL 2008
IIS 7
OTRS 3.0.7
New Ticket Notification Failing
Moderator: crythias
New Ticket Notification Failing
OTRS 3.0.9
Windows 2008
MSSQL 2008
IIS 7
Windows 2008
MSSQL 2008
IIS 7
Re: New Ticket Notification Failing
Okay - I seemed to have resolved the errors listed above.
For some reason, the comments column was not created in the notification_events table and even though in the Admin interface I could see an AgentNotification::NewTicket option and edit it, when I looked at the database there was no record in the notifications table. Manually adding it in the database fixed that error.
For some reason, the comments column was not created in the notification_events table and even though in the Admin interface I could see an AgentNotification::NewTicket option and edit it, when I looked at the database there was no record in the notifications table. Manually adding it in the database fixed that error.
OTRS 3.0.9
Windows 2008
MSSQL 2008
IIS 7
Windows 2008
MSSQL 2008
IIS 7