某些用户无法在 SnapCenter 的作业监视器中查看作业

适用于

SnapCenter 服务器 (SC) 4.6 | 4.8

问题描述

• 某些 SnapCenter 用户无法在 SnapCenter 作业监视器中查看任何作业。
• 当受影响的用户尝试在作业监视器中查看作业时，将在<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

• 受影响的用户可以使用 Powershell 命令查看作业Get- SmJobSummaryReport