How to create and populate ION_Data Archive without the use of powershell or database manager.exe

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:

1. Open SQL Server Management Studio. Navigate to the ION_Data database. Right click on ION_Data -> Tasks -> Generate Scripts.
2. Create a script with the below configuration
1. Choose Objects: Script entire database and all database objects
2. Set Scripting Options: Save as script file
1. Confirm under Advanced that type of data to script is Schema Only
1. 
3. Click Next until the script is saved.
4. 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.
1. 
5. 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.
6. Run the query.
7. 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.
1. 
8. Right Click on the database archive -> Properties -> Files -> Owner -> Set to ION or the Windows user running the PME services.
1. 
9. 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.
1. SourceDBNameValue: ION_Data
2. ArchiveDBNameValue: "Your Archive Name"
3. StartDateValue: YYYY-MM-DD
4. EndDateValue: YYYY-MM-DD
5. ArchiveIntervalValue: 1 (this is your revenue data)
6. ArchiveEventValue: 1 (this is your event data)
7. ArchiveWaveformValue: 1 (this is your waveform data)
8. It is recommended that if trimming is needed, do this post archive to increase the query speeds. Select 0 for the remaining values.
10. Press OK.

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