Skip to main content

I get this error when I try to calculate function points

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

 

Can this be solved

 

Hi @avandervelden,

That is unfortunate. This is caused by the "visible columns” part of the analysis I can see. Could you create a ticket for this in TCP so we can resolve this in an upcoming version?

For now, you can open the stored procedure "task_calculate_function_points” in the Software Factory database, then declare the input parameters of the task as variables, and run the content of the task manually whilst commenting out the string_agg parts - those are not essential to the calculation.