SAP BW HANA - How to solve issue - Maximum number of rows per partition reached for [table_name]

Please try to run Delta merge manually for that table.

Hopefully, You may not get error next time.

You can check this out for more knowledge:
https://apps.support.sap.com/sap/support/knowledge/mimes/call.htm?number=2212518