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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,806 questions
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.
2,813 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,304 questions
{count} votes

1 answer

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