question

VladislavKomissarov-3258 avatar image
0 Votes"
VladislavKomissarov-3258 asked GeoCamp-8756 published

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

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

40391-1.png

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

40326-2.png


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

40275-3.png


I don't know exact data source configuration needed

is there any way to redeploy reports?


sql-server-reporting-servicesmsc-service-manager
1.png (43.5 KiB)
2.png (199.5 KiB)
3.png (200.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AndreasBaumgarten avatar image
0 Votes"
AndreasBaumgarten answered AndreasBaumgarten edited

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

There are different recovery scenarios described here:
https://docs.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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @VladislavKomissarov-3258
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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GeoCamp-8756 avatar image
0 Votes"
GeoCamp-8756 answered GeoCamp-8756 published



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
121723-image.png



image.png (47.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.