keif888 / SQLServerMetadata

SQL Server Metadata Toolkit
Microsoft Public License
82 stars 32 forks source link

Unexpected error occurred: GenericArguments[0] #19

Closed keif888 closed 6 years ago

keif888 commented 6 years ago

This issue is split from Issue #17 The error below occurred when trying to scan a SSIS 2017 Catalog. Enumerating Integration Services metadata. Unexpected error occurred: GenericArguments[0], 'Microsoft.SqlServer.Management.IntegrationServices.Catalog', on 'Microsoft.SqlServer.Management.Sdk.Sfc.SfcCollection`3[T,K,ParentT]' violates the constraint of type parameter 'T'. Stack Trace: at Microsoft.Samples.DependencyAnalyzer.SSISEnumerator.EnumerateSqlPackages(String server, String user, String pwd, String[] rootFolders, Boolean storeThreePartNames, String[] storePackagePasswords) at Microsoft.Samples.DependencyAnalyzer.Program.EnumerateSSIS(DependencyArguments dependencyArguments, Repository repository) at Microsoft.Samples.DependencyAnalyzer.Program.Main(String[] args)

keif888 commented 6 years ago

Fixed in V0.25.0.0 release. Issue was due to lack of required DLL on client machines (as MS are no longer deploying it as part of the SSDT's installs), and missing .config file for the 2017 analyser.