Error with SQL Server Reporting Services Deployment Tobania in TFS Release Management

[Audberto]

Hi.

I'm using your RSS tool to deploy RDL files to Report Server

The process ends with the following error: 2017-02-27T15:57:27.1113234Z ##[error]Exception calling "Substring" with "2" argument(s): "Length cannot be less than zero. 2017-02-27T15:57:27.1123345Z ##[error]Parameter name: length" 2017-02-27T15:57:27.1142067Z Uploading files 2017-02-27T15:57:27.1288262Z Creating WebService proxy using credentials 2017-02-27T15:57:27.1582595Z ##[error]The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: The HTML document does not contain Web service discovery information. I was testing with different parameters but the result is an unsuccessful deploy to RSS.

Can you help me with this error, additionally I want to know where can I find documentation about how to use this tools and what is expected to fill in each parameters. I will be gratefully for your attention and help.

Best Regards Audberto. audyjaramillo@gmail.com

[anton-kirschhock]

I've just created a patch concerning your issue. It should be tomorrow in the early morning (west-europe time) on the marketplace. Please let me know if it now does work.

Also can you verify that the webservice url is correct? (enter it in the browser and see if you do get the webservice) I think there is an issue with your used URL. (refering to the error: The HTML document does not contain Web service discovery information).

Concerting your question about documentation, we are currently working internally on the documentation. You will be finding it soon on the root of this repository.

[Audberto]

Hi.

I'm very grateful for your answer. I have tested webservice URL and it's Ok. So I'm going to wait for the patch.

Thanks a lot.

Audberto.

2017-02-27 14:30 GMT-05:00 AntonK notifications@github.com:

I've just created a patch concerning your issue. It should be tomorrow in the early morning (west-europe time) on the marketplace. Please let me know if it now does work.

Also can you verify that the webservice url is correct? (enter it in the browser and see if you do get the webservice) I think there is an issue with your used URL. (refering to the error: The HTML document does not contain Web service discovery information).

Concerting your question about documentation, we are currently working internally on the documentation. You will be finding it soon on the root of this repository.

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

[Audberto]

Hi. I hope you're having a nice day.

I have installed the new version 1.2.5. I tried to publish 2 RDL files to reportserver, but I receive the same error message.

On WebService URL I'm using: http://vsalm/Reports. I tested this url on a browser and the site load without any error. I checked out User permissions on Report server and has all Role assigned.

Then I copy the error that is registered in the process log:

2017-02-28T15:08:17.5604226Z ##[error]Exception calling "Substring" with "2" argument(s): "Length cannot be less than zero. 2017-02-28T15:08:17.5604226Z ##[error]Parameter name: length" 2017-02-28T15:08:17.5604226Z [VERBOSE] >> Correcting ResourceRootPath 2017-02-28T15:08:17.5604226Z 2017-02-28T15:08:17.5604226Z - 2017-02-28T15:08:17.5760458Z ##[error]Exception calling "Substring" with "2" argument(s): "Length cannot be less than zero. 2017-02-28T15:08:17.5760458Z ##[error]Parameter name: length" 2017-02-28T15:08:17.5760458Z Uploading files 2017-02-28T15:08:17.5760458Z Creating WebService proxy using credentials 2017-02-28T15:08:17.6077225Z ##[error]The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: The HTML document does not contain Web service discovery information.

Here you can see part of Release Management Definition: [image: Imágenes integradas 1]

[image: Imágenes integradas 2]

I appreciate very much the help that you can give me to solve this error.

Best regards.

Audberto.

2017-02-27 14:30 GMT-05:00 AntonK notifications@github.com:

I've just created a patch concerning your issue. It should be tomorrow in the early morning (west-europe time) on the marketplace. Please let me know if it now does work.

Also can you verify that the webservice url is correct? (enter it in the browser and see if you do get the webservice) I think there is an issue with your used URL. (refering to the error: The HTML document does not contain Web service discovery information).

Concerting your question about documentation, we are currently working internally on the documentation. You will be finding it soon on the root of this repository.

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

[ygeelen-tb]

The correct URL is http(s)://[ServernameFQDN]/ReportServer/ReportService2010.asmx?wsdl By the way: there are info tooltips at the right of each field with help text, did you notice?

[Audberto]

Hi. Thanks a lot for your help.

I specified the URL to Reports, as you wrote me, now the deployment process to publish RDL file is partially working.

The deployment process from Release Management ends with error, even though the RDL files were published on the report server. I'm copying images and attaching the process log.

As you can see, I'm not specifying data sources because they already exist on Report Server, but each report needs to have data sources associated. Do you know how can I do it without to specify manually?

Images of log details:

[image: Imágenes integradas 1]

[image: Imágenes integradas 2]

Thank you for your response to my inquiry. I appreciate the information you have provided me with and I appreciate the prompt reply that you have given me.

Best Regards

Audberto.

2017-02-28 10:37 GMT-05:00 AntonK notifications@github.com:

