Skip to main content

Error: 'The maximum recursion 100 has been exhausted before statement completion'

Written by Charnjit Singh Dharival

Cannot import data due to the following error:

Orchestrate Data Flow import has failed. The detailed information is as follows:

The statement terminated. The maximum recursion 100 has been exhausted before statement completion

Import command: EXEC [wf].[pr_call_SP_From_Datasource] @DataSourceName = 'Core Supply Chain'. @DatabaseName = 'database name' @ schema_Dot_spName = 'dbo.ASC_ORC_ITEMS_SETUP_S'

or

Orchestrate Data Flow import has failed. The detailed information is as follows:

The statement terminated. The maximum recursion 100 has been exhausted before statement completion

Import command: SELECT 1 AS PlanID

, Part AS ItemCode

, 'BOMLVL' AS AttribName

, Depth AS intValue

FROM UDEF_Bom_LowestLevel


Please raise a new case online and reference the title of this article.

Did this answer your question?