禅道号：2072

作者：李武生

重现步骤：

报错信息如下：

Error message:Sql1 execute exception : UPDATE b SET b.CFNameClientCode = a.CFNameClientCode FROM T_BD_CustomerCompanyInfo a INNER JOIN T_BD_CustomerCompanyInfo b ON a.FCustomerID = b.FCustomerID INNER JOIN T_ORG_Company c ON b.FComOrgID = c.FID WHERE a.FComOrgID = '00000000-0000-0000-0000-000000000000CCE7AED4' AND a.CFNameClientCode IS NOT NULL AND b.CFNameClientCode IS NULL AND c.FName_L2 not LIKE '%-Local Book' AND c.FIsBizUnit = 1
Caused exception message is: translate sql exception, message is
parse error. detail message is :

Error: expect token <Operator,=>, but current token is <Punctuation,.>, at line 1, column 15)
source sql is :
UPDATE b SET b.CFNameClientCode = a.CFNameClientCode FROM T_BD_CustomerCompanyInfo a INNER JOIN T_BD_CustomerCompanyInfo b ON a.FCustomerID = b.FCustomerID INNER JOIN T_ORG_Company c ON b.FComOrgID = c.FID WHERE a.FComOrgID = '00000000-0000-0000-0000-000000000000CCE7AED4' AND a.CFNameClientCode IS NOT NULL AND b.CFNameClientCode IS NULL AND c.FName_L2 not LIKE '%-Local Book' AND c.FIsBizUnit = 1
Stack trace:
com.kingdee.bos.BOSException: Sql1 execute exception : UPDATE b SET b.CFNameClientCode = a.CFNameClientCode FROM T_BD_CustomerCompanyInfo a INNER JOIN T_BD_CustomerCompanyInfo b ON a.FCustomerID = b.FCustomerID INNER JOIN T_ORG_Company c ON b.FComOrgID = c.FID WHERE a.FComOrgID = '00000000-0000-0000-0000-000000000000CCE7AED4' AND a.CFNameClientCode IS NOT NULL AND b.CFNameClientCode IS NULL AND c.FName_L2 not LIKE '%-Local Book' AND c.FIsBizUnit = 1
Caused exception message is: translate sql exception, message is
parse error. detail message is :

Error: expect token <Operator,=>, but current token is <Punctuation,.>, at line 1, column 15)
source sql is :
UPDATE b SET b.CFNameClientCode = a.CFNameClientCode FROM T_BD_CustomerCompanyInfo a INNER JOIN T_BD_CustomerCompanyInfo b ON a.FCustomerID = b.FCustomerID INNER JOIN T_ORG_Company c ON b.FComOrgID = c.FID WHERE a.FComOrgID = '00000000-0000-0000-0000-000000000000CCE7AED4' AND a.CFNameClientCode IS NOT NULL AND b.CFNameClientCode IS NULL AND c.FName_L2 not LIKE '%-Local Book' AND c.FIsBizUnit = 1
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:260)
at com.kingdee.eas.custom.media.app.CustomerUpdateFacadeControllerBean.update(CustomerUpdateFacadeControllerBean.java:36)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:64)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:180)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:325)
at com.sun.proxy.$Proxy214.update(Unknown Source)
at com.kingdee.eas.custom.media.CustomerUpdateFacade.update(CustomerUpdateFacade.java:42)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.kingdee.bos.ResponseInvocationHandler.invoke(ResponseInvocationHandler.java:194)
at com.sun.proxy.$Proxy213.update(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.kingdee.bos.service.job.wrapper.FacadeInvoke.innerLocalInvoke(FacadeInvoke.java:215)
at com.kingdee.bos.service.job.wrapper.FacadeInvoke.localInvoke(FacadeInvoke.java:92)
at com.kingdee.bos.service.job.wrapper.FacadeInvoke.localInvoke(FacadeInvoke.java:74)
at com.kingdee.bos.service.job.wrapper.FunctionWrapper.call(FunctionWrapper.java:203)
at com.kingdee.bos.service.job.wrapper.FunctionWrapper.invoke(FunctionWrapper.java:187)
at com.kingdee.bos.service.job.wrapper.FunctionWrapper.execute(FunctionWrapper.java:118)
at com.kingdee.bos.service.job.core.ThreadWorker.execute(ThreadWorker.java:179)
at com.kingdee.bos.service.job.core.ThreadWorker.run(ThreadWorker.java:120)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: translate sql exception, message is
parse error. detail message is :

Error: expect token <Operator,=>, but current token is <Punctuation,.>, at line 1, column 15)
source sql is :
UPDATE b SET b.CFNameClientCode = a.CFNameClientCode FROM T_BD_CustomerCompanyInfo a INNER JOIN T_BD_CustomerCompanyInfo b ON a.FCustomerID = b.FCustomerID INNER JOIN T_ORG_Company c ON b.FComOrgID = c.FID WHERE a.FComOrgID = '00000000-0000-0000-0000-000000000000CCE7AED4' AND a.CFNameClientCode IS NOT NULL AND b.CFNameClientCode IS NULL AND c.FName_L2 not LIKE '%-Local Book' AND c.FIsBizUnit = 1
at com.kingdee.bos.sql.shell.KDStatement.getSql(KDStatement.java:122)
at com.kingdee.bos.sql.shell.KDStatement.execute(KDStatement.java:339)
at com.apusic.jdbc.adapter.StatementHandle.execute(StatementHandle.java:245)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:255)
... 31 more
Caused by: java.sql.SQLException
java.sql.SQLException: translate sql exception, message is
parse error. detail message is :

