* Create a set of tables to process the content updated */ĬREATE TABLE UPDATE_CONTENT_TMP AS (SELECT CONTENT.CONTENTID as contentId, xpage.SPACEID as validSpaceId WHERE CONTENT.SPACEID != xpage.SPACEID) subquery UPDATE CONTENT set SPACEID = NULL, PARENTID = NULL WHERE CONTENT.CONTENTID = subquery.CONTENTID (SELECT CONTENT.CONTENTID as contentId, xpage.SPACEID as validSpaceId UPDATE CONTENT set SPACEID = subquery.validSpaceId To determine if it contains more than one space object, run the following command against the entities.xml file - to see this file, extract it out of the space export file: When importing a singular space export from a Confluence Cloud instance, the export file should only contain one space object. Note that this query should be run against Confluence database from which the space was exported from, not the one you are attempting to import into. If the query returns non-zero values, your database is affected. In this case, please contact Atlassian Support for help troubleshooting the export/import problem. If the query only returns zeroes, your database is not affected by this particular issue. JOIN CONTENT xpage ON CONTENT.PREVVER = xpage.CONTENTID JOIN CONTENT xpage ON CONTENT.PARENTID = xpage.CONTENTID JOIN CONTENT xpage ON CONTENT.PAGEID = xpage.CONTENTID If the space export was created from a Server instance, then you can use the following query to confirm whether the Server instance's database is affected by this issue: Cloud Based InstancesĪ number of Cloud tickets document the possibility that a Cloud space export can include content or space meta data from another space: Which also includes queries that you can use to proactively check for and resolve instances of the problem prior to exporting a space. This is fully described in CONFSERVER-77826 Another known issue relates to moving pages. Server Based Instancesįor instance, if the source of the space export was a Server instance, then the issue could have been caused by database inconsistencies as documented in CONFSERVER-45278 Causeĭifferent problems have been identified as contributors to this problem. This issue was identified in Confluence Server and Data Center 6.x and later. ERROR: duplicate key value violates unique constraint "uk_jp1ad5yufsih5r7lqrygakpug"Ĭaused by: .SQLServerException: Violation of UNIQUE KEY constraint 'UK_jp1ad5yufsih5r7lqrygakpug' Environment
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |