NLS format issues [windows / oracle / 3.1.0-beta1]

[a_ieri]

Hi, I'm trying 3.1 beta because I need to be able to download mail from a specific IMAP folder.
I did a fresh install removing 3.0 completely and now I run into an issue when trying to insert date values into the db (Oracle 11gR2).
OTRS 3.0 worked fine without setting NLS environment variables, but I've read other posts (and this FAQ) so I added to my Config.pm:

Code: Select all

$ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';

Now if I execute, for example,

Code: Select all

C:\Programmi\OTRS\StrawberryPerl>perl C:\Programmi\OTRS\OTRS\bin\otrs.AddGroup.pl -n test

everything works, but if I try to do the same via the web gui I get:

Code: Select all

ORA-01861: il valore non corrisponde alla stringa di formato (DBD ERROR: error possibly near <*> indicator at char 127 in 'INSERT INTO groups (name, comments, valid_id, create_time, create_by, change_time, change_by) VALUES (:p1, :p2, :p3, <*>'2011-12-01 14:21:03' , :p4, '2011-12-01 14:21:03' , :p5)'), SQL: 'INSERT INTO groups (name, comments, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, '2011-12-01 14:21:03' , ?, '2011-12-01 14:21:03' , ?)' 

I did restart apache (I even restarted windows...) but to no avail.
Any ideas?

Thanks!

[racagalro]

Same problem but in version 3.3.0, CentOS 6 and Oracle agent 11g.

Command line works fine and GUI attempt didn't work.

It seems GUI is not using NLS variables from Config.pm

¿Some clues?

Thanks