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

krisdineshkrisdinesh Posts: 1 New member
in DLM Automation
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:
· Share on Twitter

Comments

  • Mike UMike U Posts: 316 Gold 1
    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
    · Share on Twitter
  • Mike UMike U Posts: 316 Gold 1
    By the way, please can you confirm the exact version of DLM Automation that you have installed?
    Development Lead
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.