GSS 3.3.13 - When assigning a large number of tasks to multiple clients, Console might hang or encounter a query timeout expired error.

Products

• Ghost Solution Suite

Issue/Introduction

When assigning a large number of Tasks (100+) to the scope of computers (30+), you might encounter eXpress console performance drop, and generally, the tasks might not be processed properly.

The engine would perform calculations and might encounter Query timeout expired error:

 

Environment

GSS 3.3.12 and 3.3.13

Cause

When executing an internal stored procedure due to an excessive number of computers and schedules (especially on SQL Express edition database), it might encounter a SQL timeout. 

Resolution

Attached improved SP.

This query needs to be executed against the eXpress database in SQL Management Studio to replace the initial SP with the improved.

Full fix will be added in the next GSS release 3.3.14