AutoForecast - Entries are not expandanble

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

When generated Autoforecast in the list of Forecasts (pm/forecast), you can expand the first ones but not all of them. 

Environment

Release : 12.3.X

Component : AUTOMATION ENGINE

Cause

Configuration

Resolution

The Default setting for AUTO_FORECAST is 5000. 

We can increase the limit for  AUTO_FORECAST up to 20000. For increasing the limit, kindly follow below steps.

1. Login to Client 0

2. Go to UC_SYSTEM_SETTINGS

3.  Changed the value of  GENERIC_AUTO_FORECAST_LIMIT to 20000 

4. Save and exit. 

Now you will be able to view the AutoForecast to 20000

PLEASE NOTE: In some systems that are heavily used, you may still see that some entries are still not expandable because there are more than 20,000 entries in the forecast.  The 20,000 rows is a hard limit.  You can doublecheck if this is happening by running:

select count(*) from fe where fe_fh_idnr in (select fh_idnr from fh where fh_client = [CLIENT] and FH_Title = 'AUTOFORECAST')

Replace [CLIENT] with the client number where the autoforecast is run.

An alternative to using AutoForecast within the AWI is to use the reporting tool to put together a report on the autoforecast.  Here is a guide to do so.

Additional Information

Below is the documentation for further details.

https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/21.0/Automic%20Automation%20Guides/Content/AWA/Variables/UC_SYSTEM_SETTINGS/UC_SYSTEM_GENERIC_AUTO_FORECAST_LIMIT.htm