maybe any developer has some ideas on this … thanks, anselm
Begin forwarded message: > From: Anselm Strauss <[email protected]> > Subject: ora-24817 error > Date: February 16, 2012 11:06:40 AM GMT+01:00 > To: "User questions and discussions about OTRS." <[email protected]> > > hi, > > i have a otrs 3.0.11 running on redhat linux 5.3 with a oracle 10 database. i > upgraded the thing from otrs 2.4. now, in one of the last steps in the > upgrade, i want to reinstall packages. somehow it messed up, and now i have > the new itsm packages installed, but the do not show up in the packages list. > in the httpd log i get tons of the following messages: > > -e: DBD::Oracle::st fetchrow_array failed: ORA-24817: Unable to allocate the > given chunk for current lob operation (DBD ERROR: OCILobRead) [for Statement > "SELECT name, version, install_status, content FROM package_repository ORDER > BY name, create_time"] at /opt/otrs//Kernel/System/DB.pm line 616. > > i guess this error comes when trying to display the list of installed > packages. oracle says the only option is to change the code to use smaller > chunks. is there any tuning i can do in otrs without changing the code? > > during the migration i had the following errors when running > OTRS-DBUpdate-to-3.0-10: > > Message: ORA-02289: sequence does not exist (DBD ERROR: error possibly near > <*> indicator at char 14 in 'DROP SEQUENCE <*>SE_virtual_fs') [for Statement > "DROP SEQUENCE SE_virtual_fs"] at /opt/otrs/Kernel/System/DB.pm line 422. > > Message: Error during table creation! > > Traceback (1641): > Module: main::CreateVirtualFSTables (v1.5) Line: 350 > > Step 5 of 5: Creating VirtualFS tables (if necessary)… Error! > > Migration completed! > > but in the end the migration was complete … > > when i try to install the packages again, it says it can't upgrade the > packages because they are not installed. > > thanks for any help, > anselm strauss
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
