topic Re: Problem altering a subscription / JSON reader error in Report Server

Problem altering a subscription / JSON reader error

THarmes — Mon, 17 Oct 2022 07:40:40 GMT

Hi all,

after updating to Sep 22 Update, we have problems with changes in subscriptions to paginated reports.
We do the changes and after clicking on "Apply" we receive a "there was an error" - "sorry there was an error, please try again." message box. We hunted down the topic in the log files and found out, that in the RSPortal log file after the PUT request for the Subscription there is a warn message:
"BadRequest, Errors: An unexpected instance annotation name 'DaysOfWeek.Sunday' was found when reading from the JSON reader, In OData, Instance annotation name must start with @."

In original it looks as following:

2022-10-17 08:00:19.1267|INFO|204|Received request PUT /api/v2.0/subscriptions(c2c964fc-149a-41b3-b578-a94e7045f41e)| RequestID = s_cc703e8e-f941-4a95-9508-8b0ebb994806 2022-10-17 08:00:19.1892|WARN|204|BadRequest, Errors: An unexpected instance annotation name 'DaysOfWeek.Sunday' was found when reading from the JSON reader, In OData, Instance annotation name must start with @.| RequestID = s_cc703e8e-f941-4a95-9508-8b0ebb994806

We have installed the german version of PBIRS. Any suggestions how to solve the problem?

Best regards,
Thomas

Re: Problem altering a subscription / JSON reader error

jsgoergen — Mon, 17 Oct 2022 20:03:55 GMT

We are hitting the same error after upgrading to Sep 22. It looks like it's happening on all subscriptions that have a frequency of Day, Week or Month. 'Hourly' and 'Once' are working.

Re: Problem altering a subscription / JSON reader error

d_gosbell — Tue, 18 Oct 2022 00:06:54 GMT

I think you should probably look at raising a support ticket with Microsoft for this. @Petebro - is this a known issue?

Re: Problem altering a subscription / JSON reader error

v-alipat — Tue, 18 Oct 2022 00:54:57 GMT

@jsgoergen hello,
We are working on a fix for this bug already
As a workaround you can use shared schedule with the needed cadence for now

@Petebro may have more details on when to expect the fix

Re: Problem altering a subscription / JSON reader error

levj4 — Thu, 27 Oct 2022 12:50:32 GMT

We also have this problem since the update to Sept 2022. Is there any news about the fix ?

Re: Problem altering a subscription / JSON reader error

v-alipat — Thu, 27 Oct 2022 15:14:39 GMT

Hello,

The September 2022 release is planned to be patched with the fix before the end of the year.

Till that time, you can consider using shared schedules as a workaround to get unblocked.

Re: Problem altering a subscription / JSON reader error

TomD — Thu, 17 Nov 2022 18:45:38 GMT

@Petebro Where will you notify us of the fix?
Do you know when this will be fixed?

Re: Problem altering a subscription / JSON reader error

v-alipat — Thu, 17 Nov 2022 20:09:05 GMT

Hi!

The fix is ready, and patch for PBIRS September is planned soon, by end of this year.

Pete will create a post announcing the new release here in the forum, and we can also ping you all here in this post.

Reminding you about a workaround - using shared schedules (in the top navbar - click Settings → Site settings → Schedules → create a needed schedule, then use it for your subscription)

Re: Problem altering a subscription / JSON reader error

FrancWest — Mon, 21 Nov 2022 13:07:33 GMT

Why does it take so long to release a patch for something you broke more than a month ago?

Re: Problem altering a subscription / JSON reader error

Ann-Catrin — Thu, 01 Dec 2022 13:05:58 GMT

Any update on when this fix will be available?

Re: Problem altering a subscription / JSON reader error

jarretl — Mon, 12 Dec 2022 15:33:55 GMT

Hi @v-alipat,

Is there any update on this? End of the year is quickly approaching... If there is already a fix in place for this, why hasn't an update been issued? I am checking the PBI report server change log page daily hoping to see this fix added, but still nothing.

Re: Problem altering a subscription / JSON reader error

v-alipat — Tue, 13 Dec 2022 01:46:30 GMT

Hi @jarretl,

The update is coming soon with a couple of other important fixes as well, that's why it took a bit longer to happen. The update will be published within the next week, and we will notify you about that.

Thank you

Re: Problem altering a subscription / JSON reader error

levj4 — Tue, 13 Dec 2022 17:28:01 GMT

The fix is released guys !! (I've not tested it yet .... )

Download Microsoft Power BI Report Server- September 2022 from Official Microsoft Download Center

Enjoy !

Re: Problem altering a subscription / JSON reader error

jsgoergen — Tue, 13 Dec 2022 18:00:23 GMT

Is there a way to disable the publish button that's now on by default?

Re: Problem altering a subscription / JSON reader error

v-alipat — Wed, 14 Dec 2022 09:28:32 GMT

Hi @jsgoergen,

Yes, you can disable the feature in your Report Server Database → ConfigurationInfo table → change "EnablePowerBIReportMigrate" property from True to False

Thanks,

Alexandra

Re: Problem altering a subscription / JSON reader error

Anonymous — Wed, 14 Dec 2022 16:02:34 GMT

Hey! Do I need to update the version of the desktop app?

I have many user computers where the September version is installed. I now see a different version of the desktop app in the latest release.

Re: Problem altering a subscription / JSON reader error

Anonymous — Wed, 14 Dec 2022 16:03:42 GMT

Hey! Do I need to update the version of the desktop app?

I have many user computers where the September version is installed. I now see a different version of the desktop app in the latest release.

Re: Problem altering a subscription / JSON reader error

jarretl — Thu, 15 Dec 2022 15:51:27 GMT

Changes in the latest release are posted here now:
Change log for Power BI Report Server - Power BI | Microsoft Learn

~~If any of those related to PBIX file bug fixes affect you, you might want to upgrade desktop, otherwise you could probably wait until the next release (Jan/Feb 2023?)~~

Correction: from the release notes it looks like bug fixes were all for the server release, no new bug fix or version number was added under the PBI Desktop notes below that, so the PBI Desktop edition released with this is likely the same version last updated Oct 4.

Re: Problem altering a subscription / JSON reader error

nyang — Tue, 03 Jan 2023 20:24:55 GMT

Hi @v-alipat

I'm encoutering the same issue like the other users here. When will this patch be release?

Thank you

Re: Problem altering a subscription / JSON reader error

FrancWest — Tue, 03 Jan 2023 20:29:55 GMT

It was already released a couple of weeks ago. Link is also in this thread.