"Tell Redgate About this Error" re-appear never-ending, after every "Cancel" or "Send Error Report"

Nursalim

Every time have an Azure SQL MI connection on my SSMS 2019, I will almost always having "Tell Redgate About this Error" dialog message. Error Details is "One or more errors occurred."  So I do not know exactly what error it is.

This dialog message re-appear never-endingly every after I clicked "Cancel" or "Send Error Report" buttons. I can get rid of this error by restarting the SSMS!

The error is almost always triggered triggered when I do Schema compare/deploy or Data Compare/Deploy, the error will mostly show (not always show) after dragging the Azure database to the "Target" or "Source".

DanC

Hi @Nursalim

Sorry to hear you're experiencing this issue!

Can I ask what version of SQL Source Control you're using?

If you go to Help > About SQL Source Control

Nursalim

It is 7.2.35.13078. We have just had the license since 3/3/2022. Thank you!

DanC

Hi @Nursalim

Would you be able to try with the latest version here? https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.3.22.15267.exe

a.higgins

note: I'm having that same problem, with SSMS 18.11.1 (and earlier with 18.10. something). 

I've tried Redgate SQL Source Control 7.3.10.14545, 7.3.22.15267, and a couple others with version numbers I haven't saved.  I'm going to go back and try some earlier versions. 

DanC

Hi @Nursalim @a.higgins

Would you be able to check the log files for SQL Source Control and see if you see an error message along the following lines:

Could not load file or assembly 'Azure.Core, Version=1.6.0.0, Culture=neutral,  PublicKeyToken=92742159e12e44c8' or one of its dependencies. The system cannot find the file specified.

a.higgins

@DanC, I do remember seeing that error message at one point, yes; I didn't specifically write down which version of step in the process I saw it at, though.  If you can let me know where the log would be located, I can go take a look for you. EDIT: found the log, confirmed that the error you referenced is present. 

7.2.35.13078 seems to be working okay ... I was able to use an older install file last night to get that installed, and haven't seen the error again. 

DanC

Hi @a.higgins

Ah, yes this is currently a bug that's being investigated and the working version goes up to 7.2.40, anything higher experiences the issue, if you can please lockdown to that version. The bug reference is VT-143 so any updates you see that fixes the issue will include this reference

a.higgins

Thanks @DanC.  I'm still having an issue with 7.2.35 ... looking at the logs, the error being recorded says something like:

ErrorCode: invalid_grant

Microsoft.Identity.Client.MsalUiRequiredException: AADSTS50196: The server terminated an operation because it encountered a client request loop. 

DanC

Hi @a.higgins

Could you try installing the following version as this should fix that issue: https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.2.40.13374.exe

a.higgins

@DanC, so far so good - I've installed that this morning, and have not yet seen any recurrence of the problem. 

DanC

Hi @a.higgins

Fantastic, I'll keep you informed of any further updates in regards to a fix in the latest versions

DanC

Hi @a.higgins @Nursalim

Thank you for your patience on this issue, I can now let you know the latest version of SQL Source Control includes a fix for this issue:

 

7.3.31.15722 - June 1st, 2022

Improvements

• Updated SQL Compare Engine to 14.7.8.21113

Fixes

• VT-143 - Fixed a bug causing an error 'Could not load file or assembly 'Azure.Core..." when using Active Directory Authentication in Azure.

 

https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.3.31.15722.exe