[otrs] OTRS with Oracle

[Peter McLarty]

Hi Amir
You need to have a look  at your log file, this will likely
be /var/log/messages the syslog file of on Linux and see if you have
insert errors.
If that is the case add these two lines to Config.pm
$ENV{'NLS_DATE_FORMAT'} = 'yyyy-mm-dd hh24:mi:ss'; 
$ENV{NLS_LANG} = "american_america.WE8MSWIN1252";

Check your language parameters before doing the second line and it may
not be required in your case

Basically the installer is trying to add some data which is in a format
that requires the above date parameter to be set to make it function

HTH

Cheers

Peter


On Tue, 2008-07-08 at 08:19 +0000, amir younas wrote:

> Dear Sir,
>  
> I have configured the OTRS with Oracle and it's working fine. But when
> I am adding ITSM packages for Config Item then sample data for Config
> Item is not adding in database. But if i add these pakcages using
> MYSQL database sample data is added in MYsql db.
>  
> Sir, Please advise me why is this behavior is with oracle. I am using
> 2.2.7 version with ITSM 1.1.2.
>  
> Your immediate help is highly appreciated.
>  
> Thanks.
>  
> Best Regards,
> Amir
> 
> 
> ______________________________________________________________________
> Express yourself instantly with MSN Messenger! MSN Messenger
> 
> _______________________________________________
> 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
> Support or consulting for your OTRS system?
> => http://www.otrs.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.otrs.org/pipermail/otrs/attachments/20080708/75b62143/attachment.html>