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
Answer
Error when calculating nr of function points
- Vanguard
Best answer by Mark Jongeling
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.
This topic has been closed for replies.
+23Hi
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.