How can we help you today? How can we help you today?

Code Coverage Error

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

adam_hafner
0

Comments

13 comments

Sort by
  • 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
    Jon_Kirkwood
    0
  • 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!
    adam_hafner
    0
  • 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
    Jon_Kirkwood
    0
  • 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)
     
    adam_hafner
    0
  • 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 


    Jon_Kirkwood
    0
  • 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
    0
  • 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
    0
  • 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
    0
  • 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!
    adam_hafner
    0
  • 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.

    Jon_Kirkwood
    0
  • 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.
    adam_hafner
    0
  • 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


    Jon_Kirkwood
    0
  • 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.
    adam_hafner
    0

Add comment

Please sign in to leave a comment.