Multiples error's in ORACLE 10g.

Moderator: crythias

Post Reply
jgbautista
Znuny newbie
Posts: 7
Joined: 29 Sep 2010, 16:11
Znuny Version: 2.2.4

Multiples error's in ORACLE 10g.

Post by jgbautista »

I have this errors in my OTRS 2.2.4 and ORACLE DATABASE:

ORA-01843: not a valid month (DBD ERROR: error possibly near <*> indicator at char 334 in 'SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN (1) AND st.queue_id IN (366) AND sq.group_id IN (1, 2, 3, 4, 5, 6, 7, 8, 24, 25, 44, 45, 46, 47, 104, 124, 144, 164, 184, 204, 224, 264, 284, 304, 324) AND st.ticket_priority_id IN (3) AND st.create_time <= <*>'09-10-2010 23:59:59' AND st.create_time >= '09-09-2010 00:00:01' ORDER BY st.create_time_unix DESC'), SQL: 'SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN (1) AND st.queue_id IN (366) AND sq.group_id IN (1, 2, 3, 4, 5, 6, 7, 8, 24, 25, 44, 45, 46, 47, 104, 124, 144, 164, 184, 204, 224, 264, 284, 304, 324) AND st.ticket_priority_id IN (3) AND st.create_time <= '09-10-2010 23:59:59' AND st.create_time >= '09-09-2010 00:00:01' ORDER BY st.create_time_unix DESC'

My Config.pm contains the next lines:

$ENV{ORACLE_HOME} = '/u01/app/oracle/product/10.2/client_1';
$ENV{PATH} = '$PATH:/u01/app/oracle/product/10.2/client_1/bin';
$ENV{LD_LIBRARY_PATH} = '/u01/app/oracle/product/10.2/client_1/lib/';
$ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
$ENV{NLS_LANG} = "SPANISH_SPAIN.UTF8";


My sistem language is Spanish. I have many problems with searchs in database, I think the date format is incorrect.
Can you help? Thanks for all.
Post Reply