电脑桌面
添加蚂蚁七词文库到电脑桌面
安装后可以在桌面快捷访问

【主数据】客商分配管理单元时提示translate sql exception

来源:金蝶云社区作者:金蝶2024-09-223

【主数据】客商分配管理单元时提示translate sql exception

image.webp

错误详细堆栈信息:com.kingdee.bos.BOSException: null

Caused exception message is: translate sql exception, message is

parse error. detail message is :

ERROR. Token's value :  first_rows(100) , token's type : Hints, line 1, column 15

source sql is :

select top 50 /*+ first_rows(100) */ 0 as "SELCOL",v."NUMBER",v."NAME",v."SIMPLENAME",v."MNEMONICCODE",v."TAXREGISTERNO",v."ISINTERNALCOMPANY",v."ID",v."BROWSEGROUP.NAME",v."CREATETIME",v."LASTUPDATETIME",v."CREATOR.NAME" from  (SELECT "CUSTOMER".FNumber AS "NUMBER", "CUSTOMER".FName_l2 AS "NAME", "CUSTOMER".FSimpleName AS "SIMPLENAME", "CUSTOMER".FMnemonicCode AS "MNEMONICCODE", "CUSTOMER".FTxRegisterNo AS "TAXREGISTERNO", "CUSTOMER".FIsInternalCompany AS "ISINTERNALCOMPANY", "CUSTOMER".FID AS "ID", "BROWSEGROUP".FName_l2 AS "BROWSEGROUP.NAME", "CUSTOMER".FCreateTime AS "CREATETIME", "CUSTOMER".FLastUpdateTime AS "LASTUPDATETIME", "CREATOR".FName_l2 AS "CREATOR.NAME" FROM T_BD_Customer AS "CUSTOMER"

INNER JOIN T_BD_CSSPGroup AS "BROWSEGROUP"

ON "CUSTOMER".FBrowseGroupID = "BROWSEGROUP".FID

INNER JOIN T_PM_User AS "CREATOR"

ON "CUSTOMER".FCreatorID = "CREATOR".FID

LEFT OUTER JOIN T_ORG_CtrlUnit AS "CU"

ON "CUSTOMER".FControlUnitID = "CU".FID WHERE "CUSTOMER".FUsedStatus = 1 AND "BROWSEGROUP".FDeletedStatus = 1 AND "CUSTOMER".FControlUnitID = '00000000-0000-0000-0000-000000000000CCE7AED4') v

【主数据】客商分配管理单元时提示translate sql exception

错误详细堆栈信息:com.kingdee.bos.BOSException: nullCaused exception message is: translate sql exception, message isparse...
点击下载文档文档为doc格式

声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。

已经是第一篇
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息
QQ群
  • 答案:my7c点击这里加入QQ群
支持邮箱
微信
  • 微信