What are the challenges you face when working across database platforms? Take the survey

Invoke-DlmDatabaseSchemaValidation : Execution Timeout Expired.

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 
Local parameters [connectionString = Data Source=*****;Initial 
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 
C:\Jenkins\workspace\Adventure\PowerShell\SqlChangeAutomationRunner.ps1 : 
Error running SQL Change Automation action: see build log for error details
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorExcep 
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorExceptio 
Build step 'Redgate SQL Change Automation: Build a database package' marked build as failure
Finished: FAILURE



Sign In or Register to comment.