Comments
Sort by recent activity
Is this still some setup issue or it can be some error in script? How can I get more detailed error log to look where exactly this issue is happening? / comments
Is this still some setup issue or it can be some error in script? How can I get more detailed error log to look where exactly this issue is happening?
This issue is solved now and build is completed successfully. I'm now having other issue with Automation Sync step in TeamCity which I'll post in another thread. / comments
This issue is solved now and build is completed successfully. I'm now having other issue with Automation Sync step in TeamCity which I'll post in another thread.
Hi Rob,
I recreated Script folder using SQL Compare Tool but the issue is still same. still getting same error.
[11:22:23][Step 4/7] 'dlmautomation_450ea24c-8598-45e7-b944-252a5d103f45' on 'x.x.x.x'.
[11:22:23][Step 4/7] Invoke-DlmDatabaseSchemaValidation : SQL script failed to execute: Incorrect
[11:22:23][Step 4/7] syntax near the keyword 'ON'.
[11:22:23][Step 4/7] Local parameters [connectionString = Data Source=x.x.x.x;User
[11:22:23][Step 4/7] ID=sa;Password=********;Application Name="Redgate DLM Automation"]
[11:22:23][Step 4/7] At [image] \xxx\RedGate\DLM Automation 2\SqlCi.ps1:138 char:41
[11:22:23][Step 4/7] + ... ptsFolder | Invoke-DlmDatabaseSchemaValidation @temporaryConnection @ ...
[11:22:23][Step 4/7] + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[11:22:23][Step 4/7] + CategoryInfo : NotSpecified: (:) [Invoke-DlmDatabaseSchemaValid
[11:22:23][Step 4/7] ation], TerminatingException
[11:22:23][Step 4/7] + FullyQualifiedErrorId : SqlExecutionError,RedGate.DLMAutomation.PowerShe
[11:22:23][Step 4/7] ll.Commands.InvokeDlmDatabaseSchemaValidationCommand
[11:22:23][Step 4/7] [image] \DevOps\TeamCity\buildAgent\plugins\dlmautomation-teamcity-agent\DLMAutomatio
[11:22:23][Step 4/7] nRunner.ps1 : Error running DLM Automation action: see build log for error
[11:22:23][Step 4/7] details
[11:22:23][Step 4/7] + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorExcep
[11:22:23][Step 4/7] tion
[11:22:23][Step 4/7] + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorExceptio
[11:22:23][Step 4/7] n,DLMAutomationRunner.ps1
[11:22:23][Step 4/7]
[11:22:25][Step 4/7] Process exited with code 1
[11:22:25][Step 4/7] Process exited with code 1
[11:22:25][Step 4/7] Step Database Build (Redgate DLM Automation Build) failed / comments
Hi Rob,
I recreated Script folder using SQL Compare Tool but the issue is still same. still getting same error.
[11:22:23][Step 4/7] 'dlmautomation_450ea24c-8598-45e7-b944-252a5d103f45' on 'x.x.x.x...
I got it working by linking database using others option and then choose Git from config drop down list. But this option is not giving the ability to push my changes after commit from source control tab. / comments
I got it working by linking database using others option and then choose Git from config drop down list. But this option is not giving the ability to push my changes after commit from source contro...
Hi Andrew,
I'm also having same issue.
I'm using GIT and Source Control 5.6.1.5788
Please let me know what else need to be done to filters work on shared model.
Thanks,
Imran / comments
Hi Andrew,
I'm also having same issue.
I'm using GIT and Source Control 5.6.1.5788
Please let me know what else need to be done to filters work on shared model.
Thanks,
Imran
Hi Rob,
I have the same problem. So can you tell me how to choose shared model while linking database using "Link to my source control system" option from setup page.
Thanks,
Imran / comments
Hi Rob,
I have the same problem. So can you tell me how to choose shared model while linking database using "Link to my source control system" option from setup page.
Thanks,
Imran