Unable to publish Artifacts at the build stage
Ravin
Posts: 6 Bronze 1
Hi,
When I tried to build the repository in Bamboo it gets successful but it is not able publish the Artifacts. Can any one help me with this please?
simple 24-Aug-2017 12:37:10 Build DataHub CI - Test DB CI - Default Job #22 (DH01-TDC-JOB1-22) started building on agent Default Agent
simple 24-Aug-2017 12:37:10
simple 24-Aug-2017 12:37:10 Build working directory is C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1
simple 24-Aug-2017 12:37:10 Executing build DataHub CI - Test DB CI - Default Job #22 (DH01-TDC-JOB1-22)
simple 24-Aug-2017 12:37:10 Starting task 'Checkout Default Repository' of type 'com.atlassian.bamboo.plugins.vcs:task.vcs.checkout'
simple 24-Aug-2017 12:37:10 Updating source code to revision: 4015462a0f4ca0c025550d8a2b2a01bad50e1e83
simple 24-Aug-2017 12:37:10 Git: Updating references
simple 24-Aug-2017 12:37:10 Git:
simple 24-Aug-2017 12:37:10 Fetching '+refs/heads/master:refs/heads/master' from 'ssh://git@bitbucket.dev.com:8000/dhci/datahub-db.git'.
simple 24-Aug-2017 12:37:10 Checking out revision 4015462a0f4ca0c025550d8a2b2a01bad50e1e83.
simple 24-Aug-2017 12:37:10 Updated source code to revision: 4015462a0f4ca0c025550d8a2b2a01bad50e1e83
simple 24-Aug-2017 12:37:10 Finished task 'Checkout Default Repository' with result: Success
simple 24-Aug-2017 12:37:10 Running pre-build action: VCS Version Collector
simple 24-Aug-2017 12:37:10 Starting task 'DataHub Build Package' of type 'com.redgate.sqlci.bamboo.bamboosqlci:sqlcibuild'
error 24-Aug-2017 12:37:10 Unable to find executable at "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe". Will try to run it anyway.
command 24-Aug-2017 12:37:10 Beginning to execute external process for build 'DataHub CI - Test DB CI - Default Job #22 (DH01-TDC-JOB1-22)'\n ... running command line: \n"C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" -NonInteractive -ExecutionPolicy Bypass -File "C:\Program Files (x86)\Red Gate\DLM Automation 2\\sqlci.ps1" -Verbose Build -scriptsFolder C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1 -packageId DataHub01 -packageVersion 1.22 -includeDocs\n ... in: C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1\n ... using extra environment variables: \nbamboo_planRepository_1_branch=master\nbamboo_planRepository_1_branchDisplayName=master\nbamboo_repository_revision_number=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_capability_system_builder_msbuild_MSBuild_v14_0__64bit_=C:\Program Files (x86)\MSBuild\14.0\bin\amd64\MSBuild.exe\nbamboo_resultsUrl=http://bamboo.dev.com/browse/DH01-TDC-JOB1-22\nbamboo_capability_system_builder_msbuild_MSBuild_v4_0__32bit_=C:\Windows\Microsoft.NET\Framework\v4.0.30319\MSBuild.exe\nbamboo_planRepository_1_name=Test DH BI\nbamboo_build_working_directory=C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1\nbamboo_buildKey=DH01-TDC-JOB1\nbamboo_shortPlanName=Test DB CI\nbamboo_planRepository_name=Test DH BI\nbamboo_buildNumber=22\nbamboo_shortJobName=Default Job\nbamboo_buildResultsUrl=http://bamboo.dev.com/browse/DH01-TDC-JOB1-22\nbamboo_planRepository_repositoryUrl=ssh://git@bitbucket.dev.com:8000/dhci/datahub-db.git\nbamboo_agentId=196609\nbamboo_planName=DataHub CI - Test DB CI\nbamboo_shortPlanKey=TDC\nbamboo_shortJobKey=JOB1\nREDGATE_FUR_ENVIRONMENT=Bamboo Plugin\nbamboo_planRepository_revision=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_repository_previous_revision_number=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_buildTimeStamp=2017-08-24T12:37:10.025+01:00\nbamboo_repository_425986_name=Test DH BI\nbamboo_planRepository_previousRevision=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_capability_system_jdk_JDK_1_8_0_144=C:\Program Files\Java\jre1.8.0_144\nbamboo_buildResultKey=DH01-TDC-JOB1-22\nbamboo_repository_git_branch=master\nbamboo_repository_branch_name=master\nbamboo_buildPlanName=DataHub CI - Test DB CI - Default Job\nbamboo_planRepository_1_revision=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_repository_425986_git_branch=master\nbamboo_repository_425986_previous_revision_number=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_repository_name=Test DH BI\nbamboo_repository_425986_git_username=\nbamboo_dependenciesDisabled=false\nbamboo_buildFailed=false\nbamboo_planRepository_branch=master\nbamboo_agentWorkingDirectory=C:\Users\Bamboo-home\xml-data\build-dir\nbamboo_planRepository_1_previousRevision=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_repository_git_username=\nbamboo_planRepository_branchDisplayName=master\nbamboo_planRepository_1_type=bbserver\nbamboo_planRepository_branchName=master\nbamboo_capability_system_jdk_JDK=C:\Program Files\Java\jre1.8.0_144\nbamboo_plan_storageTag=plan-589825\nbamboo_planRepository_type=bbserver\nbamboo_planRepository_1_username=\nbamboo_ManualBuildTriggerReason_userName=d1208939\nbamboo_capability_system_builder_msbuild_MSBuild_v14_0__32bit_=C:\Program Files (x86)\MSBuild\14.0\bin\MSBuild.exe\nbamboo_repository_git_repositoryUrl=ssh://git@bitbucket.dev.com:8000/dhci/datahub-db.git\nbamboo_capability_system_builder_msbuild_MSBuild_v4_0__64bit_=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\MSBuild.exe\nbamboo_working_directory=C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1\nbamboo_planKey=DH01-TDC\nbamboo_repository_425986_git_repositoryUrl=ssh://git@bitbucket.dev.com:8000/dhci/datahub-db.git\nbamboo_planRepository_1_repositoryUrl=ssh://git@bitbucket.dev.com:8000/dhci/datahub-db.git\nbamboo_planRepository_username=\nbamboo_capability_system_jdk_JDK_1_8=C:\Program Files\Java\jre1.8.0_144\nbamboo_repository_425986_revision_number=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_repository_425986_branch_name=master\nbamboo_planRepository_1_branchName=master\n
build 24-Aug-2017 12:37:11 Setting ErrorActionPreference to "Stop" because no -ErrorAction argument was provided
build 24-Aug-2017 12:37:11 VERBOSE: Loading module from path 'C:\Program Files (x86)\Red Gate\DLM Automation
build 24-Aug-2017 12:37:11 2\Modules\DlmAutomation\DlmAutomation.psd1'.
build 24-Aug-2017 12:37:11 VERBOSE: Loading 'FormatsToProcess' from path 'C:\Program Files (x86)\Red Gate\DLM Automation
build 24-Aug-2017 12:37:11 2\Modules\DlmAutomation\DLMAutomation.Format.ps1xml'.
build 24-Aug-2017 12:37:11 VERBOSE: Loading module from path 'C:\Program Files (x86)\Red Gate\DLM Automation
build 24-Aug-2017 12:37:11 2\Modules\DlmAutomation\DLMAutomation.dll'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Export-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Export-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Export-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Export-DlmDatabaseTestResults'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Import-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Import-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Import-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DlmManualDatabaseSchemaValidation'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Invoke-DlmDatabaseSchemaValidation'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Invoke-DlmDatabaseTests'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Publish-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DlmDatabaseDocumentation'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Unregister-DlmSerialNumber'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Register-RedgateDlmSerialNumber'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Register-DlmSerialNumber'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Sync-DlmDatabaseSchema'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Use-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Use-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DlmDatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Test-DatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Test-DlmDatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Export-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Export-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Export-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Export-DlmDatabaseTestResults'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Import-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Import-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Import-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Invoke-DlmDatabaseSchemaValidation'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Invoke-DlmDatabaseTests'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DlmDatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DlmDatabaseDocumentation'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DlmManualDatabaseSchemaValidation'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Publish-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Register-DlmSerialNumber'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Register-RedgateDlmSerialNumber'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Sync-DlmDatabaseSchema'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Test-DatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Test-DlmDatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Unregister-DlmSerialNumber'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Use-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Use-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:12 Invoke-DlmDatabaseSchemaValidation, DLM Automation 2.0.16.453, Copyright c Red Gate Software Ltd 2014-2017
build 24-Aug-2017 12:37:12 VERBOSE: Machine Information:
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 OperatingSystem: Microsoft Windows NT 6.3.9600.0
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 OsBitVersion: x64
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 MachineName: *******
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 CurrentUser: dev\SVCBambooZ01
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 TempDirectory: C:\Users\SVCBambooZ01\AppData\Local\Temp\
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 HostProcessName: powershell
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 ProcessorCount: 2
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 TotalPhysicalMemory: 8191 MB
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 AvailablePhysicalMemory: 3837 MB
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 Is64BitProcess: True
build 24-Aug-2017 12:37:12 In trial: expires 2017/09/19 12:00:54 +01:00
build 24-Aug-2017 12:37:12 VERBOSE: Parameters:
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 InputObject: C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 TemporaryDatabaseServer: null
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 TemporaryDatabase: null
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 SQLCompareOptions:
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 TransactionIsolationLevel: Serializable
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 FilterPath:
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 QueryBatchTimeout: 0
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 IgnoreParserErrors: False
build 24-Aug-2017 12:37:12 Validating schema in scripts folder 'C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1'.
build 24-Aug-2017 12:37:12 VERBOSE: Using temporary database on LocalDB.
build 24-Aug-2017 12:37:13 VERBOSE: Created temporary database 'dlmautomation_9c998405-4630-418c-8ad2-d18844e748d8' on
build 24-Aug-2017 12:37:13 'np:\\.\pipe\LOCALDB#EB27B851\tsql\query'.
build 24-Aug-2017 12:37:13 VERBOSE: Updating database 'dlmautomation_9c998405-4630-418c-8ad2-d18844e748d8' on server
build 24-Aug-2017 12:37:13 'np:\\.\pipe\LOCALDB#EB27B851\tsql\query' to schema in scripts folder.
build 24-Aug-2017 12:37:13 VERBOSE: Using filter in scripts folder 'C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1'
build 24-Aug-2017 12:37:13 VERBOSE: Calling: C:\Program Files (x86)\Red Gate\DLM Automation 2\SC\SQLCompare.exe
build 24-Aug-2017 12:37:13 "/filter:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\hkr5bwiy.scpf"
build 24-Aug-2017 12:37:13 /options:ConsiderNextFilegroupInPartitionSchemes,DecryptPost2kEncryptedObjects,DoNotOutputCommentHeader,ForceColumnOrde
build 24-Aug-2017 12:37:13 r,IgnoreCertificatesAndCryptoKeys,IgnoreDatabaseAndServerName,IgnoreUserProperties,IgnoreUsersPermissionsAndRoleMembers
build 24-Aug-2017 12:37:13 hips,IgnoreWhiteSpace,IgnoreWithElementOrder,IncludeDependencies,ThrowOnFileParseFailed,UseCompatibilityLevel
build 24-Aug-2017 12:37:13 /transactionIsolationLevel:SERIALIZABLE /include:staticData "/scriptFile:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM
build 24-Aug-2017 12:37:13 Automation\sjceqhyw.sql" /showWarnings /include:Identical "/report:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM
build 24-Aug-2017 12:37:13 Automation\1kwgro5h.xml" /reportType:Xml /assertidentical /force /OutputWidth:1024
build 24-Aug-2017 12:37:13 /scripts1:C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1 /server2:np:\\.\pipe\LOCALDB#EB27B851\tsql\query
build 24-Aug-2017 12:37:13 /database2:dlmautomation_9c998405-4630-418c-8ad2-d18844e748d8 /out:"C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM
build 24-Aug-2017 12:37:13 Automation\k3daxs4q.log"
build 24-Aug-2017 12:37:19 VERBOSE: C:\Program Files (x86)\Red Gate\DLM Automation 2\SC\SQLCompare.exe ended with exit code 0
build 24-Aug-2017 12:37:19 VERBOSE: SQLCompare.exe completed successfully.
build 24-Aug-2017 12:37:19 Schema validation successful.
build 24-Aug-2017 12:37:19 VERBOSE: Dropping temporary database 'dlmautomation_9c998405-4630-418c-8ad2-d18844e748d8' on
build 24-Aug-2017 12:37:19 'np:\\.\pipe\LOCALDB#EB27B851\tsql\query'.
build 24-Aug-2017 12:37:23 New-DlmDatabaseDocumentation, DLM Automation 2.0.16.453, Copyright c Red Gate Software Ltd 2014-2017
build 24-Aug-2017 12:37:23 In trial: expires 2017/09/19 12:00:54 +01:00
build 24-Aug-2017 12:37:23 VERBOSE: Parameters:
build 24-Aug-2017 12:37:23
build 24-Aug-2017 12:37:23 InputObject: RedGate.DLMAutomation.Compare.SchemaValidation.ValidatedSchemaSource
build 24-Aug-2017 12:37:23
build 24-Aug-2017 12:37:23 TemporaryDatabaseServer: null
build 24-Aug-2017 12:37:23
build 24-Aug-2017 12:37:23 TemporaryDatabase: null
build 24-Aug-2017 12:37:23
build 24-Aug-2017 12:37:23 FilterPath:
build 24-Aug-2017 12:37:23
build 24-Aug-2017 12:37:23 IgnoreParserErrors: False
build 24-Aug-2017 12:37:23
build 24-Aug-2017 12:37:23 SQLCompareOptions:
build 24-Aug-2017 12:37:23 VERBOSE: Using temporary database on LocalDB.
build 24-Aug-2017 12:37:23 VERBOSE: Created temporary database 'dlmautomation_9dc59715-aae7-4e0a-a6a9-021b551559f9' on
build 24-Aug-2017 12:37:23 'np:\\.\pipe\LOCALDB#EB27B851\tsql\query'.
build 24-Aug-2017 12:37:23 VERBOSE: Updating database 'dlmautomation_9dc59715-aae7-4e0a-a6a9-021b551559f9' on server
build 24-Aug-2017 12:37:23 'np:\\.\pipe\LOCALDB#EB27B851\tsql\query' to schema in scripts folder.
build 24-Aug-2017 12:37:23 VERBOSE: Using filter in scripts folder 'C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\mlah2tvo.ghr'
build 24-Aug-2017 12:37:23 VERBOSE: Calling: C:\Program Files (x86)\Red Gate\DLM Automation 2\SC\SQLCompare.exe
build 24-Aug-2017 12:37:23 "/filter:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\urhevtf4.scpf"
build 24-Aug-2017 12:37:23 /options:ConsiderNextFilegroupInPartitionSchemes,DecryptPost2kEncryptedObjects,DoNotOutputCommentHeader,ForceColumnOrde
build 24-Aug-2017 12:37:23 r,IgnoreCertificatesAndCryptoKeys,IgnoreDatabaseAndServerName,IgnoreUserProperties,IgnoreUsersPermissionsAndRoleMembers
build 24-Aug-2017 12:37:23 hips,IgnoreWhiteSpace,IgnoreWithElementOrder,IncludeDependencies,ThrowOnFileParseFailed,UseCompatibilityLevel
build 24-Aug-2017 12:37:23 /transactionIsolationLevel:SERIALIZABLE /include:staticData "/scriptFile:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM
build 24-Aug-2017 12:37:23 Automation\nx3cwvk1.sql" /showWarnings /include:Identical "/report:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM
build 24-Aug-2017 12:37:23 Automation\jjcskyuj.xml" /reportType:Xml /assertidentical /force /OutputWidth:1024
build 24-Aug-2017 12:37:23 "/scripts1:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\mlah2tvo.ghr"
build 24-Aug-2017 12:37:23 /server2:np:\\.\pipe\LOCALDB#EB27B851\tsql\query /database2:dlmautomation_9dc59715-aae7-4e0a-a6a9-021b551559f9
build 24-Aug-2017 12:37:23 /out:"C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\vjjtbiyi.log"
build 24-Aug-2017 12:37:30 VERBOSE: C:\Program Files (x86)\Red Gate\DLM Automation 2\SC\SQLCompare.exe ended with exit code 0
build 24-Aug-2017 12:37:30 VERBOSE: SQLCompare.exe completed successfully.
build 24-Aug-2017 12:37:30 Generating documentation for scripts folder 'C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1'.
build 24-Aug-2017 12:37:30 VERBOSE: Calling: C:\Program Files (x86)\Red Gate\DLM Automation 2\SDOC\SQLDoc.exe
build 24-Aug-2017 12:37:30 "/project:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\tpjxfq03.ghu\project.sqldoc"
build 24-Aug-2017 12:37:30 /server:np:\\.\pipe\LOCALDB#EB27B851\tsql\query /database:dlmautomation_9dc59715-aae7-4e0a-a6a9-021b551559f9
build 24-Aug-2017 12:37:30 /out:"C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\fcqy1gnv.log"
build 24-Aug-2017 12:37:44 VERBOSE: C:\Program Files (x86)\Red Gate\DLM Automation 2\SDOC\SQLDoc.exe ended with exit code 0
build 24-Aug-2017 12:37:44 VERBOSE: SQLDoc.exe completed successfully.
build 24-Aug-2017 12:37:44 Documentation created successfully.
build 24-Aug-2017 12:37:44 VERBOSE: Dropping temporary database 'dlmautomation_9dc59715-aae7-4e0a-a6a9-021b551559f9' on
build 24-Aug-2017 12:37:44 'np:\\.\pipe\LOCALDB#EB27B851\tsql\query'.
build 24-Aug-2017 12:37:47 New-DlmDatabasePackage, DLM Automation 2.0.16.453, Copyright c Red Gate Software Ltd 2014-2017
build 24-Aug-2017 12:37:47 In trial: expires 2017/09/19 12:00:54 +01:00
build 24-Aug-2017 12:37:47 VERBOSE: Parameters:
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 InputObject: RedGate.DLMAutomation.Compare.SchemaValidation.ValidatedSchemaSource
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 PackageId: DataHub01
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 PackageVersion: 1.22
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 PackageDescription: null
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 Documentation: RedGate.DLMAutomation.Compare.Documentation.SchemaDocumentation
build 24-Aug-2017 12:37:47 Export-DlmDatabasePackage, DLM Automation 2.0.16.453, Copyright c Red Gate Software Ltd 2014-2017
build 24-Aug-2017 12:37:47 In trial: expires 2017/09/19 12:00:54 +01:00
build 24-Aug-2017 12:37:47 VERBOSE: Parameters:
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 InputObject: Database Package
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 Path: .
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 Force: False
build 24-Aug-2017 12:37:48 Database package exported to file 'C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1\DataHub01.1.22.nupkg'.
simple 24-Aug-2017 12:37:50 Finished task 'DataHub Build Package' with result: Success
simple 24-Aug-2017 12:37:50 Skipping execution of task 'Sync to DB' as it is disabled
simple 24-Aug-2017 12:37:50 Running post build plugin 'NCover Results Collector'
simple 24-Aug-2017 12:37:50 Running post build plugin 'Artifact Copier'
simple 24-Aug-2017 12:37:50 Publishing an artifact: DataHub Artifact
error 24-Aug-2017 12:37:50 Unable to publish artifact [DataHub Artifact]:
simple 24-Aug-2017 12:37:50 The artifact hasn't been successfully published after 18.90 ms
simple 24-Aug-2017 12:37:50 Running post build plugin 'npm Cache Cleanup'
simple 24-Aug-2017 12:37:50 Running post build plugin 'Clover Results Collector'
simple 24-Aug-2017 12:37:50 Running post build plugin 'Docker Container Cleanup'
simple 24-Aug-2017 12:37:50 Finalising the build...
simple 24-Aug-2017 12:37:50 Stopping timer.
simple 24-Aug-2017 12:37:50 Build DH01-TDC-JOB1-22 completed.
simple 24-Aug-2017 12:37:50 Running on server: post build plugin 'NCover Results Collector'
simple 24-Aug-2017 12:37:50 Running on server: post build plugin 'Build Hanging Detection Configuration'
simple 24-Aug-2017 12:37:50 Running on server: post build plugin 'Clover Delta Calculator'
simple 24-Aug-2017 12:37:50 Running on server: post build plugin 'Maven Dependencies Postprocessor'
simple 24-Aug-2017 12:37:50 All post build plugins have finished
simple 24-Aug-2017 12:37:50 Generating build results summary...
simple 24-Aug-2017 12:37:50 Saving build results to disk...
simple 24-Aug-2017 12:37:50 Logging substituted variables...
simple 24-Aug-2017 12:37:50 Indexing build results...
simple 24-Aug-2017 12:37:50 Finished building DH01-TDC-JOB1-22.
When I tried to build the repository in Bamboo it gets successful but it is not able publish the Artifacts. Can any one help me with this please?
simple 24-Aug-2017 12:37:10 Build DataHub CI - Test DB CI - Default Job #22 (DH01-TDC-JOB1-22) started building on agent Default Agent
simple 24-Aug-2017 12:37:10
simple 24-Aug-2017 12:37:10 Build working directory is C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1
simple 24-Aug-2017 12:37:10 Executing build DataHub CI - Test DB CI - Default Job #22 (DH01-TDC-JOB1-22)
simple 24-Aug-2017 12:37:10 Starting task 'Checkout Default Repository' of type 'com.atlassian.bamboo.plugins.vcs:task.vcs.checkout'
simple 24-Aug-2017 12:37:10 Updating source code to revision: 4015462a0f4ca0c025550d8a2b2a01bad50e1e83
simple 24-Aug-2017 12:37:10 Git: Updating references
simple 24-Aug-2017 12:37:10 Git:
simple 24-Aug-2017 12:37:10 Fetching '+refs/heads/master:refs/heads/master' from 'ssh://git@bitbucket.dev.com:8000/dhci/datahub-db.git'.
simple 24-Aug-2017 12:37:10 Checking out revision 4015462a0f4ca0c025550d8a2b2a01bad50e1e83.
simple 24-Aug-2017 12:37:10 Updated source code to revision: 4015462a0f4ca0c025550d8a2b2a01bad50e1e83
simple 24-Aug-2017 12:37:10 Finished task 'Checkout Default Repository' with result: Success
simple 24-Aug-2017 12:37:10 Running pre-build action: VCS Version Collector
simple 24-Aug-2017 12:37:10 Starting task 'DataHub Build Package' of type 'com.redgate.sqlci.bamboo.bamboosqlci:sqlcibuild'
error 24-Aug-2017 12:37:10 Unable to find executable at "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe". Will try to run it anyway.
command 24-Aug-2017 12:37:10 Beginning to execute external process for build 'DataHub CI - Test DB CI - Default Job #22 (DH01-TDC-JOB1-22)'\n ... running command line: \n"C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" -NonInteractive -ExecutionPolicy Bypass -File "C:\Program Files (x86)\Red Gate\DLM Automation 2\\sqlci.ps1" -Verbose Build -scriptsFolder C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1 -packageId DataHub01 -packageVersion 1.22 -includeDocs\n ... in: C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1\n ... using extra environment variables: \nbamboo_planRepository_1_branch=master\nbamboo_planRepository_1_branchDisplayName=master\nbamboo_repository_revision_number=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_capability_system_builder_msbuild_MSBuild_v14_0__64bit_=C:\Program Files (x86)\MSBuild\14.0\bin\amd64\MSBuild.exe\nbamboo_resultsUrl=http://bamboo.dev.com/browse/DH01-TDC-JOB1-22\nbamboo_capability_system_builder_msbuild_MSBuild_v4_0__32bit_=C:\Windows\Microsoft.NET\Framework\v4.0.30319\MSBuild.exe\nbamboo_planRepository_1_name=Test DH BI\nbamboo_build_working_directory=C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1\nbamboo_buildKey=DH01-TDC-JOB1\nbamboo_shortPlanName=Test DB CI\nbamboo_planRepository_name=Test DH BI\nbamboo_buildNumber=22\nbamboo_shortJobName=Default Job\nbamboo_buildResultsUrl=http://bamboo.dev.com/browse/DH01-TDC-JOB1-22\nbamboo_planRepository_repositoryUrl=ssh://git@bitbucket.dev.com:8000/dhci/datahub-db.git\nbamboo_agentId=196609\nbamboo_planName=DataHub CI - Test DB CI\nbamboo_shortPlanKey=TDC\nbamboo_shortJobKey=JOB1\nREDGATE_FUR_ENVIRONMENT=Bamboo Plugin\nbamboo_planRepository_revision=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_repository_previous_revision_number=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_buildTimeStamp=2017-08-24T12:37:10.025+01:00\nbamboo_repository_425986_name=Test DH BI\nbamboo_planRepository_previousRevision=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_capability_system_jdk_JDK_1_8_0_144=C:\Program Files\Java\jre1.8.0_144\nbamboo_buildResultKey=DH01-TDC-JOB1-22\nbamboo_repository_git_branch=master\nbamboo_repository_branch_name=master\nbamboo_buildPlanName=DataHub CI - Test DB CI - Default Job\nbamboo_planRepository_1_revision=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_repository_425986_git_branch=master\nbamboo_repository_425986_previous_revision_number=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_repository_name=Test DH BI\nbamboo_repository_425986_git_username=\nbamboo_dependenciesDisabled=false\nbamboo_buildFailed=false\nbamboo_planRepository_branch=master\nbamboo_agentWorkingDirectory=C:\Users\Bamboo-home\xml-data\build-dir\nbamboo_planRepository_1_previousRevision=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_repository_git_username=\nbamboo_planRepository_branchDisplayName=master\nbamboo_planRepository_1_type=bbserver\nbamboo_planRepository_branchName=master\nbamboo_capability_system_jdk_JDK=C:\Program Files\Java\jre1.8.0_144\nbamboo_plan_storageTag=plan-589825\nbamboo_planRepository_type=bbserver\nbamboo_planRepository_1_username=\nbamboo_ManualBuildTriggerReason_userName=d1208939\nbamboo_capability_system_builder_msbuild_MSBuild_v14_0__32bit_=C:\Program Files (x86)\MSBuild\14.0\bin\MSBuild.exe\nbamboo_repository_git_repositoryUrl=ssh://git@bitbucket.dev.com:8000/dhci/datahub-db.git\nbamboo_capability_system_builder_msbuild_MSBuild_v4_0__64bit_=C:\Windows\Microsoft.NET\Framework64\v4.0.30319\MSBuild.exe\nbamboo_working_directory=C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1\nbamboo_planKey=DH01-TDC\nbamboo_repository_425986_git_repositoryUrl=ssh://git@bitbucket.dev.com:8000/dhci/datahub-db.git\nbamboo_planRepository_1_repositoryUrl=ssh://git@bitbucket.dev.com:8000/dhci/datahub-db.git\nbamboo_planRepository_username=\nbamboo_capability_system_jdk_JDK_1_8=C:\Program Files\Java\jre1.8.0_144\nbamboo_repository_425986_revision_number=4015462a0f4ca0c025550d8a2b2a01bad50e1e83\nbamboo_repository_425986_branch_name=master\nbamboo_planRepository_1_branchName=master\n
build 24-Aug-2017 12:37:11 Setting ErrorActionPreference to "Stop" because no -ErrorAction argument was provided
build 24-Aug-2017 12:37:11 VERBOSE: Loading module from path 'C:\Program Files (x86)\Red Gate\DLM Automation
build 24-Aug-2017 12:37:11 2\Modules\DlmAutomation\DlmAutomation.psd1'.
build 24-Aug-2017 12:37:11 VERBOSE: Loading 'FormatsToProcess' from path 'C:\Program Files (x86)\Red Gate\DLM Automation
build 24-Aug-2017 12:37:11 2\Modules\DlmAutomation\DLMAutomation.Format.ps1xml'.
build 24-Aug-2017 12:37:11 VERBOSE: Loading module from path 'C:\Program Files (x86)\Red Gate\DLM Automation
build 24-Aug-2017 12:37:11 2\Modules\DlmAutomation\DLMAutomation.dll'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Export-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Export-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Export-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Export-DlmDatabaseTestResults'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Import-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Import-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Import-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DlmManualDatabaseSchemaValidation'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Invoke-DlmDatabaseSchemaValidation'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Invoke-DlmDatabaseTests'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Publish-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DlmDatabaseDocumentation'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Unregister-DlmSerialNumber'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Register-RedgateDlmSerialNumber'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Register-DlmSerialNumber'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Sync-DlmDatabaseSchema'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Use-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Use-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DlmDatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'New-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Test-DatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Exporting cmdlet 'Test-DlmDatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Export-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Export-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Export-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Export-DlmDatabaseTestResults'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Import-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Import-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Import-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Invoke-DlmDatabaseSchemaValidation'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Invoke-DlmDatabaseTests'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DlmDatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DlmDatabaseDocumentation'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'New-DlmManualDatabaseSchemaValidation'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Publish-DlmDatabasePackage'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Register-DlmSerialNumber'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Register-RedgateDlmSerialNumber'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Sync-DlmDatabaseSchema'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Test-DatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Test-DlmDatabaseConnection'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Unregister-DlmSerialNumber'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Use-DatabaseRelease'.
build 24-Aug-2017 12:37:11 VERBOSE: Importing cmdlet 'Use-DlmDatabaseRelease'.
build 24-Aug-2017 12:37:12 Invoke-DlmDatabaseSchemaValidation, DLM Automation 2.0.16.453, Copyright c Red Gate Software Ltd 2014-2017
build 24-Aug-2017 12:37:12 VERBOSE: Machine Information:
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 OperatingSystem: Microsoft Windows NT 6.3.9600.0
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 OsBitVersion: x64
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 MachineName: *******
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 CurrentUser: dev\SVCBambooZ01
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 TempDirectory: C:\Users\SVCBambooZ01\AppData\Local\Temp\
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 HostProcessName: powershell
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 ProcessorCount: 2
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 TotalPhysicalMemory: 8191 MB
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 AvailablePhysicalMemory: 3837 MB
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 Is64BitProcess: True
build 24-Aug-2017 12:37:12 In trial: expires 2017/09/19 12:00:54 +01:00
build 24-Aug-2017 12:37:12 VERBOSE: Parameters:
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 InputObject: C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 TemporaryDatabaseServer: null
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 TemporaryDatabase: null
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 SQLCompareOptions:
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 TransactionIsolationLevel: Serializable
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 FilterPath:
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 QueryBatchTimeout: 0
build 24-Aug-2017 12:37:12
build 24-Aug-2017 12:37:12 IgnoreParserErrors: False
build 24-Aug-2017 12:37:12 Validating schema in scripts folder 'C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1'.
build 24-Aug-2017 12:37:12 VERBOSE: Using temporary database on LocalDB.
build 24-Aug-2017 12:37:13 VERBOSE: Created temporary database 'dlmautomation_9c998405-4630-418c-8ad2-d18844e748d8' on
build 24-Aug-2017 12:37:13 'np:\\.\pipe\LOCALDB#EB27B851\tsql\query'.
build 24-Aug-2017 12:37:13 VERBOSE: Updating database 'dlmautomation_9c998405-4630-418c-8ad2-d18844e748d8' on server
build 24-Aug-2017 12:37:13 'np:\\.\pipe\LOCALDB#EB27B851\tsql\query' to schema in scripts folder.
build 24-Aug-2017 12:37:13 VERBOSE: Using filter in scripts folder 'C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1'
build 24-Aug-2017 12:37:13 VERBOSE: Calling: C:\Program Files (x86)\Red Gate\DLM Automation 2\SC\SQLCompare.exe
build 24-Aug-2017 12:37:13 "/filter:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\hkr5bwiy.scpf"
build 24-Aug-2017 12:37:13 /options:ConsiderNextFilegroupInPartitionSchemes,DecryptPost2kEncryptedObjects,DoNotOutputCommentHeader,ForceColumnOrde
build 24-Aug-2017 12:37:13 r,IgnoreCertificatesAndCryptoKeys,IgnoreDatabaseAndServerName,IgnoreUserProperties,IgnoreUsersPermissionsAndRoleMembers
build 24-Aug-2017 12:37:13 hips,IgnoreWhiteSpace,IgnoreWithElementOrder,IncludeDependencies,ThrowOnFileParseFailed,UseCompatibilityLevel
build 24-Aug-2017 12:37:13 /transactionIsolationLevel:SERIALIZABLE /include:staticData "/scriptFile:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM
build 24-Aug-2017 12:37:13 Automation\sjceqhyw.sql" /showWarnings /include:Identical "/report:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM
build 24-Aug-2017 12:37:13 Automation\1kwgro5h.xml" /reportType:Xml /assertidentical /force /OutputWidth:1024
build 24-Aug-2017 12:37:13 /scripts1:C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1 /server2:np:\\.\pipe\LOCALDB#EB27B851\tsql\query
build 24-Aug-2017 12:37:13 /database2:dlmautomation_9c998405-4630-418c-8ad2-d18844e748d8 /out:"C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM
build 24-Aug-2017 12:37:13 Automation\k3daxs4q.log"
build 24-Aug-2017 12:37:19 VERBOSE: C:\Program Files (x86)\Red Gate\DLM Automation 2\SC\SQLCompare.exe ended with exit code 0
build 24-Aug-2017 12:37:19 VERBOSE: SQLCompare.exe completed successfully.
build 24-Aug-2017 12:37:19 Schema validation successful.
build 24-Aug-2017 12:37:19 VERBOSE: Dropping temporary database 'dlmautomation_9c998405-4630-418c-8ad2-d18844e748d8' on
build 24-Aug-2017 12:37:19 'np:\\.\pipe\LOCALDB#EB27B851\tsql\query'.
build 24-Aug-2017 12:37:23 New-DlmDatabaseDocumentation, DLM Automation 2.0.16.453, Copyright c Red Gate Software Ltd 2014-2017
build 24-Aug-2017 12:37:23 In trial: expires 2017/09/19 12:00:54 +01:00
build 24-Aug-2017 12:37:23 VERBOSE: Parameters:
build 24-Aug-2017 12:37:23
build 24-Aug-2017 12:37:23 InputObject: RedGate.DLMAutomation.Compare.SchemaValidation.ValidatedSchemaSource
build 24-Aug-2017 12:37:23
build 24-Aug-2017 12:37:23 TemporaryDatabaseServer: null
build 24-Aug-2017 12:37:23
build 24-Aug-2017 12:37:23 TemporaryDatabase: null
build 24-Aug-2017 12:37:23
build 24-Aug-2017 12:37:23 FilterPath:
build 24-Aug-2017 12:37:23
build 24-Aug-2017 12:37:23 IgnoreParserErrors: False
build 24-Aug-2017 12:37:23
build 24-Aug-2017 12:37:23 SQLCompareOptions:
build 24-Aug-2017 12:37:23 VERBOSE: Using temporary database on LocalDB.
build 24-Aug-2017 12:37:23 VERBOSE: Created temporary database 'dlmautomation_9dc59715-aae7-4e0a-a6a9-021b551559f9' on
build 24-Aug-2017 12:37:23 'np:\\.\pipe\LOCALDB#EB27B851\tsql\query'.
build 24-Aug-2017 12:37:23 VERBOSE: Updating database 'dlmautomation_9dc59715-aae7-4e0a-a6a9-021b551559f9' on server
build 24-Aug-2017 12:37:23 'np:\\.\pipe\LOCALDB#EB27B851\tsql\query' to schema in scripts folder.
build 24-Aug-2017 12:37:23 VERBOSE: Using filter in scripts folder 'C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\mlah2tvo.ghr'
build 24-Aug-2017 12:37:23 VERBOSE: Calling: C:\Program Files (x86)\Red Gate\DLM Automation 2\SC\SQLCompare.exe
build 24-Aug-2017 12:37:23 "/filter:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\urhevtf4.scpf"
build 24-Aug-2017 12:37:23 /options:ConsiderNextFilegroupInPartitionSchemes,DecryptPost2kEncryptedObjects,DoNotOutputCommentHeader,ForceColumnOrde
build 24-Aug-2017 12:37:23 r,IgnoreCertificatesAndCryptoKeys,IgnoreDatabaseAndServerName,IgnoreUserProperties,IgnoreUsersPermissionsAndRoleMembers
build 24-Aug-2017 12:37:23 hips,IgnoreWhiteSpace,IgnoreWithElementOrder,IncludeDependencies,ThrowOnFileParseFailed,UseCompatibilityLevel
build 24-Aug-2017 12:37:23 /transactionIsolationLevel:SERIALIZABLE /include:staticData "/scriptFile:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM
build 24-Aug-2017 12:37:23 Automation\nx3cwvk1.sql" /showWarnings /include:Identical "/report:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM
build 24-Aug-2017 12:37:23 Automation\jjcskyuj.xml" /reportType:Xml /assertidentical /force /OutputWidth:1024
build 24-Aug-2017 12:37:23 "/scripts1:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\mlah2tvo.ghr"
build 24-Aug-2017 12:37:23 /server2:np:\\.\pipe\LOCALDB#EB27B851\tsql\query /database2:dlmautomation_9dc59715-aae7-4e0a-a6a9-021b551559f9
build 24-Aug-2017 12:37:23 /out:"C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\vjjtbiyi.log"
build 24-Aug-2017 12:37:30 VERBOSE: C:\Program Files (x86)\Red Gate\DLM Automation 2\SC\SQLCompare.exe ended with exit code 0
build 24-Aug-2017 12:37:30 VERBOSE: SQLCompare.exe completed successfully.
build 24-Aug-2017 12:37:30 Generating documentation for scripts folder 'C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1'.
build 24-Aug-2017 12:37:30 VERBOSE: Calling: C:\Program Files (x86)\Red Gate\DLM Automation 2\SDOC\SQLDoc.exe
build 24-Aug-2017 12:37:30 "/project:C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\tpjxfq03.ghu\project.sqldoc"
build 24-Aug-2017 12:37:30 /server:np:\\.\pipe\LOCALDB#EB27B851\tsql\query /database:dlmautomation_9dc59715-aae7-4e0a-a6a9-021b551559f9
build 24-Aug-2017 12:37:30 /out:"C:\Users\SVCBambooZ01\AppData\Local\Temp\DLM Automation\fcqy1gnv.log"
build 24-Aug-2017 12:37:44 VERBOSE: C:\Program Files (x86)\Red Gate\DLM Automation 2\SDOC\SQLDoc.exe ended with exit code 0
build 24-Aug-2017 12:37:44 VERBOSE: SQLDoc.exe completed successfully.
build 24-Aug-2017 12:37:44 Documentation created successfully.
build 24-Aug-2017 12:37:44 VERBOSE: Dropping temporary database 'dlmautomation_9dc59715-aae7-4e0a-a6a9-021b551559f9' on
build 24-Aug-2017 12:37:44 'np:\\.\pipe\LOCALDB#EB27B851\tsql\query'.
build 24-Aug-2017 12:37:47 New-DlmDatabasePackage, DLM Automation 2.0.16.453, Copyright c Red Gate Software Ltd 2014-2017
build 24-Aug-2017 12:37:47 In trial: expires 2017/09/19 12:00:54 +01:00
build 24-Aug-2017 12:37:47 VERBOSE: Parameters:
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 InputObject: RedGate.DLMAutomation.Compare.SchemaValidation.ValidatedSchemaSource
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 PackageId: DataHub01
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 PackageVersion: 1.22
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 PackageDescription: null
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 Documentation: RedGate.DLMAutomation.Compare.Documentation.SchemaDocumentation
build 24-Aug-2017 12:37:47 Export-DlmDatabasePackage, DLM Automation 2.0.16.453, Copyright c Red Gate Software Ltd 2014-2017
build 24-Aug-2017 12:37:47 In trial: expires 2017/09/19 12:00:54 +01:00
build 24-Aug-2017 12:37:47 VERBOSE: Parameters:
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 InputObject: Database Package
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 Path: .
build 24-Aug-2017 12:37:47
build 24-Aug-2017 12:37:47 Force: False
build 24-Aug-2017 12:37:48 Database package exported to file 'C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1\DataHub01.1.22.nupkg'.
simple 24-Aug-2017 12:37:50 Finished task 'DataHub Build Package' with result: Success
simple 24-Aug-2017 12:37:50 Skipping execution of task 'Sync to DB' as it is disabled
simple 24-Aug-2017 12:37:50 Running post build plugin 'NCover Results Collector'
simple 24-Aug-2017 12:37:50 Running post build plugin 'Artifact Copier'
simple 24-Aug-2017 12:37:50 Publishing an artifact: DataHub Artifact
error 24-Aug-2017 12:37:50 Unable to publish artifact [DataHub Artifact]:
simple 24-Aug-2017 12:37:50 The artifact hasn't been successfully published after 18.90 ms
simple 24-Aug-2017 12:37:50 Running post build plugin 'npm Cache Cleanup'
simple 24-Aug-2017 12:37:50 Running post build plugin 'Clover Results Collector'
simple 24-Aug-2017 12:37:50 Running post build plugin 'Docker Container Cleanup'
simple 24-Aug-2017 12:37:50 Finalising the build...
simple 24-Aug-2017 12:37:50 Stopping timer.
simple 24-Aug-2017 12:37:50 Build DH01-TDC-JOB1-22 completed.
simple 24-Aug-2017 12:37:50 Running on server: post build plugin 'NCover Results Collector'
simple 24-Aug-2017 12:37:50 Running on server: post build plugin 'Build Hanging Detection Configuration'
simple 24-Aug-2017 12:37:50 Running on server: post build plugin 'Clover Delta Calculator'
simple 24-Aug-2017 12:37:50 Running on server: post build plugin 'Maven Dependencies Postprocessor'
simple 24-Aug-2017 12:37:50 All post build plugins have finished
simple 24-Aug-2017 12:37:50 Generating build results summary...
simple 24-Aug-2017 12:37:50 Saving build results to disk...
simple 24-Aug-2017 12:37:50 Logging substituted variables...
simple 24-Aug-2017 12:37:50 Indexing build results...
simple 24-Aug-2017 12:37:50 Finished building DH01-TDC-JOB1-22.
Tagged:
Comments
It appears that you creating the package in "C:\Users\Bamboo-home\xml-data\build-dir\DH01-TDC-JOB1\DataHub01.1.22.nupkg", where would you like to publish it to?
Thank you,
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools
Can you guide me where I can set this parameter ? I am using the SQLCI component to build SQL Database projects.
If you are using the Powershell cmdlets then you would use use the -QueryBatchTimeout Parameter.
If you are using add-ons you should have a field for this in.
Please see the following document for more information:
http://documentation.red-gate.com/display/DLMA2/Timeout+expired+error
Thank you,
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools
With version 2.0.13.391 the tests were completing in 60 seconds.
With version 2.0.20.487 the log file shows the Invoke-DlmDatabaseTests step is timing out at 30 seconds.
Is there a way to set the timeout from within the Bamboo add-on?
We have updated the Bamboo plugin , now it has a field where you can set the QueryTimeout
Thank you,
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools