Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
msaxbury opened this issue Jun 18, 2021 · 1 comment

Comments

@msaxbury
Copy link

msaxbury commented Jun 18, 2021

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

@msaxbury msaxbury changed the title The operation you are attempting on item '/Data Sources/SIS_SelfService/CACTUS_67' is not allowed for this item type. The operation you are attempting on item '' is not allowed for this item type. Jun 18, 2021
@ygeelen-tb
Copy link
Collaborator

Hello,

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

Kind regards,
Y.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants