SQL报表The SQL statement contains illegal characters

栏目:云星空知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

SQL报表The SQL statement contains illegal characters

【背景】本地BOS编写的sql报表测试OK,到公有云正式环境,就提示The SQL statement contains illegal characters

SQL.webp


SQL2.webp


【排查思路】

先查看公有云日志发现跟客户反馈时间节点一致,一直有重复重复出现

2021-08-13 09:34:21,321 [24] ERROR - BOS - The SQL statement contains illegal characters

发生时间: 2021-08-13 09:34:21

错误来源:

错误类型: System.Exception, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

错误信息: The SQL statement contains illegal characters

===================================================

调用堆栈:

   在 Kingdee.BOS.ServiceFacade.ServicesStub.Metadata.SQLScriptService.CheckRemoteValidSql(String strSQL, IllegalSqlCheckType[] sqlcheckTypes)

   在 Kingdee.BOS.ServiceFacade.ServicesStub.Metadata.SQLScriptService.ExecuteDataSetSafe(String strSQL, IllegalSqlCheckType[] sqlcheckTypes, Boolean writeLog)

   在 Kingdee.BOS.ServiceFacade.ServicesStub.Metadata.SQLScriptService.ExecuteDataSet(String strSQL)



1.The SQL statement contains illegal characters,顾名思义当前SQL语句包含非法字符,先重点检查下当前SQL是否包含了非法字符,进一步确认SQL没有问题;

2.打开客户二开对比发现,线上正式环境发现引用的核心开发插件组件是7.6.2003.9高于线上版本7.5.1800.6,此处不赘述,参考简单二开插件,创建导致出现当前问题,重新引用编译后问题解决。

image.webp




【emoji】

SQL报表The SQL statement contains illegal characters

【背景】本地BOS编写的sql报表测试OK,到公有云正式环境,就提示The SQL statement contains illegal characters【排查思路】先查看公...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息