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

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 
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


Tagged:

Answers

Sign In or Register to comment.