GetNearestPackageServerInfo.aspx taking longer than 2 minutes to send a result to the client, resulting in timeout

Products

• Deployment Solution

Issue/Introduction

A stored procedure is taking a very long time after the upgrade to process the results.
GetNearestPackageServerInfo.aspx taking longer than 2 minutes to send a result to the client, resulting in timeout

Resolution

We worked through the stored procedure to speed up the process, so it wouldn't time out. To fix this issue install the Cumulative Point fix for 7.6 HF7 TECH234364