Skip to main content
Solved

Error when calculating nr of function points

  • October 5, 2023
  • 1 reply
  • 61 views

Forum|alt.badge.img+5

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

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.

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

1 reply

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3958 replies
  • Answer
  • October 5, 2023

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.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings