Code Coverage Error

adam_hafner

I am trying to use SQL Test on the test tSQLt database and the tests complete correctly, but the code coverage errors.  The error is as follows:

System.IO.FileLoadException: The located 
assembly's manifest definition does not match the assembly reference. (Exception 
from HRESULT: 0x80131040) at 
SQLCover.Parsers.StatementParser.GetChildStatements(String script, Boolean 
quotedIdentifier) at SQLCover.Source.DatabaseSourceGateway.GetBatches(List`1 
objectFilter, List`1 filteredObjects) at 
SQLCover.CodeCoverage.GenerateResults(List`1 filter, List`1 xml, List`1 
filteredObjects) at SQLCover.CodeCoverage.Stop() at 
RedGate.SQLTest.tSQLt.Cover.SqlCoverTracker.Stop()

There was a similar issue reported that @Jon_Kirkwood responded to that required a new version of SQL Test (https://forum.red-gate.com/discussion/89558/code-coverage-error#latest).  I have tried uninstalling/reinstalling SQL Test and that had no effect.  

Here are the software versions I am running:

SSMS - 20.2.30.0
SQL Test - 4.1.20.3489

Can you please let me know how to resolve this issue?

Thanks,

--Adam

Jon_Kirkwood

Hi @adam_hafner

Thanks for reaching out on the Redgate forum, and sorry to hear this error is occurring for you. I had a look over my old post and can see the dev fix that was done around then. Hopefully this isn't a regression.

I noticed that there was another recent release of SQL Test - before I escalate to the team, can you patch to
V4.1.21 and confirm that the error is still occurring for you

Download link for that version is available here:
https://download.red-gate.com/checkforupdates/SQLTest/SQLTest_4.1.21.3620.exe

adam_hafner

@Jon_Kirkwood I just updated to 4.1.21 and it's still throwing the same error message for coverage in SQL Test.  Can you escalate to your team to investigate?  Thanks!

Jon_Kirkwood

Thank you for confirming and sorry to hear it is still occurring. 
Shall escalate and come back via this forum post with any updates as they are made available

adam_hafner

@Jon_Kirkwood has there been any discussion internally regarding the future use of SQL Cover for performing the coverage analysis?  If you look at the github repo for SQL Cover (https://github.com/GoEddie/SQLCover) it hasn't been updated since 2019.  This seems concerning as there have been enhancements and such to other products that consume the output of SQL Cover that probably should be implemented.  Also, there have been a few forks from this repo to address enhancements and bug fixes that were done purely because this doesn't seem to be maintained anymore.

Here is one of the forks (https://github.com/sayantandey/SQLServerCoverage)
 

Jon_Kirkwood

Hi adam, I am not aware of any conversations around this. 
SQL Test is largely a wrapper for tSQLt and other community driven scripts for unit testing. Our developers focus is primarily on the application itself and the maintenance of the scripts being run is driven by https://tsqlt.org 

adam_hafner

@Jon_Kirkwood Thanks for the response. 

That being said, SQL Cover is not part of tSQLt, it is a library that is solely used by the application itself, so this doesn't seem like it would have anything to do with the maintainers of tSQLt.

Also, have you heard anything in regards to fixing the code coverage error I was receiving?  I know you said you escalated it, but I haven't heard back.

Thanks!

--Adam

adam_hafner

@Jon_Kirkwood any update on when this can be fixed so that the Coverage tab doesn't throw errors?  I have been waiting but haven't seen any updates.

Thanks!

--Adam

adam_hafner

@Jon_Kirkwood I updated SQL Test to 4.2.0.3722 that was released today, but I am still getting the same Code Coverage error.  Any idea when this can be corrected?

adam_hafner

@Jon_Kirkwood, @Dan_J Can either of you find out when this issue will be resolved?  This doesn't seem like it should be a complicated issue to fix to resolve since it has happened in the past and was fixed quickly.  Thanks!

Jon_Kirkwood

Hi Adam, 

 

Can you please conduct a complete uninstallation of SQL Test and try a fresh installation of V4.2.1

Download link here:

https://download.red-gate.com/checkforupdates/SQLTest/SQLTest_4.2.1.3759.exe

 

This has been tested on a similar system (SSMS 20.2.30.0) and is running through tests to display Code Coverage as expected.

As a further check, are you able to look at patching SSMS to a newer version in case there is a DLL conflict occurring. We have referenced a possible conflict that may occur with Microsoft.SqlServer.TransactSql.ScriptDom that may be triggering when accessing the Code Coverage tab.

adam_hafner

@Jon_Kirkwood I did the uninstall and reinstall and it still has the same error.  I can probably patch SSMS if needed.  You would just need to provide me with instructions on how to patch it and where to get the patches from.

Jon_Kirkwood

You should be able to check for updates in SSMS through the Tools > Check for Updates... menu option
This will check your currently installed and the latest GA versions of whatever SSMS you are using.

This will then go to the download page for the latest version which is typically:
https://learn.microsoft.com/en-gb/sql/ssms/download-sql-server-management-studio-ssms

adam_hafner

@Jon_Kirkwood sorry, I previously said at the beginning of this issue that I was running 20.2.30.0 which is the most current release.  What do you want to do now since I am already on the latest SSMS version and it's not working.