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 <[email protected]> wrote: > 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 > --------------------------------------------------------------------- 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
