search

microsoft / sql-server-samples

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge
Other
9.94k stars 8.85k forks source link

Re-linking data source problem #820

Open mst42a opened 4 years ago

mst42a commented 4 years ago

I have used scripts like that (Migrated from SSRS2016 tp SSRS2019:

$SourceServer = "http://OldServer/ReportServer" $TargetServer = "http://NewServer/ReportServer" $SourceFolder = "/Prototypes/MS" $TargetFolder = $SourceFolder

rs.exe -i "C:\RSS\ssrs_migration.rss" -e Mgmt2010 -s $SourceServer -v f=$SourceFolder -v ts=$TargetServer -v tf=$TargetFolder

I get message error:

Re-linking data source for item Payment report ... SUCCESS Re-linking references for item Payment report ... FAILURE: The item '/Prototypes/MSFinance/SQL_PEPCO_Connector_DAX' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/Prototypes/MSFinance/SQL_PEPC O_Connector_DAX' cannot be found.

Migrating parameters for report Payment liabilities report ... SUCCESS Migrating subscriptions for report Payment liabilities report: 2 items found. Migrating subscription sub2_disable ... FAILURE: The report server cannot process the report or shared dataset. The shared data source 'SQL_PEPCO_Connector_DAX' for the report server is not valid.

The problem Is that my report is in path /Prototypes/MS but my DataSource is in Finance/SQL_PEPCO_Connector_DAX

and script generate wrong path to the DataSource '/Prototypes/MSFinance/SQL_PEPCO_Connector_DAX'

image

psrish commented 10 months ago

Did you find the solution for this?