App Backup and Clone Admin users are unable to view the jobs in SnapCenter's job monitor
Applies to
SnapCenter Server (SC) 4.6
Issue
- Users that have the Backup and Clone Viewer role are unable to view any jobs in Swagger with the error seen in the
<installation_path>\NetApp\SnapCenter\App_Data\log\SnapManagerWeb_<id>.log
:
2022-08-03T01:15:20.1633401-07:00 INFO SnapManagerWeb PID=[6440] TID=[20] GetJobsByUserToObjectAccess Begin
2022-08-03T01:15:22.7883401-07:00 INFO SnapManagerWeb PID=[6440] TID=[20] GetJobsByUserToObjectAccess End
2022-08-03T01:15:22.8039599-07:00 INFO SnapManagerWeb PID=[6440] TID=[20] Query completed Query
2022-08-03T01:15:23.1476931-07:00 ERROR SnapManagerWeb PID=[6440] TID=[20] System.Data.Entity.Core.EntityCommandCompilationException: An error occurred while preparing the command definition. See the inner exception for details. ---> System.NotSupportedException: OUTER APPLY is not supported by MySQL. at Devart.Data.MySql.Entity.e.a(b0 A_0)
at Devart.Common.Entity.bn.a(e1 A_0, String A_1, e1 A_2, i& A_3)
at Devart.Common.Entity.bn.a(a1 A_0)
at Devart.Common.Entity.bn.a(e1 A_0, Boolean A_1, i& A_2)
at Devart.Common.Entity.bn.a(c4 A_0, List`1& A_1)
at Devart.Common.Entity.bn.b(c4 A_0, List`1& A_1)
at Devart.Data.MySql.Entity.al.a(c4 A_0, DbCommandBase A_1)
at Devart.Common.Entity.bk.c()
at Devart.Data.MySql.Entity.MySqlEntityProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition..ctor(DbProviderFactory storeProviderFactory, DbCommandTree commandTree, DbInterceptionContext interceptionContext, IDbDependencyResolver resolver, BridgeDataReaderFactory bridgeDataReaderFactory, ColumnMapFactory columnMapFactory)
--- End of inner exception stack trace ---
.
.
.
2022-08-03T01:15:23.1476931-07:00 DEBUG SnapManagerWeb PID=[6440] TID=[20] OUTER APPLY is not supported by MySQL.
2022-08-03T01:15:23.1476931-07:00 INFO SnapManagerWeb PID=[6440] TID=[20] Exit Query
2022-08-03T01:15:23.1476931-07:00 INFO SnapManagerWeb PID=[6440] TID=[20] Exit GetJobs
- Jobs are seen with the Powershell commnad
Get- SmJobSummaryReport
using the user with the Backup and Clone Viewer role.