为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】：linux
【CPU】:海光
【问题描述】*：自定义视图，创建视图语句正确，可以查询到数据，视图编译通过，但是浏览数据失败
和这个报错一样，完整sql:CREATE OR REPLACE VIEW "PT6"."PM_DEPT_N_TREE_V"
(
"ID",
"PARENT_DEPT_ID",
"DEPT_NAME",
"ORDER_BY"
)
AS
select "T"."ID" AS "ID",
"T"."PARENT_ID" AS "PARENT_DEPT_ID",
"T"."ORG_NAME" AS "DEPT_NAME",
"T"."ORDER_BY" AS "ORDER_BY"
from (select "T1"."ID" AS "ID",
"T1"."ORG_CODE" AS "ORG_CODE",
"T1"."PARENT_ORG_ID" AS "PARENT_ID",
"T2"."ORG_NAME" AS "ORG_NAME",
"T1"."ORDER_BY" AS "ORDER_BY"
from ("SYS_ORG" "T1"
left join "SYS_ORG_TL" "T2"
on(("T1"."ID" = "T2"."SYS_ORG_ID")))
union all
select "T1"."ID" AS "ID",
"T1"."DEPT_CODE" AS "ORG_CODE",
if(("T1"."PARENT_DEPT_ID" = '-1'),"T1"."ORG_ID","T1"."PARENT_DEPT_ID") AS "PARENT_ID",
"T2"."DEPT_NAME" AS "ORG_NAME",
"T1"."ORDER_BY" AS "ORDER_BY"
from ("SYS_DEPT" "T1"
left join "SYS_DEPT_TL" "T2"
on(("T1"."ID" = "T2"."SYS_DEPT_ID")))
where ("T1"."VALID_FLAG" = '1')
order by "ORDER_BY") "T";

COMMENT ON VIEW "PT6"."PM_DEPT_N_TREE_V"
IS
'VIEW';