Getting error after adding a migration script
kailashpatra
Posts: 6 New member
in SQL Compare
Hi Team,
I am using SQL Source Control 5 to link my database with TFVC.
I did a fresh build after linking the database, it was successful. Then I renamed a table and added a migration script and committed to source control. After this the build is failing with below error. Kindly suggest any solution for the same.
[error]SQLCompare.exe terminated with the exit code 255.
[error]SQLCompare.exe produced this error output:
[error]Error: Comparison of 'Scripts.PlugIn' and 'np:\\.\pipe\LOCALDB#B2CCC787\tsql\query.dlmautomation_16dd6cdd-77af-4d71-93f4-038780ac92a3' failed: The type initializer for 'LibGit2Sharp.Core.NativeMethods' threw an exception.
[error]Unhandled Exception: System.TypeInitializationException: The type initializer for 'LibGit2Sharp.Core.NativeMethods' threw an exception. ---> System.DllNotFoundException: Unable to load DLL 'git2-a5cf255': Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
[error] at LibGit2Sharp.Core.NativeMethods.git_libgit2_init()
[error] at LibGit2Sharp.Core.NativeMethods.LibraryLifetimeObject..ctor()
[error] at LibGit2Sharp.Core.NativeMethods..cctor()
[error] --- End of inner exception stack trace ---
[error] at LibGit2Sharp.Core.NativeMethods.RemoveHandle()
[error] at LibGit2Sharp.Core.NativeMethods.LibraryLifetimeObject.Finalize()
[error]Unable to upload artifact from:D:\cccharv\agent1\_work\29\s\PlugIn.20171011.9.nupkg
Finishing task: RedgateDlmAutomationBuild
Regards,
Kailash
I am using SQL Source Control 5 to link my database with TFVC.
I did a fresh build after linking the database, it was successful. Then I renamed a table and added a migration script and committed to source control. After this the build is failing with below error. Kindly suggest any solution for the same.
[error]SQLCompare.exe terminated with the exit code 255.
[error]SQLCompare.exe produced this error output:
[error]Error: Comparison of 'Scripts.PlugIn' and 'np:\\.\pipe\LOCALDB#B2CCC787\tsql\query.dlmautomation_16dd6cdd-77af-4d71-93f4-038780ac92a3' failed: The type initializer for 'LibGit2Sharp.Core.NativeMethods' threw an exception.
[error]Unhandled Exception: System.TypeInitializationException: The type initializer for 'LibGit2Sharp.Core.NativeMethods' threw an exception. ---> System.DllNotFoundException: Unable to load DLL 'git2-a5cf255': Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
[error] at LibGit2Sharp.Core.NativeMethods.git_libgit2_init()
[error] at LibGit2Sharp.Core.NativeMethods.LibraryLifetimeObject..ctor()
[error] at LibGit2Sharp.Core.NativeMethods..cctor()
[error] --- End of inner exception stack trace ---
[error] at LibGit2Sharp.Core.NativeMethods.RemoveHandle()
[error] at LibGit2Sharp.Core.NativeMethods.LibraryLifetimeObject.Finalize()
[error]Unable to upload artifact from:D:\cccharv\agent1\_work\29\s\PlugIn.20171011.9.nupkg
Finishing task: RedgateDlmAutomationBuild
Regards,
Kailash
Tagged:
Best Answer
-
Mike U
Posts: 316 Gold 1
If you are using migration scripts, you'll need to upgrade to DLM Automation 2.Development Lead
Redgate Software
Answers
Redgate Software
I am using DLM Automation 1 as of now. On the build agent "git2-a5cf255.dll" is not present where you mentioned but it is present inside agent/task folder. The user account has access to that file as well.