PME 2021 - after upgrade, the windows tasks for db maintenance/backup no longer run - login error

Product Line
Power Monitoring Expert 2021
_____________________________________________________________
Environment
The issue has been introduced in PME2021 and seems to affect only in-place upgrades of standalone systems.
_____________________________________________________________
Issue
PME 2021 - after the upgrade, the windows tasks for db maintenance/backup no longer run - login error

In the Task Scheduler UI will see 0x1F4 under Last Run Result

You will see an information event in the Windows Application log saying:
Login failed for user 'STANDALONE\IONMaintenance'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]



WARNING: If this problem is not noticed, there could be data loss since no database backups will be created. During upgrades, makes sure the Maintenance task successfully run

_____________________________________________________________
Steps to Reproduce the Issue /Investigation/ (Optional)

1. Start with a PME 2020 system.
2. Verify that you can run the windows tasks for db maintenance and backup. If you are using a Test Auto VM, you will have to enable them
3. Upgrade to PME 2021
4. Try to run the windows tasks - any of them

_____________________________________________________________
Root Cause
When PME installer (Database.Core.broker.xml) tries to create IOMaintenance login, it will execute a set of actions:
1. it will create STANDALONE\IONMaintenance sql server login (login type - windows)
2. it will create STANDALONE\IONMaintenance user in the respective DBs
3. it will configure the user (DEFAULT_SCHEMA=dbo and alter roles (db_backupoperator, db_ddladmin & Maintenance)

For the fresh system: There is no issues when we set the configuration.
For the UPG system: #1 & #2 will not be executed as it is already there but #3 will be executed and that causes the login into an invalid state where the user will not be able to log in. So, to resolve the issue, we must recreate the login.


_____________________________________________________________
Proposed Solution

The workaround is doing the same thing as it is mentioned above. If IONMaintenance sql server login is not working, please follow the instruction below.

If IONMaintenance sql server login is not working, please follow the instruction below.

1. Delete the STANDALONE\IONMaintenance from (server)>Security>Logins
2. Select “Create new Login” from (server)>Security>Logins context menu. Specify the Login Name as STANDALONE\IONMaintenance

3. Configure the Server Role page as per the following screen shot

4. Configure ApplicationModules as per the screen shot.

5. Configure ION_Data as per the screen shot.

6. Configure ION_Network as per the screen shot.

7. Configure ION_SystemLog as per the screen shot.

8. Configure Securables as per the screen shot.

_____________________________________________________________
Attachments/Links

1. PME 2021 - after the upgrade, the windows tasks for db maintenance tasks no longer run.pdf

_____________________________________________________________

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