Power Monitoring Expert 8.x and 9.x – How to recover broken Report Subscriptions after SQL Express to SQL Standard upgrade.
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
發佈於: 施耐德電機Taiwan
需要協助？
產品選型工具
快速輕鬆地為您的應用找到合適的產品和附件。
取得報價
立即線上提交您的銷售需求，專業團隊將主動聯繫您。
購買地點
輕鬆在您所在地區找到最近的施耐德電機經銷商。
支援中心
在同一位置找到滿足您所有需求的支援資源。