Jenkins Plugin: Redgate DLM Automation: Error while building a pakage

Invoke-DlmDatabaseSchemaValidation : SQLCompare.exe terminated with the exit
code 255.
SQLCompare.exe produced this error output:

Unhandled Exception: System.InvalidOperationException: Showing a modal dialog
box or form when the application is not running in UserInteractive mode is not
a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style
to display a notification from a service application.
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at System.Windows.Forms.Form.ShowDialog()
at #6Qdb.#ERX.#PRX()
at #6Qdb.#ERX.#kA6()
at #6Qdb.#ERX.#Iz6()
at #6Qdb.#ERX.#dI6()
at #zRX.#ARX.#4H6(#8U0 #WJrc)
at #zRX.#ARX.#u3.#lqZ()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext
executionContext, ContextCallback callback, Object state, Boolean
preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext,
ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext,
ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
At C:\Program Files (x86)\Red Gate\DLM Automation 2\sqlci.ps1:138 char:41
+ $validatedSchema = $scriptsFolder | Invoke-DlmDatabaseSchemaValidation
@temp ...
Tagged:

Comments

  • This is the SQL Compare command line trying to ask for consent to send back usage information. It shouldn't be doing this, because it's supposed to know that it's running headless. We'll investigate why this is happening, but for now, you can work around it by setting the following registry key, while logged in as the user that the Jenkins build agent runs as:

    Under key
    HKEY_CURRENT_USER\Software\Red Gate\SQL Tools
    
    Add a new string value
    SmartAssemblyReportUsage
    
    with the value
    False
    
    Development Lead
    Redgate Software
  • By the way, please can you confirm the exact version of DLM Automation that you have installed?
    Development Lead
    Redgate Software
Sign In or Register to comment.