Skip to main content
NetApp Knowledge Base

App Backup and Clone Admin users are unable to view the jobs in SnapCenter's job monitor

Views:
292
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

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.

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.