hi @Audberto https://github.com/Audberto your URL is indeed wrong. You have used the UI and not the webservice which should be located at http(s)://myhost/reportservice

Hope it works now! :)

— 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/1#issuecomment-283073010, or mute the thread https://github.com/notifications/unsubscribe-auth/AY280zyzYd0FNtB187c6P6aEDfFv00AKks5rhD8tgaJpZM4MNUKn .

2017-02-28T19:29:53.4103957Z Executing the powershell script: C:\agent\tasks\SqlReportingServicesDeployment\1.2.5\SqlReportingServicesDeployment.ps1 2017-02-28T19:29:53.6287381Z Preparing Deployment of RDL files... 2017-02-28T19:29:53.6446353Z [VERBOSE] >> Preparing script... (Verbose = true) 2017-02-28T19:29:53.6446353Z
2017-02-28T19:29:53.6446353Z - 2017-02-28T19:29:53.6446353Z [VERBOSE] >> Using following parameters: 2017-02-28T19:29:53.6446353Z
2017-02-28T19:29:53.6446353Z - 2017-02-28T19:29:53.6446353Z [VERBOSE] >> ReportFiles: c:\Tfsdata\Publicar\drop 2017-02-28T19:29:53.6446353Z
2017-02-28T19:29:53.6446353Z - 2017-02-28T19:29:53.6446353Z [VERBOSE] >> Upload path: /TfsReports/FabrikamFiberCollection/FabrikamFiber 2017-02-28T19:29:53.6446353Z
2017-02-28T19:29:53.6446353Z - 2017-02-28T19:29:53.6446353Z [VERBOSE] >> IncludeDataSource: false 2017-02-28T19:29:53.6446353Z
2017-02-28T19:29:53.6602429Z - 2017-02-28T19:29:53.6602429Z [VERBOSE] >> DataSourcePath: 2017-02-28T19:29:53.6602429Z
2017-02-28T19:29:53.6602429Z - 2017-02-28T19:29:53.6602429Z [VERBOSE] >> connectionstring: 2017-02-28T19:29:53.6602429Z
2017-02-28T19:29:53.6602429Z - 2017-02-28T19:29:53.6602429Z [VERBOSE] >> IncludeDataSet: false 2017-02-28T19:29:53.6602429Z
2017-02-28T19:29:53.6602429Z - 2017-02-28T19:29:53.6602429Z [VERBOSE] >> DataSourcePath: 2017-02-28T19:29:53.6602429Z
2017-02-28T19:29:53.6602429Z - 2017-02-28T19:29:53.6602429Z [VERBOSE] >> connectionstring: 2017-02-28T19:29:53.6602429Z
2017-02-28T19:29:53.6602429Z - 2017-02-28T19:29:53.6602429Z [VERBOSE] >> IncludeResources: false 2017-02-28T19:29:53.6602429Z
2017-02-28T19:29:53.6602429Z - 2017-02-28T19:29:53.6602429Z [VERBOSE] >> ResourceRootLocalPath: C:\agent_work\07a7896fa 2017-02-28T19:29:53.6602429Z
2017-02-28T19:29:53.6602429Z - 2017-02-28T19:29:53.6602429Z [VERBOSE] >> ResourcePatterns: 2017-02-28T19:29:53.6602429Z
2017-02-28T19:29:53.6602429Z - 2017-02-28T19:29:53.6602429Z [VERBOSE] >> ResourceRootPath: 2017-02-28T19:29:53.6602429Z
2017-02-28T19:29:53.6602429Z - 2017-02-28T19:29:53.6761280Z [VERBOSE] >> Webservice: http://vsalm/Reportserver/Reportservice2010.asmx?wsdl 2017-02-28T19:29:53.6761280Z
2017-02-28T19:29:53.6761280Z - 2017-02-28T19:29:53.6761280Z [VERBOSE] >> WsUsername: Administrator 2017-02-28T19:29:53.6761280Z
2017-02-28T19:29:53.6761280Z - 2017-02-28T19:29:53.6909304Z [VERBOSE] >> WsPassword: ** 2017-02-28T19:29:53.6909304Z
2017-02-28T19:29:53.6909304Z - 2017-02-28T19:29:53.6909304Z [VERBOSE] >> Correcting DataSetRootPath 2017-02-28T19:29:53.6909304Z
2017-02-28T19:29:53.6909304Z - 2017-02-28T19:29:53.7069408Z ##[error]Exception calling "Substring" with "2" argument(s): "Length cannot be less than zero. 2017-02-28T19:29:53.7069408Z ##[error]Parameter name: length" 2017-02-28T19:29:53.7069408Z [VERBOSE] >> Correcting ResourceRootPath 2017-02-28T19:29:53.7069408Z
2017-02-28T19:29:53.7069408Z - 2017-02-28T19:29:53.7224596Z ##[error]Exception calling "Substring" with "2" argument(s): "Length cannot be less than zero. 2017-02-28T19:29:53.7224596Z ##[error]Parameter name: length" 2017-02-28T19:29:53.7224596Z Uploading files 2017-02-28T19:29:53.7224596Z Creating WebService proxy using credentials 2017-02-28T19:29:54.9877987Z [VERBOSE] >> Found 2 items in c:\Tfsdata\Publicar\drop 2017-02-28T19:29:54.9877987Z
2017-02-28T19:29:54.9877987Z - 2017-02-28T19:29:54.9877987Z Uploading 2 files to http://vsalm/Reportserver/Reportservice2010.asmx?wsdl (/TfsReports/FabrikamFiberCollection/FabrikamFiber)... 2017-02-28T19:29:55.1442737Z Uploading report Demo Backlog Overview to /TfsReports/FabrikamFiberCollection/FabrikamFiber... 2017-02-28T19:29:55.1442737Z [VERBOSE] >> Uploading Demo Backlog Overview with filesize bytes 2017-02-28T19:29:55.1442737Z
2017-02-28T19:29:55.1442737Z - 2017-02-28T19:30:00.7540574Z ##[warning]One or more warnings occured during upload: 2017-02-28T19:30:00.7696197Z - {The dataset ‘TfsReportDS’ refers to the shared data source ‘TfsReportDS’, which is not published on the report server. The shared data source ‘TfsReportDS’ must be published before this report can run.} 2017-02-28T19:30:00.7849740Z ##[warning] - {The dataset ‘TfsReportDS’ refers to the shared data source ‘TfsReportDS’, which is not published on the report server. The shared data source ‘TfsReportDS’ must be published before this report can run.} 2017-02-28T19:30:00.8009649Z Uploading report Demo Sprint Burndown to /TfsReports/FabrikamFiberCollection/FabrikamFiber... 2017-02-28T19:30:00.8009649Z [VERBOSE] >> Uploading Demo Sprint Burndown with filesize bytes 2017-02-28T19:30:00.8009649Z
2017-02-28T19:30:00.8009649Z - 2017-02-28T19:30:01.2224838Z ##[warning]One or more warnings occured during upload: 2017-02-28T19:30:01.2224838Z - {The dataset ‘TfsOlapReportDS’ refers to the shared data source ‘TfsOlapReportDS’, which is not published on the report server. The shared data source ‘TfsOlapReportDS’ must be published before this report can run.} 2017-02-28T19:30:01.2224838Z - {The dataset ‘TfsOlapReportDS’ refers to the shared data source ‘TfsOlapReportDS’, which is not published on the report server. The shared data source ‘TfsOlapReportDS’ must be published before this report can run.} 2017-02-28T19:30:01.2224838Z - {The dataset ‘TfsReportDS’ refers to the shared data source ‘TfsReportDS’, which is not published on the report server. The shared data source ‘TfsReportDS’ must be published before this report can run.} 2017-02-28T19:30:01.2224838Z ##[warning] - {The dataset ‘TfsOlapReportDS’ refers to the shared data source ‘TfsOlapReportDS’, which is not published on the report server. The shared data source ‘TfsOlapReportDS’ must be published before this report can run.} 2017-02-28T19:30:01.2224838Z ##[warning] - {The dataset ‘TfsReportDS’ refers to the shared data source ‘TfsReportDS’, which is not published on the report server. The shared data source ‘TfsReportDS’ must be published before this report can run.} 2017-02-28T19:30:01.2224838Z Done uploading 2 files! 2017-02-28T19:30:01.2224838Z Deployment of RDL files completed

