sap errors and solutions

Just another SAP blog

SAP HANA database backup fails with “[447] backup could not be completed, [1000002] Allocation failed” error

The below error logs are found in backup.log 

The data backups of your HANA database are failing due to following error: [447] backup could not be completed, [1000002] Allocation failed ; $size$=426870912; $name$=ChannelUtils::copy; $type$=pool; $inuse_count$=0; $allocated_size$=0

447: backup could not be completed: [8022830] ltt::exception caught while operating on IDBackupCatalog, [1000002] Allocation failed ; $size$=124383; $name$=Page; $type$=pool; $inuse_count$=26; $allocated_size$=2248124 SQLSTATE: HY000

To correct these errors, either Hana parameters need to be adjusted or the DB needs to be shut down and restarted. However, HANA DB restart wouldn’t be a permanent solution for this issue.

Cause:
The default memory allocation limit for the HANA statistics server process is insufficient for newer HANA SPS releases (SPS5+). As a consequence the backup of the statistics server may fail.

Solution:

Increase the memory limit of the statistics server.

1. To increase the memory limit of the statistics server, In the HANA Studio navigation, open the “Administration”-tab of the affected system using the SYSTEM user.

2. In the “Configuration”-view expand the statistics server.ini and memorymanager. You should see the following:

1

2

3. Right-click on “allocationlimit” and choose “change”.

4. Set the value to 10% or even higher, depending on the memory capabilities of your host.

Note: Recommended values are between “5%” and “20%” and higher in exceptional cases, for example “25%”. The value must be adjusted to match the system requirements (memory size, number of tables).

3

5. Go to the “Landscape”-tab and select “reconfigure service” for the “indexserver” service to reconfigures the indexserver service by applying the current configuration parameters.

Note:In Support Package 7 and later, you can migrate the statistics server (see SAP Notes 1917938 and 1925684). After the migration, a separate statistics server process no longer exists. The new embedded statistics server has a lower memory consumption.

5

4

Use below URL to perform the ALTER SYSTEM RECONFIGURE SERVICE using SQL statements

https://help.sap.com/saphelp_hanaplatform/helpdata/en/20/d23ead751910148f18dcd2a0862e90/content.htm

6. Repeat the backup.

For more information refer below SAP Notes:

1929538 – HANA Statistics Server – Out of Memory

2036111 – Configuration parameters for the SAP HANA system

Updated: December 7, 2016 — 2:33 pm

Leave a Reply

Your email address will not be published. Required fields are marked *

sap errors and solutions © 2016 Frontier Theme
Copy Protected by Chetan's WP-Copyprotect.