{"id":16398,"date":"2016-07-04T07:31:27","date_gmt":"2016-07-03T23:31:27","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=16398"},"modified":"2024-07-05T11:18:57","modified_gmt":"2024-07-05T03:18:57","slug":"database-clash-occurs-after-an-upgrade","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/server-troubleshooting\/database-clash-occurs-after-an-upgrade\/","title":{"rendered":"Database Clash Occurs After an Upgrade"},"content":{"rendered":"<p class=\"intro-text\"><strong>Problem<\/strong>: A database clash occurs following an upgrade<\/p>\n<p class=\"intro-text\"><strong>Description<\/strong>: A database clash occurs if you backup and restore a Server database onto the same SQL Server instance under another name.<\/p>\n<p class=\"intro-text\"><strong>Cause<\/strong>: The IFS OI Server database will keep the original GUID used to identify the Data Broker and clash with the original source database.<\/p>\n<p class=\"intro-text\"><strong>Resolution<\/strong>: To resolve this, run the following command on the database following the upgrade:<\/p>\n<pre>ALTER DATABASE cadrondemo01_Server40 SET NEW_BROKER<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>A database clash may occur if you backup and restore a Server database onto the same SQL Server instance under another name. This article outlines how to solve this problem.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/server-troubleshooting\/database-clash-occurs-after-an-upgrade\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":16408,"parent":3651,"menu_order":7,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[10],"tags":[470,243],"class_list":["post-16398","page","type-page","status-publish","has-post-thumbnail","hentry","category-troubleshooting","tag-database","tag-troubleshooting","Product-srv"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/16398","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=16398"}],"version-history":[{"count":2,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/16398\/revisions"}],"predecessor-version":[{"id":67834,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/16398\/revisions\/67834"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/3651"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/16408"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=16398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=16398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=16398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}