Error: expect token <Operator,=>, but current token is <Punctuation,.>, at line 1, column 15)
source sql is :
UPDATE b SET b.CFNameClientCode = a.CFNameClientCode FROM T_BD_CustomerCompanyInfo a INNER JOIN T_BD_CustomerCompanyInfo b ON a.FCustomerID = b.FCustomerID INNER JOIN T_ORG_Company c ON b.FComOrgID = c.FID WHERE a.FComOrgID = '00000000-0000-0000-0000-000000000000CCE7AED4' AND a.CFNameClientCode IS NOT NULL AND b.CFNameClientCode IS NULL AND c.FName_L2 not LIKE '%-Local Book' AND c.FIsBizUnit = 1
at com.kingdee.bos.sql.shell.KDStatement.getSql(KDStatement.java:122)
at com.kingdee.bos.sql.shell.KDStatement.execute(KDStatement.java:339)
at com.apusic.jdbc.adapter.StatementHandle.execute(StatementHandle.java:245)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:255)
at com.kingdee.eas.custom.media.app.CustomerUpdateFacadeControllerBean.update(CustomerUpdateFacadeControllerBean.java:36)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:64)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:180)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:325)
at com.sun.proxy.$Proxy214.update(Unknown Source)
at com.kingdee.eas.custom.media.CustomerUpdateFacade.update(CustomerUpdateFacade.java:42)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.kingdee.bos.ResponseInvocationHandler.invoke(ResponseInvocationHandler.java:194)
at com.sun.proxy.$Proxy213.update(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.kingdee.bos.service.job.wrapper.FacadeInvoke.innerLocalInvoke(FacadeInvoke.java:215)
at com.kingdee.bos.service.job.wrapper.FacadeInvoke.localInvoke(FacadeInvoke.java:92)
at com.kingdee.bos.service.job.wrapper.FacadeInvoke.localInvoke(FacadeInvoke.java:74)
at com.kingdee.bos.service.job.wrapper.FunctionWrapper.call(FunctionWrapper.java:203)
at com.kingdee.bos.service.job.wrapper.FunctionWrapper.invoke(FunctionWrapper.java:187)
at com.kingdee.bos.service.job.wrapper.FunctionWrapper.execute(FunctionWrapper.java:118)
at com.kingdee.bos.service.job.core.ThreadWorker.execute(ThreadWorker.java:179)
at com.kingdee.bos.service.job.core.ThreadWorker.run(ThreadWorker.java:120)
at java.lang.Thread.run(Thread.java:745)

经过排查，需要在Update语句前加/*dialect*/,因为SQL语句，必须符合KSQL语法。因此，在查询分析器可以跑的语句，在插件代码中，不一定能行。
现场可以在SQL语句的开始，增加方言标志，明确通知KSQL引擎，不要翻译，直接把原始语句传给数据库。

产品问题【EAS-开发】开发环境能正常执行的Update语句，在EAS里后台事务执行不了

产品问题 【EAS-开发】开发环境能正常执行的Update语句，在EAS里后台事务执行不了

恭喜您！

产品问题
【EAS-开发】开发环境能正常执行的Update语句，在EAS里后台事务执行不了

产品问题【EAS-开发】开发环境能正常执行的Update语句，在EAS里后台事务执行不了