Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
Goals and Symptoms
The DBMaintenance job which archives Advanced Report's data is failing and the archives are not being created.
The following error message can be seen in the Windows PowerLogic Event Log:
Message:PerformArchiv_Failed: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Causes and Fixes
Advanced Reports archive job has a default timeout of 30 minutes. If the archive job does not complete in it the time allotted the archive job will quit and the data will not be archived.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs.
The Advanced Reports archive query timeout can be adjusted in the registry at:
HKEY_LOCAL_MACHINE\SOFTWARE\Square D Company\Advanced Reports\Report Database\Archive
Change the DWORD QueryTimeoutSecs from its default value of 1800 (30 minutes) to 14400 (4 hours).
The new timeout value will give the archive job ample time to complete and remove data beyond the retention period from the SMS_AR_Report database.