Archive

Archive for July 5th, 2018

InterAction CRM Bug INT_TPS_CHANGE_MANAGEMENT

July 5th, 2018 No comments

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 check, get your Database administrator to run a standard SQL Server report, disk usage by top tables.

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.

If this table is large, greater than 1GB, then you have a problem.

What is causing it?

The INT_TPS_CHANGE_MANAGEMENT table is an audit table of changes that occur due to the Outlook Sync processes.
There 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.

How can I fix it?

Surprisingly easily.

To find and fix the problem, do the following:

  1. Launch InterAction Administrator
  2. Run “User Contact List”
  3. Sort the list by date desc.
  4. You will find that there are one or two old uses who have left the firm but still have the firm sync enabled, they will have very old dates for “Last Firm sync”.
  5. For each of these old sync users
    1. Disable the sync
    2. Save the changes

      You can now manually execute your Database maintenance script, which should be setup to run weekly on your InterAction Admin

      Database Maintainence

      Now you can do a little maintenance on your database to

      1. Rebuild database Indexes
      2. Shrink the database

      An you should saved some space on your system.
      The example in the screen shots cleaned up 3 years worth of old logs
      Example: 3.8GB and 15.3 Million rows of data was trimmed to 580MB and only 2.1 million rows of data.

      VN:F [1.9.22_1171]
      Rating: 0.0/10 (0 votes cast)

Categories: InterAction Tags: