You may see the following error when importing data in Orchestrate Data Flow. This can occur with either of the import commands below.
Variant 1
⚠️Important: 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'
Variant 2
⚠️Important: 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
Resolve this error
To resolve this issue, please raise a new case online and reference the title of this article. Our Support team will be happy to help.