search

tobania / VSTS.Extension.SqlReportingServices

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

The operation you are attempting on item '' is not allowed for this item type. #61

Open msaxbury opened 3 years ago

msaxbury commented 3 years ago

Using the forked extension by automagically (https://marketplace.visualstudio.com/items?itemName=automagically.SqlReportingServicesDeployment&ssr=false#overview) Azure Task on a release in 2020 server. Uploading SSRS Datasets and Datasources and am getting the error in the title.

Both Datasets and Datasources files exist on the report server in the ../SIS_SelfService folder.

I only have the "Include Data Sources" check box checked on the task when uploading Datasources. I only check "Include Datasets" check box on the task when uploading Datasets.

I get the same error for both. Below is the Datasources task output.

Task output from azure: 2021-06-17T20:15:58.1233168Z ##[section]Starting: Deploy SQL Server DataSources 2021-06-17T20:15:58.1422822Z ============================================================================== 2021-06-17T20:15:58.1423193Z Task : Deploys SQL Server Reporting RDL files 2021-06-17T20:15:58.1423479Z Description : Deploys SQL Server Reporting RDL files 2021-06-17T20:15:58.1423773Z Version : 1.0.0 2021-06-17T20:15:58.1423978Z Author : automagically 2021-06-17T20:15:58.1424217Z Help : Deploys SQL Server RDL Reporting files 2021-06-17T20:15:58.1424499Z ============================================================================== 2021-06-17T20:15:58.1474804Z ##[warning]Task 'SqlReportingServicesDeployment' (1.0.0) is using deprecated task execution handler. The task should use the supported task-lib: https://aka.ms/tasklib 2021-06-17T20:15:58.1478243Z Preparing task execution handler. 2021-06-17T20:15:58.4278348Z Executing the powershell script: E:\azagent\A14_work_tasks\SqlReportingServicesDeployment_32e6a7fe-826b-412f-986f-6ef8d39fdb77\1.0.0\SqlReportingServicesDeployment.ps1 2021-06-17T20:15:58.6087551Z Preparing Deployment of RDL files... 2021-06-17T20:15:58.6087811Z 2021-06-17T20:15:58.6087897Z 2021-06-17T20:15:58.6142072Z [VERBOSE] >> Preparing script... (Verbose = true) - 2021-06-17T20:15:58.6142332Z 2021-06-17T20:15:58.6142422Z 2021-06-17T20:15:58.6158358Z [VERBOSE] >> Using following parameters: - 2021-06-17T20:15:58.6176065Z 2021-06-17T20:15:58.6198253Z 2021-06-17T20:15:58.6199413Z [VERBOSE] >> ReportFiles: E:\azagent\A14_work\r5\a\deploy\reports\SIS_SelfService\CACTUS_67.rds - 2021-06-17T20:15:58.6209342Z 2021-06-17T20:15:58.6209560Z 2021-06-17T20:15:58.6209781Z [VERBOSE] >> Upload path: /Data Sources/SIS_SelfService - 2021-06-17T20:15:58.6209948Z 2021-06-17T20:15:58.6210042Z 2021-06-17T20:15:58.6210208Z [VERBOSE] >> SetDataSource: false - 2021-06-17T20:15:58.6210387Z 2021-06-17T20:15:58.6210511Z 2021-06-17T20:15:58.6210686Z [VERBOSE] >> DataSourcePathToAssign: - 2021-06-17T20:15:58.6210844Z 2021-06-17T20:15:58.6210942Z 2021-06-17T20:15:58.6211104Z [VERBOSE] >> UpdateDataSource: true - 2021-06-17T20:15:58.6211262Z 2021-06-17T20:15:58.6211339Z 2021-06-17T20:15:58.6211501Z [VERBOSE] >> IncludeDataSource: true - 2021-06-17T20:15:58.6211659Z 2021-06-17T20:15:58.6211740Z 2021-06-17T20:15:58.6211940Z [VERBOSE] >> DataSourcePath: /Data Sources/SIS_SelfService - 2021-06-17T20:15:58.6212218Z 2021-06-17T20:15:58.6212299Z 2021-06-17T20:15:58.6212457Z [VERBOSE] >> connectionstring: - 2021-06-17T20:15:58.6212606Z 2021-06-17T20:15:58.6212687Z 2021-06-17T20:15:58.6212879Z [VERBOSE] >> IncludeDataSet: false - 2021-06-17T20:15:58.6213016Z 2021-06-17T20:15:58.6213092Z 2021-06-17T20:15:58.6213297Z [VERBOSE] >> DataSourcePath: /Data Sources/SIS_SelfService - 2021-06-17T20:15:58.6213464Z 2021-06-17T20:15:58.6213541Z 2021-06-17T20:15:58.6213720Z [VERBOSE] >> connectionstring: - 2021-06-17T20:15:58.6213852Z 2021-06-17T20:15:58.6213933Z 2021-06-17T20:15:58.6214117Z [VERBOSE] >> IncludeResources: false - 2021-06-17T20:15:58.6214300Z 2021-06-17T20:15:58.6214381Z 2021-06-17T20:15:58.6214586Z [VERBOSE] >> ResourceRootLocalPath: E:\azagent\A14_work\r5\a - 2021-06-17T20:15:58.6214752Z 2021-06-17T20:15:58.6214833Z 2021-06-17T20:15:58.6215128Z [VERBOSE] >> ResourcePatterns: ** - 2021-06-17T20:15:58.6215392Z 2021-06-17T20:15:58.6215623Z 2021-06-17T20:15:58.6221276Z [VERBOSE] >> ResourceRootPath: - 2021-06-17T20:15:58.6238156Z 2021-06-17T20:15:58.6238279Z 2021-06-17T20:15:58.6259105Z [VERBOSE] >> Webservice: http://daydevsqlrs01/ReportServer/reportservice2010.asmx - 2021-06-17T20:15:58.6259374Z 2021-06-17T20:15:58.6259481Z

2021-06-17T20:15:58.6286515Z 2021-06-17T20:15:58.6286613Z 2021-06-17T20:15:58.6379292Z Uploading files 2021-06-17T20:15:58.6453214Z Creating WebService proxy using credentials 2021-06-17T20:15:58.6479288Z 2021-06-17T20:15:58.6479545Z 2021-06-17T20:15:59.7194199Z [VERBOSE] >> Got Namespace for SSRS... - 2021-06-17T20:15:59.7194963Z 2021-06-17T20:15:59.7195181Z 2021-06-17T20:15:59.7247675Z Updating 1 datasource files to http://daydevsqlrs01/ReportServer/reportservice2010.asmx (/Data Sources/SIS_SelfService)... 2021-06-17T20:15:59.7248366Z 2021-06-17T20:15:59.7248571Z 2021-06-17T20:15:59.7320598Z Uploading datasource E:\azagent\A14_work\r5\a\deploy\reports\SIS_SelfService\CACTUS_67.rds to /Data Sources/SIS_SelfService... 2021-06-17T20:15:59.7321259Z 2021-06-17T20:15:59.7321494Z 2021-06-17T20:15:59.7339389Z [VERBOSE] >> Reading E:\azagent\A14_work\r5\a\deploy\reports\SIS_SelfService\CACTUS_67.rds file... - 2021-06-17T20:15:59.7341091Z 2021-06-17T20:15:59.7341369Z 2021-06-17T20:15:59.7764079Z 2021-06-17T20:15:59.7765495Z 2021-06-17T20:15:59.7766059Z Extension : SQL

2021-06-17T20:15:59.7767718Z UseOriginalConnectString : False 2021-06-17T20:15:59.7768265Z OriginalConnectStringExpressionBased : False 2021-06-17T20:15:59.7768764Z CredentialRetrieval : Integrated 2021-06-17T20:15:59.7769225Z WindowsCredentials : False 2021-06-17T20:15:59.7769698Z ImpersonateUser : False 2021-06-17T20:15:59.7770172Z ImpersonateUserSpecified : False 2021-06-17T20:15:59.7770718Z Prompt : 2021-06-17T20:15:59.7771179Z UserName : 2021-06-17T20:15:59.7771640Z Password : 2021-06-17T20:15:59.7772113Z Enabled : False 2021-06-17T20:15:59.7772574Z EnabledSpecified : False 2021-06-17T20:15:59.7773022Z 2021-06-17T20:15:59.7776295Z 2021-06-17T20:15:59.7776687Z 2021-06-17T20:15:59.7777024Z 2021-06-17T20:15:59.7777336Z 2021-06-17T20:15:59.7777511Z 2021-06-17T20:15:59.7777818Z [VERBOSE] >> Creating Datasource CACTUS_67 - 2021-06-17T20:15:59.7778031Z 2021-06-17T20:15:59.7778193Z 2021-06-17T20:15:59.8364977Z Done updating datasources! 2021-06-17T20:15:59.8365237Z 2021-06-17T20:15:59.8365322Z 2021-06-17T20:15:59.8365587Z [VERBOSE] >> Found 1 items in E:\azagent\A14_work\r5\a\deploy\reports\SIS_SelfService\CACTUS_67.rds - 2021-06-17T20:15:59.8365843Z 2021-06-17T20:15:59.8365928Z 2021-06-17T20:15:59.8366201Z Uploading 1 files to http://daydevsqlrs01/ReportServer/reportservice2010.asmx (/Data Sources/SIS_SelfService)... 2021-06-17T20:15:59.8366432Z 2021-06-17T20:15:59.8366517Z 2021-06-17T20:15:59.8479596Z Uploading report CACTUS_67 to /Data Sources/SIS_SelfService... 2021-06-17T20:15:59.8480389Z 2021-06-17T20:15:59.8480701Z 2021-06-17T20:15:59.8491931Z [VERBOSE] >> Uploading CACTUS_67 with filesize 508 bytes - 2021-06-17T20:15:59.8492187Z 2021-06-17T20:15:59.8492272Z 2021-06-17T20:15:59.9092872Z ##[error]Microsoft.PowerShell.Commands.WriteErrorException: The operation you are attempting on item '/Data Sources/SIS_SelfService/CACTUS_67' is not allowed for this item type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item '/Data Sources/SIS_SelfService/CACTUS_67' is not allowed for this item type. 2021-06-17T20:15:59.9392225Z ##[error]PowerShell script completed with 1 errors. 2021-06-17T20:15:59.9400106Z ##[section]Finishing: Deploy SQL Server DataSources

ygeelen-tb commented 3 years ago

Hello,

I would try creating separate folders for the datasets and datasources.

Kind regards, Y.