The maximum recursion 100 has been exhausted before statement completion

Marvei Paña

Question

I encountered this issue in BPT, is there a way to increase the maximum recursion value to 1000?

Regards,

Marvei

30 Jun 2022

Volodymyr Tkachenko

100 is the default MAXRECURSION param at SQL.

Try using OPTION (MAXRECURSION 1000) in your SQL statement

30 Jun 2022

2 replies

Last reply 30 Jun 2022

Show thread

Hide thread

Marvei Paña

Thank you @Volodymyr Tkachenko , how can you implement it on an aggregate?

30 Jun 2022

Volodymyr Tkachenko

oh, it seems that the issue is not in the SQL then.

I think that the process is entering an infinite loop because of the business logic you implemented. Can you share the screenshot of the code?

30 Jun 2022

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.