新增物料分组时报系统错误

目前只有11个物料分组，

报错内容：

发生时间： 2016-10-27 09:31:44
错误编号： ExecuteBatch
错误信息： 语句被终止。完成执行语句前已用完最大递归 100。
Sql语句： /*dialect*/
WITH TEMPGROUP AS (
SELECT FID,FNUMBER,FGROUPID,FPARENTID,
(CASE WHEN LEN(FFULLPARENTID)>0 THEN LTRIM(FFULLPARENTID)+'.'++CAST(FID AS VARCHAR) ELSE '.'
+CAST(FID AS VARCHAR)END)AS FFULLPARENTID
,FLEFT,FRIGHT ,CAST(ROW_NUMBER() OVER (ORDER BY FID) AS NVARCHAR(max))AS SEQ
,CAST(ROW_NUMBER() OVER (ORDER BY FID) AS NVARCHAR(max)) AS FORDERBY
FROM T_BD_MATERIALGROUP WHERE FPARENTID=0 UNION ALL
SELECT C.FID,C.FNUMBER,C.FGROUPID,C.FPARENTID,
(CASE WHEN LEN(C.FFULLPARENTID)>0 THEN ltrim(C.FFULLPARENTID)+'.'+CAST(C.FID AS VARCHAR)