We are trying to implement OTRS using an Oracle 10g database.  We&#39;re using IIS and Perl Activestate in our environment.  I&#39;m encountering several errors with the install.  I&#39;ve created several agents and cannot authenticate. I receive an error message stating that the account doesn&#39;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.  <br>
<br>Also, each time I login as root (to the dashboard screen) I see the following errors generated in the OTRS error log:<br><br>[Error][Kernel::System::Ticket::TicketSearch][4761] ORA-01861: literal does not match format string (DBD ERROR: error possibly near &lt;*&gt; indicator at char 206 in &#39;SELECT DISTINCT count(*) FROM ticket st, queue sq , ticket_history th  WHERE <a href="http://sq.id">sq.id</a> = st.queue_id AND <a href="http://st.id">st.id</a> = th.ticket_id AND th.history_type_id IN  (1, 27) AND  th.state_id IN (2, 3) AND th.create_time &lt;= &lt;*&gt;&#39;2010-05-27 23:59:59&#39; AND th.history_type_id IN  (1, 27) AND  th.state_id IN (2, 3) AND  th.create_time &gt;= &#39;2010-05-27 00:00:00&#39;&#39;), SQL: &#39;SELECT DISTINCT count(*) FROM ticket st, queue sq , ticket_history th  WHERE <a href="http://sq.id">sq.id</a> = st.queue_id AND <a href="http://st.id">st.id</a> = th.ticket_id AND th.history_type_id IN  (1, 27) AND  th.state_id IN (2, 3) AND th.create_time &lt;= &#39;2010-05-27 23:59:59&#39; AND th.history_type_id IN  (1, 27) AND  th.state_id IN (2, 3) AND  th.create_time &gt;= &#39;2010-05-27 00:00:00&#39;&#39;<br>
<br>[Thu May 27 13:01:12 2010][Error][Kernel::Output::HTML::LayoutAJAX::JSONQuote][212] Need Data!<br><br>Thanks,<br>Jeff<br><br><br>