search

tobania / VSTS.Extension.SqlReportingServices

VSTS Extension for uploading SSRS Reports
MIT License
14 stars 20 forks source link

Deploy SQL Server Reporting files task failed. #24

Closed dvaibhav181 closed 6 years ago

dvaibhav181 commented 6 years ago

While running the release definition for deploying .rdl files on SQL server reporting services, the release is failing with below error.

2017-09-14T20:00:33.1011703Z ##[error]System.Management.Automation.ActionPreferenceStopException: The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: The remote name could not be resolved: 'azfbissp01' 2017-09-14T20:00:33.1011703Z at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input) 2017-09-14T20:00:33.1031742Z at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke) 2017-09-14T20:00:33.1031742Z at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync) 2017-09-14T20:00:33.1031742Z at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2017-09-14T20:00:33.1031742Z at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2017-09-14T20:00:33.1031742Z at Microsoft.TeamFoundation.DistributedTask.Handlers.LegacyVSTSPowerShellHost.VSTSPowerShellHost.Main(String[] args) 2017-09-14T20:00:33.1171918Z ##[error]LegacyVSTSPowerShellHost.exe completed with return code: -1.

image

image

Could you please let me know how to resolve this issue?

anton-kirschhock commented 6 years ago

Looks to me that you are using the hosted Build servers of VSTS, which cannot find your reporting service. Can you make a new PS Task and try pinging it? (ping MyReportingService)

Also take a look at the complete URL you are required to use: http(s)://[ServernameFQDN]/ReportServer/ReportService2010.asmx?wsdl without this, the script cannot access the soap service.

anton-kirschhock commented 6 years ago

@dvaibhav181 Any update or can we close this?

dvaibhav181 commented 6 years ago

You can close it.

Thanks, Vaibhav

On Tue, Sep 19, 2017 at 4:07 AM, AntonK notifications@github.com wrote:

@dvaibhav181 https://github.com/dvaibhav181 Any update or can we close this?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/tobania/VSTS.Extension.SqlReportingServices/issues/24#issuecomment-330506037, or mute the thread https://github.com/notifications/unsubscribe-auth/ARfHhwNDf5dPR9ADo8u4VGXEP9m9qZI_ks5sj6BkgaJpZM4PYMSq .