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
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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.