We are getting an ABAP runtime error DBIF_RSQL_SQL_ERROR and because of this SQL array DML operations is failing too.
Short text: "-10709" while accessing table "/BIC/B0007166000".
Database error text: "Connect failed (no reachable host left)"
The work process trace file contains error messages like this:
B ***LOG BY4=> sql error 2048 performing INS on table /BIC/B0007166000 [dbtrtab 3770]
B ***LOG BY0=> column store error:  Error allocating rows to parts;Could not determine parts for multi-level partitioning. [dbtrtab 3770]
This problem was mainly observed in BW on HANA systems when loading data into PSA tables or InfoProviders.
This problem may also occur for partitioned tables in single node systems.
The following partitioning types are affected:
Do as below:
As a workaround deactivate the client-side functionality by adding the following parameter to section distribution in indexserver.ini:
split_batch_commands = off
You can also use the following SQL statement to set the parameter:
ALTER SYSTEM ALTER CONFIGURATION('indexserver.ini','SYSTEM') SET ('distribution', 'split_batch_commands') = 'off' WITH RECONFIGURE;