Cognos 11.1.4 is creating multiple connection to redshift for one report - bursting execution and failing with connection limit for non superusers

Cognos 11.1.4 One report with bursting execution is creating many connection at Redshift and failing with connection limit error. Its a odbc type connection.