Forum Discussion

THarmes's avatar
THarmes
New Member
3 years ago
Solved

Problem altering a subscription / JSON reader error

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

PBIRS
Subscription
  • v-alipat's avatar
    v-alipat
    3 years ago

    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

23 Replies

  • v-alipat's avatar
    v-alipat
    Microsoft Employee
    3 years ago

    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

    • TomD's avatar
      TomD
      Frequent Visitor
      3 years ago

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

      • v-alipat's avatar
        v-alipat
        Microsoft Employee
        3 years ago

        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) 

  • jsgoergen's avatar
    jsgoergen
    Frequent Visitor
    3 years ago

    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.

  • levj4's avatar
    levj4
    Frequent Visitor
    3 years ago

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

    • v-alipat's avatar
      v-alipat
      Microsoft Employee
      3 years ago

      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.  

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.

      • jarretl's avatar
        jarretl
        Advocate I
        3 years ago

        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.

  • d_gosbell's avatar
    d_gosbell
    Super User
    3 years ago

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

  • jsgoergen's avatar
    jsgoergen
    Frequent Visitor
    3 years ago

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

    • v-alipat's avatar
      v-alipat
      Microsoft Employee
      3 years ago

      Hi jsgoergen, 

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

       

      Thanks,

      Alexandra