ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 41344

calendar_today

Updated On:

Products

CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation

Issue/Introduction

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

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. 

Environment

Client Automation - All Versions

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.  

Attachments