SCSM reports do not work after deletion of encrypted content from SSRS

Question

I was needed to delete encrypted content from SSRS.
Now SCSM reports do not work. I'm getting error

An error has occurred during report processing. (rsProcessingAborted)
Cannot set the command type for dataset 'LT_Report'. (rsErrorSettingCommandType)
Specified method is not supported.

From SCSM console when running report

I reconfigured connection strings for all data sources and reentered login details like below

I don't know exact data source configuration needed

is there any way to redeploy reports?

Answer 1

What do you mean with "delete encrypted content from SSRS"?
What is deleted exactly?

There are different recovery scenarios described here:
https://learn.microsoft.com/en-us/system-center/scsm/disaster-recovery?view=sc-sm-2019

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 2

Hi @Vladislav Komissarov ，
What is the "deletion of encrypted content"?
Could you share the dataset query for 'LT_Report'? From the error message the issue was located in this dataset.
You could also share the SSRS trace log with this error.
Regards，
Joy

Answer 3

Hi

I am configuring SCSM report on SQL SSRS server. For the multimart Data Source I selected Microsoft Analysis Services - as data source type and connection string given as below :

<root><source id='DWDataMart' connectionString='Data Source=db;Initial Catalog=DWDataMart;Integrated Security=True' /><source id='OMDataMart' connectionString='Data Source=db;Initial Catalog=OMDWDataMart;Integrated Security=True' /><source id='CMDataMart' connectionString='Data Source=db;Initial Catalog=CMDWDataMart;Integrated Security=True' /></root>

But get this error when testing connection : A semicolon was expected at index 30 in the connection string.

Also see attached screen shot. Any clues to help me? thanks