Issue Summary

The Stored Proc RPM_GET_MILESTONE_LIST has a character limit of 8000 but we are seeing instances where a long list of programs will reach this limit quickly. This should be updated to use large object datatype.

Steps to Reproduce

1. Have program names in a portfolio that exceed 8000 characters when concatenated for this query.
   Example use: Loading Portfolio Objectives

Expected Results

Query should run and list all available programs

Actual Results

Query runs and reaches error:

STRING_AGG aggregation result exceeded the limit of 8000 bytes. Use LOB types to avoid result truncation.

Workaround

Reduce Program Names to fall under 8000 character limit.