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
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
Released for:Schneider Electric New Zealand
