PME - How to archive ION_Data manually via SSMS

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

SQL Server Management Studio

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:

1) Open SQL Server Management Studio.

2) Navigate to the ION_Data database. Right-click on ION_Data -> Tasks -> Generate Scripts.
3) Create a script with the below configuration
4) Choose Objects: Script the entire database and all database objects
5) Set Scripting Options: Save as script file
6) Confirm under Advanced that the type of data to script is Schema Only

7) Click Next until the script is saved.
8) 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.

9) Set MAXSIZE for the .ldf and .mdf files 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.
10) Execute the query.
11) 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.
12) Right-click on the database archive -> Properties -> Files -> Owner -> Set to ION or the Windows user running the PME services.

13) 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)

14) It is recommended that if trimming is needed, do this post archive to increase the query speeds. Select 0 for the remaining values.
15) Press OK.

게시 대상: 슈나이더 일렉트릭 Korea