Re: OTRS error in Log file

Dear Moritz,
                     Thanks for your reply,

Following query state is empty.. due to some dashboard configuration. 
but do you know this configuration is stored in which file? so that i 
can remove or i am able to fix this issue?

SELECT DISTINCT count(*) FROM ticket st, queue sq  WHERE sq.id =
st.queue_id AND st.ticket_state_id IN (  )  AND st.responsible_user_id
IN (16) AND sq.group_id IN (802, 807, 820, 822, 829, 876, 913)  AND
st.until_time <= 1427722133 LIMIT 10000


On 3/30/2015 4:39 PM, Moritz Lenz wrote:
> Hi,
>
> On 30.03.2015 13:29, Ali Umair wrote:
>> Team,
>>          I am continuously facing following exception in OTRS, and i am
>> unable to track....
>>
>> Anybody can suggest the root cause of this exception ?
>>
>> if no user access the OTRS application but still this exception is
>> printing in error log continuously...
>>
>>
>> [Sun Mar 29 17:29:53 2015] [error]  [Sun Mar 29 17:29:53 2015] index.pl:
>> DBD::mysql::st execute failed: You have an error in your SQL syntax;
>> check the manual that corresponds to your MySQL server version for the
>> right syntax to use near ')  AND st.queue_id IN (999999) AND sq.group_id
>> IN (802, 807, 820, 822, 829, 876,' at line 1 at
>> /opt/iplOTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 553.
>> [Sun Mar 29 17:29:53 2015] [error]  ERROR: OTRS-CGI-10 Perl: 5.10.1 OS:
>> linux Time: Sun Mar 29 17:29:53 2015
>> [Sun Mar 29 17:29:53 2015] [error]
>> [Sun Mar 29 17:29:53 2015] [error]  Message: You have an error in your
>> SQL syntax; check the manual that corresponds to your MySQL server
>> version for the right syntax to use near ')  AND st.queue_id IN (999999)
>> AND sq.group_id IN (802, 807, 820, 822, 829, 876,' at line 1, SQL:
>> 'SELECT DISTINCT count(*) FROM ticket st, queue sq  WHERE sq.id =
>> st.queue_id AND st.ticket_state_id IN (  )  AND st.queue_id IN (999999)
> That's the problem here: the list of ticket states is empty, and the SQL
> syntax doesn't allow an empty list here.
>
> So, why is it empty?
>
> The dashboard does a search for tickets (or probably more than one
> search, but at least one is problematic), and selects by certain ticket
> states, but no ticket states match the search criteria.
>
> I don't know the dashboard well, but I guess there'll be a search by
> viewable states, so maybe somebody configured your OTRS to not contain
> any valid, viewable states?
>
> Cheers,
> Moritz
>
>> AND sq.group_id IN (802, 807, 820, 822, 829, 876, 913)  AND
>> st.until_time <= 1427722133 LIMIT 10000'
>> [Sun Mar 29 17:29:53 2015] [error]
>> [Sun Mar 29 17:29:53 2015] [error]   Traceback (12647):
>> [Sun Mar 29 17:29:53 2015] [error]     Module:
>> Kernel::System::Ticket::TicketSearch (v1.488.2.1) Line: 5136
>> [Sun Mar 29 17:29:53 2015] [error]     Module:
>> Kernel::Output::HTML::DashboardTicketGeneric::Run (v1.38) Line: 224
>> [Sun Mar 29 17:29:53 2015] [error]     Module:
>> Kernel::Modules::AgentDashboard::_Element (v1.24) Line: 458
>> [Sun Mar 29 17:29:53 2015] [error]     Module:
>> Kernel::Modules::AgentDashboard::Run (v1.24) Line: 307
>> [Sun Mar 29 17:29:53 2015] [error]     Module:
>> Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853
>> [Sun Mar 29 17:29:53 2015] [error]     Module:
>> /opt/iplOTRS/bin/cgi-bin/index.pl (v1.89) Line: 45
>> [Sun Mar 29 17:29:53 2015] [error]
>> [Sun Mar 29 17:29:53 2015] [error]  [Sun Mar 29 17:29:53 2015] index.pl:
>> DBD::mysql::st execute failed: You have an error in your SQL syntax;
>> check the manual that corresponds to your MySQL server version for the
>> right syntax to use near ')  AND st.responsible_user_id IN (16) AND
>> sq.group_id IN (802, 807, 820, 822, 82' at line 1 at
>> /opt/iplOTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 553.
>> [Sun Mar 29 17:29:53 2015] [error]  ERROR: OTRS-CGI-10 Perl: 5.10.1 OS:
>> linux Time: Sun Mar 29 17:29:53 2015
>> [Sun Mar 29 17:29:53 2015] [error]
>> [Sun Mar 29 17:29:53 2015] [error]   Message: You have an error in your
>> SQL syntax; check the manual that corresponds to your MySQL server
>> version for the right syntax to use near ')  AND st.responsible_user_id
>> IN (16) AND sq.group_id IN (802, 807, 820, 822, 82' at line 1, SQL:
>> 'SELECT DISTINCT count(*) FROM ticket st, queue sq  WHERE sq.id =
>> st.queue_id AND st.ticket_state_id IN (  )  AND st.responsible_user_id
>> IN (16) AND sq.group_id IN (802, 807, 820, 822, 829, 876, 913)  AND
>> st.until_time <= 1427722133 LIMIT 10000'
>> [Sun Mar 29 17:29:53 2015] [error]
>> [Sun Mar 29 17:29:53 2015] [error]   Traceback (12647):
>> [Sun Mar 29 17:29:53 2015] [error]     Module:
>> Kernel::System::Ticket::TicketSearch (v1.488.2.1) Line: 5136
>> [Sun Mar 29 17:29:53 2015] [error]     Module:
>> Kernel::Output::HTML::DashboardTicketGeneric::Run (v1.38) Line: 224
>> [Sun Mar 29 17:29:53 2015] [error]     Module:
>> Kernel::Modules::AgentDashboard::_Element (v1.24) Line: 458
>> [Sun Mar 29 17:29:53 2015] [error]     Module:
>> Kernel::Modules::AgentDashboard::Run (v1.24) Line: 307
>> [Sun Mar 29 17:29:53 2015] [error]     Module:
>> Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853
>> [Sun Mar 29 17:29:53 2015] [error]     Module:
>> /opt/iplOTRS/bin/cgi-bin/index.pl (v1.89) Line: 45
>> [Sun Mar 29 17:29:53 2015] [error]
>>
>>
>> -- 
>>
>> -- 
>>
>> *Best Regards*
>>
>> *Ali Umair*
>>
>>
>>
>>
>> _______________________________________________
>> OTRS mailing list: dev - Webpage: http://otrs.org/
>> Archive: http://lists.otrs.org/pipermail/dev
>> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
>>
>>
>>
>> _______________________________________________
>> OTRS mailing list: dev - Webpage: http://otrs.org/
>> Archive: http://lists.otrs.org/pipermail/dev
>> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev


-- 

-- 

*Best Regards*

*Ali Umair*

_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev