Browse FAQs

Power Monitoring Expert 8.x and 9.x – How to recover broken Report Subscriptions after SQL Express to SQL Standard upgrade.

Published date: 22 December 2019

Issue
This article describes what to do if report subscriptions do not work after upgrading SQL express to SQL standard.

Environment
Power Monitoring Expert v8.x and v9.x

Cause
Report subscriptions can be saved as SQL Agent mode and Task Scheduler mode. This will be decided by the type of SQL Server installed (Express or Standard), as SQL Server Express doesn't include SQL Server Agent, so it's not possible to just create SQL Agent jobs.

Means by default PME will save report subscriptions to operate as below –

SQL Server Express   => Task Scheduler mode.
SQL Server Standard => SQL Agent mode.

When SQL Express is upgraded to Standard, then PME will switch its operating mode from Task Scheduler mode to SQL Agent mode automatically and the existing subscriptions stops working

Resolution
This issue can be fixed by adding windows registry’ UseIonTaskSchedulerForReportSubscriptions’ and set value to 1 in PME system. This will explicitly tells PME to use Task Scheduler mode so that old report subscriptions will not be affected and future report subscriptions will be created using the same mode (Task Scheduler).


> Open Regedit and navigate to

For PME 8.x
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Schneider Electric\Power Monitoring Expert\8.x

For PME 9.x
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Schneider Electric\Power Monitoring Expert\9.0

> Add a registry key "UseIonTaskSchedulerForReportSubscriptions" REG_DWORD value set to 1 at the reg key . (Find attachment 'PMERegEdit.JPG' for the same)

> Restart the 'ION Report Subscriptions Service'.

Now open PME WebApp and try to edit the report subscriptions

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.