3383526 - Constraint violation error while increasing the default values for parameters 'max_parallel_io_requests' and 'max_submit_batch_size'

You are following the resolution section of KBA 2899966 to improve the column store table reloading on SAP HANA.

While setting the following I/O parameters to the appropriate values in the correct order (see SAP Help Portal (Documentation) <service>.ini), you encounter constraint violation errors.

1. global.ini -> [fileio] -> size_kernel_io_queue
2. global.ini -> [fileio] -> max_parallel_io_requests
3. global.ini -> [fileio] -> max_submit_batch_size
4. global.ini -> [fileio] -> num_completion_queues
5. global.ini -> [fileio] -> num_submit_queues

[27167]\{135508\}[-1/-1] 2023-08-04 17:54:07.243764 e EmbeddedAPI      Statement.cc(04658) : unhandled ltt exception was caught: conn_id=135508, stmt_id=582005813311875, stmt_hash=96d57203255c90ef054c3e8f0137d787, error=reconfigure failed for node syavsaphana01:35001 with : exception 2160016: prepareReconfigure call failed; $error$=FileStatistics::prepareReconfigure - constraint violated: max_parallel_io_requests= 1024<=512= size_kernel_io_queue; $config$=CompletionQueue; $method$=ConfigMgr::reload

[27167]\{135508\}[-1/-1] 2023-08-04 17:54:07.243764 e EmbeddedAPI      Statement.cc(04658) : unhandled ltt exception was caught: conn_id=135508, stmt_id=582005813311875, stmt_hash=96d57203255c90ef054c3e8f0137d787, error=reconfigure failed for node syavsaphana01:35001 with : exception 2160016: prepareReconfigure call failed; $error$=FileStatistics::prepareReconfigure - constraint violated: max_submit_batch_size= 1024<=64= max_parallel_io_requests; $config$=CompletionQueue; $method$=ConfigMgr::reload

KBA , HAN-DB , SAP HANA Database , How To