NAME: SAP Business One 10.0 FP 2502, version for SAP HANA
FILE: B1_10.0_FP2502.ZIP
SAPDL: https://me.sap.com/softwarecenter/object/0020000000214132025
SAPNOTE: https://me.sap.com/notes/3549485/E
SAPADMIN: https://help.sap.com/docs/SAP_BUSINESS_ONE_ADMIN_GUIDE_HANA/1a2fc202f7f64336abf9fbc957d9b9ba/6c8b59c7f2a44aa2b474e58b9732e0d4.html?version=10.0_SP_2502&locale=en-US
SAPFILE: B1H1000_2502-70004122.ZIP
*) File Type:ZIP
*) File Version:001
*) File Size:8943203 KB
*) Created On:28.02.2025
*) Changed On:28.02.2025
*) Status:The File is available to download
*) Checksum:02def4e8b4cd9132f20250996e13e2617d86871f6f1bc5d37f073fe39bdffd25
NOTES:
*) SUSE Linux Enterprise Server (SLES) 15 SP4, SP5, and SP6
*) SAP HANA Platform Edition 2.0 SPS 05 Revision 059.09 (with SAP HANA Client Version 2.17.22)
*) SAP HANA Platform Edition 2.0 SPS 05 Revision 059.13 (with SAP HANA Client Version 2.20.22)
*) integration framework for SAP Business One, versions 1.22.63 and 2.0.43
*) zypper in -y libopenssl3 openssl-3

# CLEANUP

## _SYS_REPO.OBJECT_HISTORY (was 19 GB now 9 GB)

verify the oldest records:

```sql
SELECT OBJECT_NAME, PACKAGE_ID, ACTIVATED_AT, RELEASED_AT
FROM "_SYS_REPO"."OBJECT_HISTORY"
ORDER BY ACTIVATED_AT ASC
LIMIT 10;
```

delete older than one year:

```sql
DELETE FROM "_SYS_REPO"."OBJECT_HISTORY"
WHERE ACTIVATED_AT < ADD_YEARS(CURRENT_DATE, -1);
COMMIT;
```

delete older than one year alternative:

```sql
DELETE FROM "_SYS_REPO"."OBJECT_HISTORY"
WHERE RELEASED_AT < ADD_YEARS(CURRENT_DATE, -1);
COMMIT;
```

reclaim memory:

```sql
ALTER SYSTEM RECLAIM DATAVOLUME 120 DEFRAGMENT;
```

If this fails to reclaim space, do the following:
- execute /hana/scripts/backups.sh (3.6)
- reboot
- execute /hana/scripts/backups.sh (3.6)

now the space has been reclaimed