question

StephenK-0616 avatar image
0 Votes"
StephenK-0616 asked ·

SSRS ReportService2010 SQL Server 2019 problem with GetScheduleProperties

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
image.png (251.2 KiB)
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered ·

Hi @StephenK-0616,

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



· 2 ·
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

StephenK-0616 avatar image StephenK-0616 ·

Thank you for your response. However, the link you provided is for offering suggestions for improvements. The page gives a link for reporting potential problems/bugs which links back to this site.
This looks pretty clearly like a bug to me. The latest version of SSRS with SQL Server 2019 is not responding correctly.

0 Votes 0 ·
Zoehui-MSFT avatar image Zoehui-MSFT StephenK-0616 ·

We could also post the known issue to the feedback for more suggestions. If the issue is mentioned by several times, the product team will pay attention to it and help deal with it.

0 Votes 0 ·