Issue

Archives will not run through scheduled tasks on a distributed system.

Product Line

Power Monitoring Expert 8.x

Power Monitoring Expert 9.x

Power Monitoring Expert 2020

Power Monitoring Expert 2021

Power Monitoring Expert 2022

Power Monitoring Expert 2023

Power Monitoring Expert 2024

Environment

SQL Server Database

Cause

Scheduled tasks on distributed systems need to be set up. This is commonly handled by the database administrator and will need to be configured following an upgrade or migration.

Resolution

Resolution 1:

Follow the steps listed in the PME System Guide: https://product-help.schneider-electric.com/EcoStruxure/Power-Monitoring-Expert-2024/content/8_reference/configuring/database_maintenance/ref_dbmaint_setuparchivetask.htm

Resolution 2:

If the above does not work follow the steps below:

Open SQL Server Management Studio. Navigate to the ION_Data database. Right click on ION_Data -> Tasks -> Generate Scripts.
Create a script with the below configuration

Choose Objects: Script entire database and all database objects
Set Scripting Options: Save as script file

Confirm under Advanced that type of data to script is Schema Only

Click Next until the script is saved.
In SSMS, File -> Open recently saved script. Press Ctrl + F to search for all references to ION_Data. Click the leftmost dropdown error to expand the replace option. Replace ION_Data with the desired name of your archive.

Set MAXSIZE for the .ldf and .mdf file to be unlimited. Set SIZE to be a reasonable size depending on the length of the archive. Make sure the location to which the archive is being saved can accommodate the size of the .ldf and .mdf files.
Run the query.
If successful, disconnect and reconnect to the PME SQL Server instance. Confirm that the archive is attached to the instance by locating it in the database tree.

Right Click on the database archive -> Properties -> Files -> Owner -> Set to ION or the Windows user running the PME services.

Open up the ION_Data tree by clicking on the + symbol. Navigate to Programmability -> Stored Procedures -> Right click on dbo.Archive and select Execute Stored Procedure.

SourceDBNameValue: ION_Data
ArchiveDBNameValue: Your Archive Name
StartDateValue: YYYY-MM-DD
EndDateValue: YYYY-MM-DD
ArchiveIntervalValue: 1 (this is your revenue data)
ArchiveEventValue: 1 (this is your event data)
ArchiveWaveformValue: 1 (this is your waveform data)
It is recommended that if trimming is needed, do this post archive to increase the query speeds. Select 0 for the remaining values.