[dev] Fwd: ora-24817 error

maybe any developer has some ideas on this … thanks, anselm Begin forwarded message:

From: Anselm Strauss Subject: ora-24817 error Date: February 16, 2012 11:06:40 AM GMT+01:00 To: "User questions and discussions about OTRS."

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