Details
-
Bug
-
Resolution: Fixed
-
High
-
None
-
2
-
Severity 2 - Major
-
No
Description
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
- 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.