ORA-01830

[1ntnernationa7]

Hi Everyone,

I've been using OTRS for a couple of months now with an oracle database, but once I had to reinstall it due to a fatal error. The installation of the program and oracle driver was successful bun then I got the ORA-01830 error even though I updated the apache2-perl-startup.pl and config.pl with the following:

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

I'm really stuck right now on what to do. I've tried many different formats and languages and none of them seem to work.
I'm using otrs-3.3.1.

Full log error below:

[Fri Nov 15 15:02:51 2013][Error][Kernel::System::User::UserAdd][412] ORA-01830: date format picture ends before converting entire input string (DBD ERROR: error possibly near <*> indicator at char 168 in 'INSERT INTO users (title, first_name, last_name, login, pw, valid_id, create_time, create_by, change_time, change_by) VALUES (:p1, :p2, :p3, :p4, :p5, :p6,
<*>'2013-11-15 15:02:51'
, :p7,
'2013-11-15 15:02:51'
, :p8)'), SQL: 'INSERT INTO users (title, first_name, last_name, login, pw, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?,
'2013-11-15 15:02:51'
, ?,
'2013-11-15 15:02:51'
, ?)'


Thanks everyone. Any help is appreciated since our systems has been down for days.