[anton-kirschhock]

You can use the tool to upload the datasource aswel. You could upload it one time manual, change the connectionstring and I assume it should work. We were trying updating the datasource aswel in the task but it gave allot of issues concerning the datasource.

I hope this helps you! If not let me know :)

[Audberto]

Hi. Thanks for your answer. According to the results that I described you in the previous email, do you know why the deployment process from Release Management ends with error?

On the other hand, I´m going to investigate how to download Datasource and Dataset definition in order to upload them thru your tool. I'll write you the results..

Note: Do you have on hand a documentation that help me to download that artifacts?

Best Regards

Audberto.

2017-02-28 15:37 GMT-05:00 AntonK notifications@github.com:

You can use the tool to upload the datasource aswel. You could upload it one time manual, change the connectionstring and I assume it should work. We were trying updating the datasource aswel in the task but it gave allot of issues concerning the datasource.

I hope this helps you! If not let me know :)

— 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/1#issuecomment-283153456, or mute the thread https://github.com/notifications/unsubscribe-auth/AY280906MzBQT-Ll8gcorlvCEgHzguhMks5rhIVwgaJpZM4MNUKn .

[anton-kirschhock]

Artifacts can be downloaded via the build tab of your project, click on the finished build you want to download and under the green Build succeeded bar, you see Summary, Timeline followed by Artifacts. There you can download the files.

I hope this helps you!

[Audberto]

Hi, thanks again for your attention and help

