You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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
The text was updated successfully, but these errors were encountered:
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
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
The text was updated successfully, but these errors were encountered: