Hi Jeff,

Please look into the configuration of your date format. If you add
these lines to your otrs/Kernel/Config.pm you'd probably be good:

    $ENV{ORACLE_HOME} = 'd:/ora10g';
    $ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
    $ENV{NLS_LANG} = "american_america.al32utf8";

((enjoy))

Michiel Beijen
R&D

Follow me on Twitter: @otrsnl [https://twitter.com/otrsnl]

OTRS AG
Norsk-Data-Str. 1
61352 Bad Homburg
GERMANY

T: +31 (0) 6457 42418
F: +49 (0) 9421 56818-18
I:  http://www.otrs.com

Business Location: Bad Homburg, Country Court: Bad Homburg, HRB 10751,
VAT ID: DE256610065
Chairman: Burchard Steinbild, Managing Board: André Mindermann

GET OTRS::ITSM 2.0 NOW - including the brand new change management
module! It´s the only ITIL® V3 compatible open-source IT Service
Management solution certified by PinkVERIFY worldwide! -
http://bit.ly/dv4CJF



On Thu, May 27, 2010 at 8:55 PM, Jeff Travers <[email protected]> wrote:
> We are trying to implement OTRS using an Oracle 10g database.  We're using
> IIS and Perl Activestate in our environment.  I'm encountering several
> errors with the install.  I've created several agents and cannot
> authenticate. I receive an error message stating that the account doesn't
> exist or is invalid.  I can only seem to authenticate as the root account.
> If I switch to a MySQL database then the issues appear to be resolved.
>
> Also, each time I login as root (to the dashboard screen) I see the
> following errors generated in the OTRS error log:
>
> [Error][Kernel::System::Ticket::TicketSearch][4761] ORA-01861: literal does
> not match format string (DBD ERROR: error possibly near <*> indicator at
> char 206 in 'SELECT DISTINCT count(*) FROM ticket st, queue sq ,
> ticket_history th  WHERE sq.id = st.queue_id AND st.id = th.ticket_id AND
> th.history_type_id IN  (1, 27) AND  th.state_id IN (2, 3) AND th.create_time
> <= <*>'2010-05-27 23:59:59' AND th.history_type_id IN  (1, 27) AND
> th.state_id IN (2, 3) AND  th.create_time >= '2010-05-27 00:00:00''), SQL:
> 'SELECT DISTINCT count(*) FROM ticket st, queue sq , ticket_history th
> WHERE sq.id = st.queue_id AND st.id = th.ticket_id AND th.history_type_id
> IN  (1, 27) AND  th.state_id IN (2, 3) AND th.create_time <= '2010-05-27
> 23:59:59' AND th.history_type_id IN  (1, 27) AND  th.state_id IN (2, 3) AND
> th.create_time >= '2010-05-27 00:00:00''
>
> [Thu May 27 13:01:12
> 2010][Error][Kernel::Output::HTML::LayoutAJAX::JSONQuote][212] Need Data!
>
> Thanks,
> Jeff
>
>
>
> ---------------------------------------------------------------------
> 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/

Reply via email to