Issue
This issue can present itself in a couple of different ways:
1. In PME 8.2, if you have created a PME user group, and this user group includes a mix of supervisor-level and non-supervisor-level users, saved reports created by the non-supervisor level users will not be visible to the supervisor-level users that are part of this same group.
For example, you created a PME user group called 'My PME Users', and in that group are Jack and Joan, who both have Operator level access, and Betty and Bill who both have Supervisor level access. Jack and Joan have both configured and saved a number of reports. If Betty or Bill log into Reports, neither of them will be able to see the reports saved by either Jack or Joan, even though, as supervisors, they should be able to see all saved reports. This was not the case in earlier versions of PME.
2. A PME 8.x system includes the configuration described above. In the older system, the supervisor-level users would be able to see all saved reports in the system. However, once the system is upgraded to PME 8.2, Jack and Joan's saved reports will no longer be visible to Betty and Bill. Immediately after the upgrade, if you are logged in, it may look as if the report tree is not displaying all the expected reports.
Product Line
Power Monitoring Expert 8.2
Environment
Web Applications - Reports
Cause
A change was made to one of the stored procedures in the ION_Network database that inadvertently resulted in the behavior described above..
Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
This problem can be resolved by updating the stored procedure called 'spAC_GetUserRole.
To do this
1. Save the attached file to some known location on the server
2. Start SQL Server Management Studio.
*Warning: Take a backup of the ION_Network database prior to modifying it.
3. Within SQL Server Management Studio, choose File -> Open and browse to the sql file in step 1.
4. Choose 'Execute' or F5 to run the sql file.
Additional Information
This problem will not exist in Power Monitoring Expert 9.0 and greater because the entire structure of users and groups has been redesigned.
This issue can present itself in a couple of different ways:
1. In PME 8.2, if you have created a PME user group, and this user group includes a mix of supervisor-level and non-supervisor-level users, saved reports created by the non-supervisor level users will not be visible to the supervisor-level users that are part of this same group.
For example, you created a PME user group called 'My PME Users', and in that group are Jack and Joan, who both have Operator level access, and Betty and Bill who both have Supervisor level access. Jack and Joan have both configured and saved a number of reports. If Betty or Bill log into Reports, neither of them will be able to see the reports saved by either Jack or Joan, even though, as supervisors, they should be able to see all saved reports. This was not the case in earlier versions of PME.
2. A PME 8.x system includes the configuration described above. In the older system, the supervisor-level users would be able to see all saved reports in the system. However, once the system is upgraded to PME 8.2, Jack and Joan's saved reports will no longer be visible to Betty and Bill. Immediately after the upgrade, if you are logged in, it may look as if the report tree is not displaying all the expected reports.
Product Line
Power Monitoring Expert 8.2
Environment
Web Applications - Reports
Cause
A change was made to one of the stored procedures in the ION_Network database that inadvertently resulted in the behavior described above..
Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
This problem can be resolved by updating the stored procedure called 'spAC_GetUserRole.
To do this
1. Save the attached file to some known location on the server
2. Start SQL Server Management Studio.
*Warning: Take a backup of the ION_Network database prior to modifying it.
3. Within SQL Server Management Studio, choose File -> Open and browse to the sql file in step 1.
4. Choose 'Execute' or F5 to run the sql file.
Additional Information
This problem will not exist in Power Monitoring Expert 9.0 and greater because the entire structure of users and groups has been redesigned.
Released for: Schneider Electric Saudi Arabia
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales enquiry online and an expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Centre
Find support resources for all your needs, in one place.
