Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-41493

Updating a page over the REST API is not working in some cases

      In some cases it is not possible to update a particular page over the REST API.
      The update is returning the following error:

      {
      "statusCode":500,
      "message":"java.lang.IllegalArgumentException: Property with name sync-rev is not a String"
      }
      

      But updating the page manually over the GUI works fine and the new version is saved without any problems.
      When tryin once again to update this page over the REST API it fails again with the same error.

      Root cause

      It seems that the additional entries in the contentproperties table has caused the problem with updating the page. We are not sure why these additional "sync-rev" entries are added into the table even when it is not used yet.

      Steps to reproduce

      Unknown

      Workaround

      Removing the entry related to the sync-rev values directly from the database. :

      1. Backup the database since this require manual database delete
      2. run the following SQL query:
        // identify how many entries need to be deleted
        select count( distinct propertyid) from CONTENTPROPERTIES where propertyname='sync-rev';
        
        
        // delete all of the entries
        delete from CONTENTPROPERTIES where propertyname='sync-rev';
        
      3. restart Confluence instance
      4. verify if the problem persist

      Please try the above on a test instance before you perform it on the production instance

            [CONFSERVER-41493] Updating a page over the REST API is not working in some cases

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2875709 ] New: CONFSERVER Bug Workflow v4 [ 3005121 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2803493 ] New: JAC Bug Workflow v3 [ 2875709 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2736522 ] New: JAC Bug Workflow v2 [ 2803493 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2392051 ] New: JAC Bug Workflow [ 2736522 ]
            Ian Ragudo made changes -
            Remote Link New: This issue links to "DEVHELP-765 (Ecosystem Jira)" [ 331216 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2272726 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2392051 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2223155 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2272726 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2173725 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2223155 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1927931 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2173725 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1737751 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1927931 ]

              Unassigned Unassigned
              535cc85fa498 Michal Sladek
              Affected customers:
              3 This affects my team
              Watchers:
              17 Start watching this issue

                Created:
                Updated:
                Resolved: