Article ID: 52639 - Last Review: August 20, 2019
PROBLEM
The WFM Connector was not populating Teleopti data for the Agent Contact Queue Data due to a SQL timeout. This is more common on sites with large databases.
RESOLUTION
This Hotfix is to be applied onto MiContact Center Business version 9.1.0.0.
- Go to https://www.mitel.com/
- Click the Login button.
- Click the Sign in button under MiAccess.
- On the left, select the Software Download Center.
- Expand the tree to MiContact Center Business and then down to MiContact Center Business 9.1.0.0 and HotFixes.
- Download the KB482456 HotFix to the MiContact Center server.
- Double-click the KB482456 and follow the on-screen prompts.
- Wait for the repackager and auto-updates to complete.
- Go to [InstallDir]\Services\ConfigService\ .
- Launch the GlobalAppSettingsEditor.exe .
- Fill in a line with:
- Application: prairieFyre.WFM.Service.exe
- SectionGroup: prairieFyre.WFM.Controller.Common.Properties.Settings
- Name: SQLCommandTimeoutSeconds
- Value: (Enter a value in seconds for the command timeout. This depends on the size of your database and how long it takes to process. Start with 480 and adjust as needed)
- Fill in a second line with:
- Application: prairieFyre.WFM.Service.exe
- SectionGroup: prairieFyre.WFM.Controller.Common.Properties.Settings
- Name: SQLReconnectRetriesCount
- Value: 5 (you can adjust this value as needed)
- Click Save. Note that it can take up to two minutes for the settings to save. Wait for a confirmation prompt before closing the application.
- Run the Historical Data Recollector tool as normal.
NOTE: applying this Hotfix will restart the MiContact Center services. To avoid service interruption apply this patch after hours or during a scheduled maintenance window.
APPLIES TO
MiCC 9.1.1.0
Keywords: Hotfix 482456 KB482456 Teleopti SQL timeout WFM WorkForce Management connector