What do I do if my MDB Server is running out of room?

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

What do I do if my MDB Server is running out of room ?

Environment

Client Automation - All Versions

Cause

Figure out which tables are using the most data :

      4 of the Tables that can get really big are :

      ca_query_pre_results           -  There is a Testfix that resolves this issue.

      ca_replication_history          -  This can happen if Replication is enabled, but you are not running the Replication Engine task.

      ca_synchronization_history  - This can happen if SQL Bridge is enabled, but you are not running the SQL Bridge Engine task.

      audithis                                 -  This table is used to store Software Usage data

 

There are SQL queries that list tables of a Database by Size, use Google to find them. 

Resolution

Shrink the Transaction Logs

Stop CAF and make a backup of the Database: mdb

Go to SQL then to the mdb

Right-click on mdb -> Select Tasks -> Shrink -> Files           

 

Change Files Type to Log and Hit OK

 

You might have a lot of Old Reporter Data:

 Go into Reporter and Delete old Reports or keep the Report and just delete old Report Results that have been created.