Unable to remove high number of Config version iterations

Version 1

    Verified Product Versions

    AppSense Management Center 8.7

    Introduction

    In the Management Server Console if you attempt to remove a high number of configs or config version iterations you may receive a SQL timeout or the Console to stop responding.

    Detail

    The issue is the these deletions will produce a high number of SQL requests. The Connection Object (ADO) is set to 30 seconds so if the requests are not completed in that time it will produce this behaviour.  Typically we will see this issue when attempting to delete a large number of versions/iterations at one time.

    This can be worked around by deleting small numbers at a time which will prevent a SQL timeout.