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
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/