应用程序备份和克隆管理员用户无法在SnapCenter的作业监控器中查看作业

适用场景

SnapCenter 服务器(SC) 4.6

问题描述

• 具有备份和克隆查看器角色的用户无法查看Swagger中的任何作业、并在<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

• 使用 Get- SmJobSummaryReport具有备份和克隆查看器角色的用户在PowerShell命令中查看作业。