Invoke-DatabaseBuild cmdlet freezing

BenYunger

I am trying to build a database from the scripts on an empty database for a CI environment and also create a verbose log to capture any errors and fail the job if the build fails.
I'm trying to use the Invoke-DatabaseBuild cmdlet and have been testing a script from PS, but for some reason it's doing nothing. Here is my shell:

PS C:\Users\byunger> Invoke-DatabaseBuild "C:\Users\byunger\.jenkins\workspace\SQL_BUILD\Database (backend)" -SQLCompareOptions "NoTransactions" 
-TemporaryDatabaseServer 'Data Source=AWS-JENKINS' -TemporaryDatabase 'Data Source=AWS-JENKINS;Initial Catalog=TestBuild'  -Verbose

Invoke-DatabaseBuild, SQL Change Automation 4.3.21041.24117, Copyright © Red Gate Software Ltd 2014-2021
Validating SQL Source Control project 'C:\Users\byunger\.jenkins\workspace\SQL_BUILD\Database (backend)'.

It stays in this running position forever without doing anything. Any help is appreciated!

DanC

Hi @BenYunger

Could you please add the following to the top of your script?

$DebugPreference = 'Continue' 

$VerbosePreference = 'Continue' 

If you prefer, I can also reach out vias a support ticket to keep information confidential and secure! 

BenYunger

Hi, I tried your suggestion , it helped that I can now see verbose logging in the console, but it did not resolve the overall issue. I have an ongoing support ticket 249777, please join to help me resolve this fully.
Thank you

BenYunger

@DanC do you have access the support ticket I have open? Do you have any suggestions?

DanC

Hi @BenYunger

I can see the ticket is with my colleague Pete who should be able to help you resolve that issue!