Subscriptions are not creating in the report server database

Vito 1 Reputation point
2022-05-16T13:55:33.03+00:00

I have written the code to create the subscriptions by adding the reference to ReportService2010.asmx. Please see the below screenshot for code and result [Id = 218, Status = WaitingForActivation, Method = "{null}", Result = "{Not yet computed}"]. I am not getting any error, but subscriptions are not creating in the DB.

I have configured the report server correctly by using the Report Server Configuration Manager. Reports are rendering correctly using the report server and entries of logs are creating in the table 'ExecutionLogStorage' of ReportServer DB.

Code:

ReportingService2010SoapClient rs = new ReportingService2010SoapClient(EndpointConfiguration.ReportingService2010Soap);

string report = "http://servername/ReportServer/Myreports/MyRDL";

System.Threading.Tasks.Task subscriptionID;

subscriptionID = rs.CreateSubscriptionAsync(new TrustedUserHeader(),report, extSettings, description, eventType, matchData, parameters);

Result of web service:

202371-image.png

I have used VS 2022, Framework 6.0, .net core. Microsoft SQL Server 2019.

Screenshot of Web Service Reference:

202309-image.png

Please let me know if missed anything. Thanks in advance.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,066 questions
SQL Server | Other
Developer technologies | C#
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,636 Reputation points
    2022-05-23T02:50:49.427+00:00
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.