SSRS ReportService2010 SQL Server 2019 problem with GetScheduleProperties

Stephen K 1 Reputation point
2021-03-08T04:19:52.64+00:00

Hi,

We've been using SQL Server reporting services for many years, programmatically using the ReportingService2010 client generated from the 2010 endpoint. Users of our application can create and manage schedules and scheduled reports.

One of the calls our code uses is the standard GetScheduleProperties, which returns a Schedule object (as out param). The Schedule object contains a ScheduleDefinitition object which provides the details of the schedule definition, such as StartDateTime and EndDate.

Against SQL Server 2014 reporting services (and previous) this worked fine - the Schedule object came back properly populated. However, against SQL Server 2019 reporting services the ScheduleDefintion object comes back with '01/01/0001 00:00:00' as the StartDateTime property value.
75199-image.png

Is this a bug or are we missing something? Note we haven't changed the code other than updating the service reference against the latest service.

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
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,296 Reputation points
    2021-03-09T08:13:43.66+00:00

    Hi @Stephen K ,

    Not sure if this is a bug.

    As you described that the issue only occurs in SQL Server 2019, I'd suggest that you may also post the issue here.

    This site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft feedback.

    Regards,
    Zoe


    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.

    What can I do if my transaction log is full?--- Hot issues November

    How to convert Profiler trace into a SQL Server table -- Hot issues November