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

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
@... ...
krisdinesh
0

Comments

2 comments

Sort by
  • Mike U
    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
    Mike U
    0
  • Mike U
    By the way, please can you confirm the exact version of DLM Automation that you have installed?
    Mike U
    0

Add comment

Please sign in to leave a comment.