Hi,
After importing the Microsoft System Center Management Pack for Storage Spaces Direct (1.0.46.0) in SCOM 2016 UR6 I am getting even after 24 hours waiting the message "An error has occurred", when I select the "Storage Spaces Direct 2016"
dashboard.
A click on "Details" shows additional infos about the error:
An error occurred executing the command: [Microsoft.Windows.Server.Storage.Visualization.Library.DataProviders!DatacenterDashboardDataProvider/GetDatacenterDashboardData] in provider: [Microsoft.Windows.Server.Storage.Visualization.Library.DataProviders.DatacenterDashboardDataProvider,
Microsoft.Windows.Server.Storage.Visualization.Library.DataProviders, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]. : Incorrect syntax near ','.
Incorrect syntax near the keyword 'CONVERT'.
Incorrect syntax near the keyword 'AS'.
at Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderCommandMethod.Invoke(CoreDataGateway gateWay, DataCommand command)
at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.ExecuteScalarInternal[TResult](DataCommand command)
at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.<ExecuteScalarAsync>b__2[TResult](<>f__AnonymousType0`1 data)
In addition I get some event ids:
33333, source "DataAccessLayer":
Data Access Layer rejected retry on SqlError:
Request: MTV_Select_d0b32736-5344-2fcc-74b3-f72dc64ef572
Class: 15
Number: 102
Message: Incorrect syntax near ','.
26319, source OpsMgr SDK Service:
Data Access Layer rejected retry on SqlError:
Request: MTV_Select_d0b32736-5344-2fcc-74b3-f72dc64ef572
Class: 15
Number: 102
Message: Incorrect syntax near ','.
Might it be possible that the "Microsoft.Windows.Server.10.0.Storage.StorageSpacesDirect.Presentation.mpb" in version 1.0.46.0 is broken or incompatible to SCOM 2016 UR6? How to solve the error?
Regards,