Hi Enrico,
This was an issue with the Support Module version 1.1.1 on Oracle
databases. Unfortunately, this (somewhat older) version was shipped
with OTRS 2.4.8. If you upgrade the Support Module via Admin > Package
Manager to the current version, you'll no longer have this issue.
Michiel Beijen
Senior Consultant
OTRS BV
Schipholweg 103
2316 XC Leiden
The Netherlands
T: +31 71 8200 255
F: +31 71 8200 254
I: http://www.otrs.com
OTRS brings true mobility to the Help Desk: The OTRS iPhone App free
download http://www.otrs.com/en/products/iphone-app/
On Tue, Sep 28, 2010 at 5:40 PM, Enrico Papi
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.
--------------------------------------------------------------------- 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