{"id":1362,"date":"2014-05-08T08:51:33","date_gmt":"2014-05-08T07:51:33","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1362&#038;lang=en"},"modified":"2014-05-08T08:51:33","modified_gmt":"2014-05-08T07:51:33","slug":"consolidation-check-after-delete-of-target-database","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1362","title":{"rendered":"Consolidation: Check after delete of target database"},"content":{"rendered":"<p>After the database deletion, it&#8217;s necessary to launch a check to clean records.<br \/>\nConsolidation records are generated in GLMovementDBIdEntryNum table.<\/p>\n<p>Here, two checks that consider this table: <a href=\"https:\/\/sdna.lu\/wp-content\/uploads\/Untitled53.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1364\" alt=\"Untitled\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/Untitled53-1024x616.png\" width=\"640\" height=\"385\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/Untitled53-1024x616.png 1024w, https:\/\/sdna.lu\/wp-content\/uploads\/Untitled53-300x180.png 300w, https:\/\/sdna.lu\/wp-content\/uploads\/Untitled53.png 1660w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>The first one, &#8220;GLMovementDBIdEntryNumber &#8211; Delete incorrect records&#8221; must run.<br \/>\nThis process deletes invalid records in current database in consolidation table (GLMovementDBIdEntryNumber). They are invalid because when the target database does not exist or the corresponding entry in target does not exist.<br \/>\nIn more than deletion, an update is done to allow a new launch of consolidation: GLMovement.ModificationType to 0.<\/p>\n<p>For information, the second check, &#8220;GLMovementDBIdEntryNumber &#8211; Update records&#8221; must be used for other case.<br \/>\nIt creates missing records in current database GLMovementDBIdEntryNumber table based upon GLMovement.DBIdEntryNumber field. (Old consolidation method).<br \/>\nIt deletes also all the GLMovementDBIdEntryNumber records for missing entries in current database.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After the database deletion, it&#8217;s necessary to launch a check to clean records. Consolidation records are generated in GLMovementDBIdEntryNum table. Here, two checks that consider this table: The first one, &#8220;GLMovementDBIdEntryNumber &#8211; Delete incorrect records&#8221; must run. This process deletes invalid records in current database in consolidation table (GLMovementDBIdEntryNumber). They are invalid because when the [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1362","post","type-post","status-publish","format-standard","hentry","category-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1362","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1362"}],"version-history":[{"count":3,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1362\/revisions"}],"predecessor-version":[{"id":1366,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1362\/revisions\/1366"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}