{"id":1460,"date":"2018-07-05T23:20:26","date_gmt":"2018-07-05T13:20:26","guid":{"rendered":"http:\/\/ntsblog.homedev.com.au\/?p=1460"},"modified":"2018-09-12T00:42:00","modified_gmt":"2018-09-11T14:42:00","slug":"interaction-crm-bug-int_tps_change_management","status":"publish","type":"post","link":"https:\/\/ntsblog.homedev.com.au\/index.php\/2018\/07\/05\/interaction-crm-bug-int_tps_change_management\/","title":{"rendered":"InterAction CRM Bug INT_TPS_CHANGE_MANAGEMENT"},"content":{"rendered":"<div id=\"ntsbl-815800599\" class=\"ntsbl-before-content ntsbl-entity-placement\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6288941070289539\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:728px;height:90px;\" \ndata-ad-client=\"ca-pub-6288941070289539\" \ndata-ad-slot=\"9356781486\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div><p>InterAction CRM (by LexisNexis), has a bug that causes you database to fill up with GB of unnecessary data.<\/p>\n<h2>Do you have the problem?<\/h2>\n<p>To check, get your Database administrator to run a standard SQL Server report, disk usage by top tables.<\/p>\n<p>When you run the report you will see that generally the INT_TPS_CHANGE_MANAGEMENT is one of, if not the, largest tables in the system.<\/p>\n<p>If this table is large, greater than 1GB, then you have a problem.<\/p>\n<p><a href=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAB4.png\"><img decoding=\"async\" data-attachment-id=\"1461\" data-permalink=\"https:\/\/ntsblog.homedev.com.au\/index.php\/2018\/07\/05\/interaction-crm-bug-int_tps_change_management\/iab4\/\" data-orig-file=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAB4.png\" data-orig-size=\"770,236\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"IAB4\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAB4-300x92.png\" data-large-file=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAB4.png\" src=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAB4.png\" alt=\"\" width=\"770\"  class=\"aligncenter size-full wp-image-1461\" srcset=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAB4.png 770w, https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAB4-300x92.png 300w, https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAB4-768x235.png 768w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/a><\/p>\n<h2>What is causing it?<\/h2>\n<p>The INT_TPS_CHANGE_MANAGEMENT table is an audit table of changes that occur due to the Outlook Sync processes.<br \/>\nThere is a clean up routine that trims this audit table of old data, but there is a bug that causes it to fail to clean up these old rows.<\/p>\n<h2>How can I fix it?<\/h2>\n<p>Surprisingly easily.<\/p>\n<p>To find and fix the problem, do the following:<\/p>\n<ol>\n<li>Launch InterAction Administrator<\/li>\n<li>Run &#8220;User Contact List&#8221;<\/li>\n<li>Sort the list by date desc.<\/li>\n<li>You will find that most users were all sync&#8217;d recenlty, but there are one or two old users who have left the firm but still have the firm sync enabled. They will have very old dates for &#8220;Last Firm sync&#8221;.<\/li>\n<li>For each of these old sync users\n<ol>\n<li>Disable the sync<\/li>\n<li>Save the changes<\/li>\n<ol>\n<\/li>\n<\/ol>\n<p>You can now manually execute your Database maintenance script, which should be setup to run weekly on your process manager server.<\/p>\n<p><a href=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAAfter.png\"><img decoding=\"async\" data-attachment-id=\"1462\" data-permalink=\"https:\/\/ntsblog.homedev.com.au\/index.php\/2018\/07\/05\/interaction-crm-bug-int_tps_change_management\/iaafter\/\" data-orig-file=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAAfter.png\" data-orig-size=\"766,247\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"IAAfter\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAAfter-300x97.png\" data-large-file=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAAfter.png\" src=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAAfter.png\" alt=\"\" width=\"766\"  class=\"aligncenter size-full wp-image-1462\" srcset=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAAfter.png 766w, https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAAfter-300x97.png 300w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/a><\/p>\n<h2>Database Maintainence<\/h2>\n<p>Now you can do a little maintenance on your database to <\/p>\n<ol>\n<li>Rebuild database Indexes<\/li>\n<li>Shrink the database<\/li>\n<\/ol>\n<p>And you should saved some space on your system.<br \/>\nThe example in the screen shots cleaned up 3 years worth of old logs<br \/>\nExample: 3.8GB and 15.3 Million rows of data was trimmed to 580MB and only 2.1 million rows of data.<\/p>\n<p><a href=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAFinal.png\"><img decoding=\"async\" data-attachment-id=\"1463\" data-permalink=\"https:\/\/ntsblog.homedev.com.au\/index.php\/2018\/07\/05\/interaction-crm-bug-int_tps_change_management\/iafinal\/\" data-orig-file=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAFinal.png\" data-orig-size=\"768,353\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"IAFinal\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAFinal-300x138.png\" data-large-file=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAFinal.png\" src=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAFinal.png\" alt=\"\" width=\"768\"  class=\"aligncenter size-full wp-image-1463\" srcset=\"https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAFinal.png 768w, https:\/\/ntsblog.homedev.com.au\/wp-content\/uploads\/2018\/07\/IAFinal-300x138.png 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>InterAction CRM (by LexisNexis), has a bug that causes you database to fill up with GB of unnecessary data. Do you have the problem? To [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[35],"tags":[],"class_list":["post-1460","post","type-post","status-publish","format-standard","hentry","category-interaction"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/posts\/1460","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/comments?post=1460"}],"version-history":[{"count":0,"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/posts\/1460\/revisions"}],"wp:attachment":[{"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/media?parent=1460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/categories?post=1460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/tags?post=1460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}