Hi all, we have successfully installed OTRS 2.4.8 on CentOS 5.5 with Oracle 10.2.0.24 as DB. After the checking the correct permission on /opt/otrs tree, adding oracle related lines in Config.pm and checking all perl modules are ok, we have the following problem when accessing to "Support Assessment" in the Admin panel.
Software error: Can't call method "fetchrow_array" on an undefined value at /opt/otrs//Kernel/System/DB.pm line 622. I want to underline this is not the first time we deploy otrs on this oracle installation and with otrs 2.4.7 and itsm 2.0.3 all worked well with the same Config.pm. Obviously the database it is not the same but a new empty one. I've analyzed the log/http/error_log and after i try to access to "Support Assessment" the following errors are added:
[Tue Sep 28 16:58:47 2010] -e: DBD::Oracle::db prepare failed: ORA-00923: FROM keyword not found where expected (DBD ERROR: error possibly near <*> indicator at char 24 in 'SELECT current_timestamp<*>') [for Statement "SELECT current_timestamp"] at /opt/otrs//Kernel/System/DB.pm line 550. ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Tue Sep 28 16:58:47 2010
Message: ORA-00923: FROM keyword not found where expected (DBD ERROR: error possibly near <*> indicator at char 24 in 'SELECT current_timestamp<*>'), SQL: 'SELECT current_timestamp'
Traceback (3626): Module: Kernel::System::Support::Database::oracle::_CurrentTimestampCheck (v1.20) Line: 273 Module: Kernel::System::Support::Database::oracle::AdminChecksGet (v1.20) Line: 66 Module: Kernel::System::Support::Database::AdminChecksGet (v1.12) Line: 151 Module: Kernel::System::Support::AdminChecksGet (v1.43) Line: 157 Module: Kernel::Modules::AdminSupport::Run (v1.28) Line: 297 Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 48 Module: (eval) (v1.88) Line: 204 Module: ModPerl::RegistryCooker::run (v1.88) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31 These error messages are almost always associated with the followings:
-e: Use of uninitialized value in int at /opt/otrs//Kernel/Output/HTML/DashboardTicketGeneric.pm line 70. -e: Use of uninitialized value in int at /opt/otrs//Kernel/Output/HTML/DashboardUserOnline.pm line 74. _-e: utf8 "\xFC" does not map to Unicode at /opt/otrs//Kernel/System/Config.pm line 161, <$In> chunk 1._ -e: DBD::Oracle::st execute failed: ORA-01861: literal does not match format string It look like the problem is related to Oracle timestamps. Although we had added the correct options in our Config.pm $ENV{'ORACLE_HOME'} = '/opt/oracle/oracle/product/10.2.0/db_1'; $ENV{'NLS_LANG'} = "italian_italy.utf8"; $ENV{'NLS_DATE_FORMAT'} = 'YYYY-MM-DD HH24:MI:SS'; this is not working. Anyway, we finally tried to install ITSM 2.0.3 on top of this otrs development. After that we have many other error/warnings related to oracle/db timestamp/date with many otrs function, completely different from "support assessment". So we think it is a problem in some basic function. Someone else have the same problem? Any ideas? thx in advance.