CI4 with sqlsrv driver sometime throwing error of sqlsrv cursor

While using Codeigniter 4 with sqlsrv driver on linux server, we are getting error on some queries with error code IMSSP/-51 and message as "this function only works with statements that are not scrollable". Same queries are working fine on windows with same sql driver version 5.9.0.

Please find the output of below code we are using to catch the db error : 

PHP Code:

$db = \Config\Database::connect();
$error = $db->error();
print_r($error); 


Code:

Array
(
    [0] => Array
        (
            [0] => IMSSP
            [SQLSTATE] => IMSSP
            [1] => -51
            [code] => -51
            [2] => This function only works with statements that are not scrollable.
            [message] => This function only works with statements that are not scrollable.
        )

)

We are blocked on this issue. Could someone please help us as soon as possible ?
Thanks in advance.