Scheduled report job in error 4

Products

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

Issue/Introduction

From time to time execution of scheduled report jobs are in error :
Reporter job failed. Reporter returned:4

In TRC_REPORTER*.log there is following error :

REPORTER  |Reporter        |                    |000000|ERROR  | Error connecting to domain [#4]

Environment

Client Automation - All Versions

Cause

This problem could have multiple cause but one possible cause is millions of rows in table ca_query_pre_result
Check with this SQL Query how many rows there are in table ca_query_pre_result : 

select count(*) from ca_query_pre_result

This table is a temporary table used during execution of AM Queries.

Resolution

If there are millions of rows in table ca_query_pre_result, it is possible to truncate this table using this SQL Query :

TRUNCATE TABLE ca_query_pre_result

Another solution is to execute the script clean_mdb.bat as described in this article : Huge size of mdb database. How to reduce its size ?
TRUNCATE TABLE command is part of this script.

Execute the SQL command or script clean_mdb on Enterprise and Domains database.
If needed this action could be scheduled regularly (example : every 3 months).