According to what you mention, I understand that when I upload Reports files (.rdl) and it's respective datasource (Through your tool), after a deploy, I don't have to specify manually the corresponding datasource to the reports. Is that correct?

On the finished Build I couldn't find any datasource, because only .rdl files are under source control. Can you referenced me how to download Dataset and datasources. Thanks a lot

Best Regards

Audberto

2017-03-01 2:21 GMT-05:00 AntonK notifications@github.com:

Artifacts can be downloaded via the build tab of your project, click on the finished build you want to download and under the green Build succeeded bar, you see Summary, Timeline followed by Artifacts. There you can download the files.

I hope this helps you!

— 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/1#issuecomment-283264675, or mute the thread https://github.com/notifications/unsubscribe-auth/AY28094TIHhR8uCU8PGcBptWZ80il3Vhks5rhRyEgaJpZM4MNUKn .

[Audberto]

Hi again. I hope you're enjoying this day.

Now I have the RDS file that correspond to a datasource. When I try to upload it with twoo rdl files, Release Management ends with the following error. Also, I am copying images with the Release defitintion using your tool.

Please, Can you tell me what is causing that error? Do you notice something wrong in the Release Definition?

2017-03-02T19:28:49.9785083Z ##[error]Exception calling "Substring" with "2" argument(s): "Length cannot be less than zero.

2017-03-02T19:28:49.9785083Z ##[error]Parameter name: length"

2017-03-02T19:28:51.3845343Z ##[error]Exception calling "CreateDataSource" with "5" argument(s): "System.Web.Services.Protocols.SoapException: The name of the item '' is not valid. The name must be less than 260 characters long. The name must not start with a slash character or contain a reserved character. Other restrictions apply. For more information on valid item names, see http://go.microsoft.com/fwlink/?LinkId=248859. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemNameException: The name of the item '' is not valid. The name must be less than 260 characters long. The name must not start with a slash character or contain a reserved character. Other restrictions apply. For more information on valid item names, see http://go.microsoft.com/fwlink/?LinkId=248859.

2017-03-02T19:28:51.3845343Z ##[error] at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties, String ParameterName, CatalogItem& ItemInfo)

2017-03-02T19:28:51.3845343Z ##[error] at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties, CatalogItem& ItemInfo)"

[image: Imágenes integradas 1]

[image: Imágenes integradas 2]

Note: I have tried too to leaving the Connectionstring parameter in blank. But the same error occurs.

Thank you very much and sorry for all the inconvenience

Best regards

Audberto.

2017-03-02 11:32 GMT-05:00 Audberto Jaramillo audyjaramillo@gmail.com:

Hi, thanks again for your attention and help

According to what you mention, I understand that when I upload Reports files (.rdl) and it's respective datasource (Through your tool), after a deploy, I don't have to specify manually the corresponding datasource to the reports. Is that correct?

On the finished Build I couldn't find any datasource, because only .rdl files are under source control. Can you referenced me how to download Dataset and datasources. Thanks a lot

Best Regards

Audberto

2017-03-01 2:21 GMT-05:00 AntonK notifications@github.com:

Artifacts can be downloaded via the build tab of your project, click on the finished build you want to download and under the green Build succeeded bar, you see Summary, Timeline followed by Artifacts. There you can download the files.

I hope this helps you!

— 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/1#issuecomment-283264675, or mute the thread https://github.com/notifications/unsubscribe-auth/AY28094TIHhR8uCU8PGcBptWZ80il3Vhks5rhRyEgaJpZM4MNUKn .

[anton-kirschhock]

Can you show a picture of the release definition?

[anton-kirschhock]

ok I fixed the issue with the substring. We had an internal project which had the same issue with the substring. Concerning your other issues, I still await your reply. I have a feeling something is wrong with the config of the tool.

[Audberto]

Hi.

I'm sending you again images of the release definition and I'm attaching too the LOG file.

[image: Imágenes integradas 1]

[image: Imágenes integradas 2]

Thanks a lot for your attention and colaboration.

Best Regards.

Audberto.

2017-03-03 4:05 GMT-05:00 AntonK notifications@github.com:

ok I fixed the issue with the substring. We had an internal project which had the same issue with the substring. Concerning your other issues, I still await your reply. I have a feeling something is wrong with the config of the tool.

— 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/1#issuecomment-283902563, or mute the thread https://github.com/notifications/unsubscribe-auth/AY280zrr05qgWwdEAivBuZnCjDjtj3YAks5rh9f2gaJpZM4MNUKn .

