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
Best answer by Mark Jongeling
View original
Error when calculating nr of function points
This topic has been closed for comments
Userlevel 7
+23
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.