question

BanswaniSnehaHHSCContractor-6009 avatar image
0 Votes"
BanswaniSnehaHHSCContractor-6009 asked Joyzhao-MSFT edited

Cannot Create Data driven subscriptions for SSRS report

Hi,
I get the following error while trying to create the data driven subscriptions:

"Data-driven subscription cannot be created because the report or shared dataset has user profile dependencies and cannot be run unattended. "

  1. I have set the data source to use stored credentials.

  2. I have also tried hiding any "ID" related parameters

  3. It is not a linked report

Any Suggestions?

Regards,
Sneha








sql-server-reporting-services
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.

1 Answer

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

Hi @BanswaniSnehaHHSCContractor-6009 ,

I have also tried hiding any "ID" related parameters

Did you mean that a hidden parameter containing userdID has been created. Use the default value output by the custom code function (Code.UserName()) to declare the parameter, and use this parameter to replace User!UserID in the report.
Have you checked this link? User profile dependencies problem in report scheduling.

The error may also be caused by SSRS trying to connect to an SMTP server without SSL, but the server needs to be configured with SSL. Setting UseSSL to False can help solve the sending problem.
The default path of rsreportserver.config is: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer
Refer to the following in the rsreportserver.config file:

 <UI>
     <ReportServerUrl></ReportServerUrl>
     <PageCountMode>Estimate</PageCountMode>
     <CustomAuthenticationUI>
         <loginUrl>[YourUrl]</loginUrl>
         <UseSSL>False</UseSSL>
         <PassThroughCookies>
              <PassThroughCookie>[YourSSOCookieName]</PassThroughCookie>
         </PassThroughCookies>
     </CustomAuthenticationUI>
 </UI>

Could you find and provide related error information in the log files? The default path for SSRS 2017 and above is: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


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.