2017-03-02T19:47:50.0412329Z Executing the powershell script: C:\agent\tasks\SqlReportingServicesDeployment\1.2.5\SqlReportingServicesDeployment.ps1 2017-03-02T19:47:50.2600326Z Preparing Deployment of RDL files... 2017-03-02T19:47:50.2912910Z [VERBOSE] >> Preparing script... (Verbose = true) 2017-03-02T19:47:50.2912910Z
2017-03-02T19:47:50.2912910Z - 2017-03-02T19:47:50.2912910Z [VERBOSE] >> Using following parameters: 2017-03-02T19:47:50.2912910Z
2017-03-02T19:47:50.2912910Z - 2017-03-02T19:47:50.2912910Z [VERBOSE] >> ReportFiles: c:\Tfsdata\Publicar\drop 2017-03-02T19:47:50.2912910Z
2017-03-02T19:47:50.2912910Z - 2017-03-02T19:47:50.3068331Z [VERBOSE] >> Upload path: /TfsReports/FabrikamFiberCollection/FabrikamFiber 2017-03-02T19:47:50.3068331Z
2017-03-02T19:47:50.3068331Z - 2017-03-02T19:47:50.3068331Z [VERBOSE] >> IncludeDataSource: true 2017-03-02T19:47:50.3068331Z
2017-03-02T19:47:50.3068331Z - 2017-03-02T19:47:50.3068331Z [VERBOSE] >> DataSourcePath: 2017-03-02T19:47:50.3068331Z
2017-03-02T19:47:50.3068331Z - 2017-03-02T19:47:50.3068331Z [VERBOSE] >> connectionstring: Data Source=VSALM;Initial Catalog=Tfs_Warehouse 2017-03-02T19:47:50.3068331Z
2017-03-02T19:47:50.3068331Z - 2017-03-02T19:47:50.3068331Z [VERBOSE] >> IncludeDataSet: false 2017-03-02T19:47:50.3068331Z
2017-03-02T19:47:50.3068331Z - 2017-03-02T19:47:50.3068331Z [VERBOSE] >> DataSourcePath: 2017-03-02T19:47:50.3068331Z
2017-03-02T19:47:50.3068331Z - 2017-03-02T19:47:50.3068331Z [VERBOSE] >> connectionstring: Data Source=VSALM;Initial Catalog=Tfs_Warehouse 2017-03-02T19:47:50.3068331Z
2017-03-02T19:47:50.3068331Z - 2017-03-02T19:47:50.3068331Z [VERBOSE] >> IncludeResources: false 2017-03-02T19:47:50.3068331Z
2017-03-02T19:47:50.3068331Z - 2017-03-02T19:47:50.3068331Z [VERBOSE] >> ResourceRootLocalPath: C:\agent_work\07a7896fa 2017-03-02T19:47:50.3068331Z
2017-03-02T19:47:50.3068331Z - 2017-03-02T19:47:50.3068331Z [VERBOSE] >> ResourcePatterns: 2017-03-02T19:47:50.3223664Z
2017-03-02T19:47:50.3223664Z - 2017-03-02T19:47:50.3223664Z [VERBOSE] >> ResourceRootPath: 2017-03-02T19:47:50.3223664Z
2017-03-02T19:47:50.3223664Z - 2017-03-02T19:47:50.3223664Z [VERBOSE] >> Webservice: http://vsalm/Reportserver/Reportservice2010.asmx?wsdl 2017-03-02T19:47:50.3223664Z
2017-03-02T19:47:50.3223664Z - 2017-03-02T19:47:50.3223664Z [VERBOSE] >> WsUsername: Adam 2017-03-02T19:47:50.3223664Z
2017-03-02T19:47:50.3223664Z - 2017-03-02T19:47:50.3223664Z [VERBOSE] >> WsPassword: ** 2017-03-02T19:47:50.3223664Z
2017-03-02T19:47:50.3223664Z - 2017-03-02T19:47:50.3380229Z [VERBOSE] >> Correcting DataSetRootPath 2017-03-02T19:47:50.3380229Z
2017-03-02T19:47:50.3380229Z - 2017-03-02T19:47:50.3536769Z ##[error]Exception calling "Substring" with "2" argument(s): "Length cannot be less than zero. 2017-03-02T19:47:50.3536769Z ##[error]Parameter name: length" 2017-03-02T19:47:50.3536769Z [VERBOSE] >> Correcting ResourceRootPath 2017-03-02T19:47:50.3536769Z
2017-03-02T19:47:50.3536769Z - 2017-03-02T19:47:50.3536769Z ##[error]Exception calling "Substring" with "2" argument(s): "Length cannot be less than zero. 2017-03-02T19:47:50.3536769Z ##[error]Parameter name: length" 2017-03-02T19:47:50.3536769Z Uploading files 2017-03-02T19:47:50.3696582Z Creating WebService proxy using credentials 2017-03-02T19:47:51.5876216Z Updating 4 datasource files to http://vsalm/Reportserver/Reportservice2010.asmx?wsdl (/TfsReports/FabrikamFiberCollection/FabrikamFiber)... 2017-03-02T19:47:51.5876216Z Uploading datasource C:\Tfsdata\Publicar\drop\Demo Backlog Overview.rdl to /Home... 2017-03-02T19:47:51.5876216Z [VERBOSE] >> Reading C:\Tfsdata\Publicar\drop\Demo Backlog Overview.rdl file... 2017-03-02T19:47:51.5876216Z
2017-03-02T19:47:51.5876216Z - 2017-03-02T19:47:51.7283995Z Extension : 2017-03-02T19:47:51.7283995Z ConnectString : Data Source=VSALM;Initial 2017-03-02T19:47:51.7283995Z Catalog=Tfs_Warehouse 2017-03-02T19:47:51.7283995Z UseOriginalConnectString : False 2017-03-02T19:47:51.7283995Z OriginalConnectStringExpressionBased : False 2017-03-02T19:47:51.7283995Z CredentialRetrieval : Prompt 2017-03-02T19:47:51.7283995Z WindowsCredentials : False 2017-03-02T19:47:51.7283995Z ImpersonateUser : False 2017-03-02T19:47:51.7283995Z ImpersonateUserSpecified : False 2017-03-02T19:47:51.7283995Z Prompt : 2017-03-02T19:47:51.7283995Z UserName : 2017-03-02T19:47:51.7283995Z Password : 2017-03-02T19:47:51.7283995Z Enabled : False 2017-03-02T19:47:51.7283995Z EnabledSpecified : False 2017-03-02T19:47:51.7443968Z [VERBOSE] >> Creating Datasource 2017-03-02T19:47:51.7443968Z
2017-03-02T19:47:51.7443968Z - 2017-03-02T19:47:51.7754340Z ##[error]Exception calling "CreateDataSource" with "5" argument(s): "System.Web.Services.Protocols.SoapException: The name of the item '' is not valid. The name must be less than 260 characters long. The name must not start with a slash character or contain a reserved character. Other restrictions apply. For more information on valid item names, see http://go.microsoft.com/fwlink/?LinkId=248859. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemNameException: The name of the item '' is not valid. The name must be less than 260 characters long. The name must not start with a slash character or contain a reserved character. Other restrictions apply. For more information on valid item names, see http://go.microsoft.com/fwlink/?LinkId=248859. 2017-03-02T19:47:51.7754340Z ##[error] at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties, String ParameterName, CatalogItem& ItemInfo) 2017-03-02T19:47:51.7754340Z ##[error] at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties, CatalogItem& ItemInfo)" 2017-03-02T19:47:51.7754340Z Uploading datasource C:\Tfsdata\Publicar\drop\Demo Sprint Burndown.rdl to /Home... 2017-03-02T19:47:51.7754340Z [VERBOSE] >> Reading C:\Tfsdata\Publicar\drop\Demo Sprint Burndown.rdl file... 2017-03-02T19:47:51.7754340Z
2017-03-02T19:47:51.7754340Z - 2017-03-02T19:47:51.8224519Z Extension : 2017-03-02T19:47:51.8381703Z ConnectString : Data Source=VSALM;Initial 2017-03-02T19:47:51.8381703Z Catalog=Tfs_Warehouse 2017-03-02T19:47:51.8381703Z UseOriginalConnectString : False 2017-03-02T19:47:51.8381703Z OriginalConnectStringExpressionBased : False 2017-03-02T19:47:51.8381703Z CredentialRetrieval : Prompt 2017-03-02T19:47:51.8381703Z WindowsCredentials : False 2017-03-02T19:47:51.8381703Z ImpersonateUser : False 2017-03-02T19:47:51.8381703Z ImpersonateUserSpecified : False 2017-03-02T19:47:51.8381703Z Prompt : 2017-03-02T19:47:51.8381703Z UserName : 2017-03-02T19:47:51.8381703Z Password : 2017-03-02T19:47:51.8381703Z Enabled : False 2017-03-02T19:47:51.8381703Z EnabledSpecified : False 2017-03-02T19:47:51.8381703Z [VERBOSE] >> Creating Datasource 2017-03-02T19:47:51.8381703Z
2017-03-02T19:47:51.8381703Z - 2017-03-02T19:47:51.8532527Z ##[error]Exception calling "CreateDataSource" with "5" argument(s): "System.Web.Services.Protocols.SoapException: The name of the item '' is not valid. The name must be less than 260 characters long. The name must not start with a slash character or contain a reserved character. Other restrictions apply. For more information on valid item names, see http://go.microsoft.com/fwlink/?LinkId=248859. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemNameException: The name of the item '' is not valid. The name must be less than 260 characters long. The name must not start with a slash character or contain a reserved character. Other restrictions apply. For more information on valid item names, see http://go.microsoft.com/fwlink/?LinkId=248859. 2017-03-02T19:47:51.8532527Z ##[error] at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties, String ParameterName, CatalogItem& ItemInfo) 2017-03-02T19:47:51.8532527Z ##[error] at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties, CatalogItem& ItemInfo)" 2017-03-02T19:47:51.8532527Z Uploading datasource C:\Tfsdata\Publicar\drop\NTfs2010OlapReportDS.rds to /Home... 2017-03-02T19:47:51.8532527Z [VERBOSE] >> Reading C:\Tfsdata\Publicar\drop\NTfs2010OlapReportDS.rds file... 2017-03-02T19:47:51.8532527Z
2017-03-02T19:47:51.8532527Z - 2017-03-02T19:47:51.8532527Z Extension : 2017-03-02T19:47:51.8532527Z ConnectString : Data Source=VSALM;Initial 2017-03-02T19:47:51.8532527Z Catalog=Tfs_Warehouse 2017-03-02T19:47:51.8532527Z UseOriginalConnectString : False 2017-03-02T19:47:51.8532527Z OriginalConnectStringExpressionBased : False 2017-03-02T19:47:51.8532527Z CredentialRetrieval : Prompt 2017-03-02T19:47:51.8532527Z WindowsCredentials : False 2017-03-02T19:47:51.8532527Z ImpersonateUser : False 2017-03-02T19:47:51.8532527Z ImpersonateUserSpecified : False 2017-03-02T19:47:51.8689764Z Prompt : 2017-03-02T19:47:51.8689764Z UserName : 2017-03-02T19:47:51.8689764Z Password : 2017-03-02T19:47:51.8689764Z Enabled : False 2017-03-02T19:47:51.8689764Z EnabledSpecified : False 2017-03-02T19:47:51.8689764Z [VERBOSE] >> Creating Datasource 2017-03-02T19:47:51.8689764Z
2017-03-02T19:47:51.8689764Z - 2017-03-02T19:47:51.8689764Z ##[error]Exception calling "CreateDataSource" with "5" argument(s): "System.Web.Services.Protocols.SoapException: The name of the item '' is not valid. The name must be less than 260 characters long. The name must not start with a slash character or contain a reserved character. Other restrictions apply. For more information on valid item names, see http://go.microsoft.com/fwlink/?LinkId=248859. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemNameException: The name of the item '' is not valid. The name must be less than 260 characters long. The name must not start with a slash character or contain a reserved character. Other restrictions apply. For more information on valid item names, see http://go.microsoft.com/fwlink/?LinkId=248859. 2017-03-02T19:47:51.8689764Z ##[error] at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties, String ParameterName, CatalogItem& ItemInfo) 2017-03-02T19:47:51.8689764Z ##[error] at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties, CatalogItem& ItemInfo)" 2017-03-02T19:47:51.8689764Z Uploading datasource C:\Tfsdata\Publicar\drop\NTfs2010ReportDS.rds to /Home... 2017-03-02T19:47:51.8689764Z [VERBOSE] >> Reading C:\Tfsdata\Publicar\drop\NTfs2010ReportDS.rds file... 2017-03-02T19:47:51.8689764Z
2017-03-02T19:47:51.8689764Z - 2017-03-02T19:47:51.8849818Z Extension : 2017-03-02T19:47:51.8849818Z ConnectString : Data Source=VSALM;Initial 2017-03-02T19:47:51.8849818Z Catalog=Tfs_Warehouse 2017-03-02T19:47:51.8849818Z UseOriginalConnectString : False 2017-03-02T19:47:51.8849818Z OriginalConnectStringExpressionBased : False 2017-03-02T19:47:51.8849818Z CredentialRetrieval : Prompt 2017-03-02T19:47:51.8849818Z WindowsCredentials : False 2017-03-02T19:47:51.8849818Z ImpersonateUser : False 2017-03-02T19:47:51.8849818Z ImpersonateUserSpecified : False 2017-03-02T19:47:51.8849818Z Prompt : 2017-03-02T19:47:51.8849818Z UserName : 2017-03-02T19:47:51.8849818Z Password : 2017-03-02T19:47:51.8849818Z Enabled : False 2017-03-02T19:47:51.8849818Z EnabledSpecified : False 2017-03-02T19:47:51.8849818Z [VERBOSE] >> Creating Datasource 2017-03-02T19:47:51.8849818Z
2017-03-02T19:47:51.8849818Z - 2017-03-02T19:47:51.9010163Z ##[error]Exception calling "CreateDataSource" with "5" argument(s): "System.Web.Services.Protocols.SoapException: The name of the item '' is not valid. The name must be less than 260 characters long. The name must not start with a slash character or contain a reserved character. Other restrictions apply. For more information on valid item names, see http://go.microsoft.com/fwlink/?LinkId=248859. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemNameException: The name of the item '' is not valid. The name must be less than 260 characters long. The name must not start with a slash character or contain a reserved character. Other restrictions apply. For more information on valid item names, see http://go.microsoft.com/fwlink/?LinkId=248859. 2017-03-02T19:47:51.9010163Z ##[error] at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties, String ParameterName, CatalogItem& ItemInfo) 2017-03-02T19:47:51.9010163Z ##[error] at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateDataSource(String DataSource, String Parent, Boolean Overwrite, DataSourceDefinition Definition, Property[] Properties, CatalogItem& ItemInfo)" 2017-03-02T19:47:51.9010163Z Done updating datasources! 2017-03-02T19:47:51.9010163Z [VERBOSE] >> Found 4 items in c:\Tfsdata\Publicar\drop 2017-03-02T19:47:51.9010163Z
2017-03-02T19:47:51.9010163Z - 2017-03-02T19:47:51.9010163Z Uploading 4 files to http://vsalm/Reportserver/Reportservice2010.asmx?wsdl (/TfsReports/FabrikamFiberCollection/FabrikamFiber)... 2017-03-02T19:47:51.9626285Z Uploading report Demo Backlog Overview to /TfsReports/FabrikamFiberCollection/FabrikamFiber... 2017-03-02T19:47:51.9626285Z [VERBOSE] >> Uploading Demo Backlog Overview with filesize bytes 2017-03-02T19:47:51.9626285Z
2017-03-02T19:47:51.9626285Z - 2017-03-02T19:47:52.4806068Z ##[warning]One or more warnings occured during upload: 2017-03-02T19:47:52.4950476Z - {The dataset ‘TfsReportDS’ refers to the shared data source ‘TfsReportDS’, which is not published on the report server. The shared data source ‘TfsReportDS’ must be published before this report can run.} 2017-03-02T19:47:52.4950476Z ##[warning] - {The dataset ‘TfsReportDS’ refers to the shared data source ‘TfsReportDS’, which is not published on the report server. The shared data source ‘TfsReportDS’ must be published before this report can run.} 2017-03-02T19:47:52.5095004Z Uploading report Demo Sprint Burndown to /TfsReports/FabrikamFiberCollection/FabrikamFiber... 2017-03-02T19:47:52.5095004Z [VERBOSE] >> Uploading Demo Sprint Burndown with filesize bytes 2017-03-02T19:47:52.5095004Z
2017-03-02T19:47:52.5095004Z - 2017-03-02T19:47:52.7948426Z ##[warning]One or more warnings occured during upload: 2017-03-02T19:47:52.7948426Z - {The dataset ‘TfsOlapReportDS’ refers to the shared data source ‘TfsOlapReportDS’, which is not published on the report server. The shared data source ‘TfsOlapReportDS’ must be published before this report can run.} 2017-03-02T19:47:52.7948426Z - {The dataset ‘TfsOlapReportDS’ refers to the shared data source ‘TfsOlapReportDS’, which is not published on the report server. The shared data source ‘TfsOlapReportDS’ must be published before this report can run.} 2017-03-02T19:47:52.7948426Z - {The dataset ‘TfsReportDS’ refers to the shared data source ‘TfsReportDS’, which is not published on the report server. The shared data source ‘TfsReportDS’ must be published before this report can run.} 2017-03-02T19:47:52.7948426Z ##[warning] - {The dataset ‘TfsOlapReportDS’ refers to the shared data source ‘TfsOlapReportDS’, which is not published on the report server. The shared data source ‘TfsOlapReportDS’ must be published before this report can run.} 2017-03-02T19:47:52.7987557Z ##[warning] - {The dataset ‘TfsReportDS’ refers to the shared data source ‘TfsReportDS’, which is not published on the report server. The shared data source ‘TfsReportDS’ must be published before this report can run.} 2017-03-02T19:47:52.7987557Z Uploading report NTfs2010OlapReportDS to /TfsReports/FabrikamFiberCollection/FabrikamFiber... 2017-03-02T19:47:52.8027567Z [VERBOSE] >> Uploading NTfs2010OlapReportDS with filesize bytes 2017-03-02T19:47:52.8027567Z
2017-03-02T19:47:52.8027567Z - 2017-03-02T19:47:52.8379909Z ##[error]System.Web.Services.Protocols.SoapException: The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2006/03/reportdatasource' which cannot be upgraded. 2017-03-02T19:47:52.8379909Z ##[error] at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, ItemType ItemType, CatalogItem& ItemInfo, Warning[]& Warnings) 2017-03-02T19:47:52.8379909Z ##[error] at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings) 2017-03-02T19:47:52.8419203Z ##[error] at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings)

[anton-kirschhock]

@Audberto I cannot see the images except from the markdown describing the images. Can you upload to a image service and share the URL?

thanks

[Audberto]

Hi. Anton. Is that your name?

I'm attaching a PDF file. I hope you can open it. If not, let me know please.

Thanks a lot

Audberto.

2017-03-03 10:36 GMT-05:00 AntonK notifications@github.com:

@Audberto https://github.com/Audberto I cannot see the images except from the markdown describing the images. Can you upload to a image service and share the URL?

thanks

— 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/1#issuecomment-283985949, or mute the thread https://github.com/notifications/unsubscribe-auth/AY2807oDVBOn17OXBjCrVGppAua6W74Yks5riDNxgaJpZM4MNUKn .

[anton-kirschhock]

Hi there, Sorry I cannot see the PDF neither. You will have to use Githubs interface to do this instead of replying to the email. => https://github.com/tobania/VSTS.Extension.SqlReportingServices/issues/1