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.
- Press OK.
게시 대상:슈나이더 일렉트릭 Korea
