Skip to Content

Error when trying to Drop Schema

Mar 05 at 11:58 AM


avatar image

Hi All

We are busying testing an upgrade to SAP9.3 PL02 and it failed on the 2 schemas we are testing on. This in a test environment.
I want to drop the schemas and try on a more recent backup as I did not get an error code reason or note for the failed upgrade.
However, when I try to drop those schema's I get an error:
[129]: transaction rolled back by an internal error: Allocation failed; $size$=648; $name$; $type$=pool; $inuse_count$=632593; $allocated_size$=530359301

I get the same error by trying to right click on the schema and delete(CASCADE) or if i use the drop schema <SCHEMANAME> cascade;

Does anyone know how to resolve this issue?

Thanks all
Jerusha :)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Bartosz Jarkowski Mar 05 at 12:20 PM

I'm not familiar with Business One, but as your database is SAP HANA I think I can answer :)

Based on the error message you require more memory on the HANA database. Check SAP Note 1999997 - FAQ: SAP HANA Memory - already the first point there address your issue.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Bartosz

Thank you. Do you think that is the cause for the upgrade fail? just wondering.




yes, that would be my guess.