Oracle Error QSM-00809: the selected number of recommendations exceeds the maximum value of string

Oracle Error Message

QSM-00809: the selected number of recommendations exceeds the maximum value of string

Reason for the Error

While executing GET_TASK_SCRIPT, an attempt was made to fetch a script having too many recommendations. The limit has been set in order to avoid possible performance and out-of-memory errors.

Solution

Select a small set of recommendations prior to fetching the script