Invoke-DlmDatabaseSchemaValidation : Execution Timeout Expired.

JohnCore

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

Sergio R

It looks like it is failing when dropping the database

You can try the following:

1 - Increase the timeout value: https://documentation.red-gate.com/sca4/troubleshooting/frequent-error-messages/timeout-expired-error

2 - Rather than using a dynamically created temporary database in LocalDB, you can pre-create a Database in a SQL instance and then set the Temporary Server and Temporary Database fields to connect to it