We are evaluating SQL Change Automation with Jenkins and we are currently getting the below error message. It looks like the SQL Compare script has run successfully, the temp database is dropped then Invoke-DlmDatabaseSchemaValidation tries to connect to the temp database which does not exist.
Is this a known issue? We are using the AdventureWorks database for testing. Latest version of Jenkins and RedgateTools.
VERBOSE: The database update succeeded
VERBOSE: Dropping temporary database
'dlmautomation_ff38f698-6e72-4fb8-817b-88331cd5e5a3' on '*****'.
Invoke-DlmDatabaseSchemaValidation : Execution Timeout Expired. The timeout
period elapsed prior to completion of the operation or the server is not
responding.
Local parameters [connectionString = Data Source=*****;Initial
Catalog=dlmautomation_ff38f698-6e72-4fb8-817b-88331cd5e5a3;User
ID=****;Password=********;Application Name="SQL Change Automation"]
At C:\Jenkins\workspace\Adventure\PowerShell\SqlCi.ps1:184 char:41
+ ... ptsFolder | Invoke-DlmDatabaseSchemaValidation @temporaryConnection @ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (database 'dlmau...erver 'JN-DB01'
:DatabaseConnection) [Invoke-DatabaseBuild], TerminatingException
+ FullyQualifiedErrorId : SqlScriptExecutionError,RedGate.Versioning.Autom
ation.PowerShell.Commands.InvokeDatabaseBuildCommand
C:\Jenkins\workspace\Adventure\PowerShell\SqlChangeAutomationRunner.ps1 :
Error running SQL Change Automation action: see build log for error details
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorExcep
tion
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorExceptio
n,SqlChangeAutomationRunner.ps1
Build step 'Redgate SQL Change Automation: Build a database package' marked build as failure
Finished: FAILURE
It looks like it is failing when dropping the database
Is this a known issue? We are using the AdventureWorks database for testing. Latest version of Jenkins and RedgateTools.