依旧 not support token:Kingdee.BOS.SQL.Parser.Token GetReportData
金蝶云社区-ebbbbon
ebbbbon
0人赞赏了该文章 1829次浏览 未经作者许可,禁止转载编辑于2015年05月20日 11:25:43

sql报表的问题,
1---sql部分-----------------------------
select
t0_L.FName 'AA000',
t4_L.FName 'AA001',
t5_L.FName 'AA002',
convert(decimal(18,2),t7.F_JiBenGongZi) 'AA003',
t7.F_YueFen 'AA004',
convert(decimal(18,2),t7.F_JiBenGongZi1) 'AA005',
convert(decimal(18,2),t7.F_YueDuJiXiaoGongZi) 'AA006',
t7.F_YYueFen 'AA007',
convert(decimal(18,2),t7.F_YueDuJiXiaoGongZiHeJi) 'AA008',
convert(decimal(18,2),t7.F_JiDuJiXiaoGongZi) 'AA009',
t7.F_JiFen 'AA010',
convert(decimal(18,2),t7.F_JiDuJiXiaoGongZiHeJi) 'AA011',
convert(decimal(18,2),t7.F_CanBuBiaoZhun) 'AA012',
t7.F_CYueFen 'AA013',
convert(decimal(18,2),t7.F_CanBuBiaoZhunHeJi) 'AA014',
convert(decimal(18,2),t7.F_JiaoTongBuTieBiaoZhun) 'AA015',
t7.F_JYueFen 'AA016',
convert(decimal(18,2),t7.F_JiaoTongBuTieBiaoZhunHeJi) 'AA017',
convert(decimal(18,2),t7.F_NianZhongHongBao) 'AA018',
convert(decimal(18,2),t7.F_NianDuGeRenShouRuHeJi) 'AA019',
convert(decimal(18,2),t7.F_YangLaoShiYeShengYu) 'AA020',
convert(decimal(18,2),t7.F_GongShang) 'AA021',
convert(decimal(18,2),t7.F_SheBaoHeJi) 'AA022',
t7.F_SYueFen 'AA023',
convert(decimal(18,2),t7.F_SheBaoZongJi) 'AA024',
convert(decimal(18,2),t7.F_BanShiChuFeiYong) 'AA025',
t7.F_BSCYueFen 'AA026',
convert(decimal(18,2),t7.F_BanShiChuFeiYongHeJi) 'AA027',
convert(decimal(18,2),t7.F_YeWuChePiao) 'AA028',
t7.F_YWYueFen 'AA029',
convert(decimal(18,2),t7.F_YeWuChePiaoHeJi) 'AA030',
convert(decimal(18,2),t7.F_TanQinChePiao) 'AA031',
t7.F_TQCiShu 'AA032',
convert(decimal(18,2),t7.F_TanQinChePiaoHeJi) 'AA033',
convert(decimal(18,2),t7.F_DianHuaFei) 'AA034',
t7.F_DHYueFen 'AA035',
convert(decimal(18,2),t7.F_DianHuaFeiHeJi) 'AA036',
convert(decimal(18,2),t7.F_ZhuSuFei) 'AA037',
t7.F_ZSTianShu 'AA038',
convert(decimal(18,2),t7.F_ZhuSuFeiHeJi) 'AA039',
convert(decimal(18,2),t7.F_HuiWuZhuSu) 'AA040',
convert(decimal(18,2),t7.F_HuiWuCanBu) 'AA041',
t7.F_HWTianShu 'AA042',
convert(decimal(18,2),t7.F_huiwuhejiHeJi) 'AA043',
convert(decimal(18,2),t7.F_NianDuGeRenKaiZhiHeJi) 'AA044',
convert(decimal(18,2),t7.F_ZongJi) 'AA045'
from
t_RenYuanNianDuyYuSuan_Head t7 inner join T_BD_OPERATORENTRY t6 on t6.fentryid=t7.F_yg and t7.Fuseorgid=100001
inner join T_BD_STAFF t1 on t6.Fstaffid=t1.Fstaffid
inner join t_bd_stafftemp t2 on t1.Fpostid=t2.Fpostid and t2.Fisfirstpost=1
inner join T_BD_DEPARTMENT_L t4_L on t7.F_BM=t4_L.Fdeptid
inner join T_ORG_POST_L t5_L on t5_L.fpostid=t2.fpostid
inner join T_HR_EMPINFO_L t0_L on t1.FEmpinfoid=t0_L.FID

2---报错部分-----------------------------
not support token:Kingdee.BOS.SQL.Parser.Token

[{"operation":"fe815eec-2a7e-4660-86c7-4f9484b36870.GetReportData"}]
发生时间:10:58:14
错误来源: Kingdee.BOS.SQL
错误信息:not support token:Kingdee.BOS.SQL.Parser.Token
===================================================
调用堆栈:
at Kingdee.BOS.SQL.Parser.SelectParser.select(Boolean parseOrderBy)
at Kingdee.BOS.SQL.Parser.SelectParser.select(Boolean parseOrderBy)
at Kingdee.BOS.SQL.Parser.SqlStmtParser.select()
at Kingdee.BOS.SQL.Parser.SqlStmtParser.stmt()
at Kingdee.BOS.SQL.Parser.SqlStmtParser.stmtList(IList stmtCol, Token tok)
at Kingdee.BOS.SQL.TransUtil.getStmtList(String ksql)
错误数据: System.Collections.ListDictionaryInternal

3---图片部分-----------------------------

[图1]


[图2]


[图3]

4---详细说明-----------------------------

a.sql一直都是可以查得到数据的,(查询分析器中)
b.创建这张报表[图2]后,原是正确的,过了两天(时间不清楚,因为是客户查觉的)就变成[图2]这样了,
c.现我另外新建一张dd1[图3]马上看,是正常的,(估计过两天也会打不开像[图2]一样吧,)
d.该sql,并没有使用关键字,不需要维护关键字
e.这样应该算是bug吧