请教，EAS 7.01升级补丁PT096302，出现服务器响应异常
EAS Cloud-知识分享
金蝶云社区-张迈特
张迈特
0人赞赏了该文章 964次浏览 未经作者许可，禁止转载编辑于2015年10月21日 09:36:06
打开权限管理-用户管理时，出现

。
错误信息：
“错误信息：列名 'FAdNumber' 无效。. The query sql is:SELECT
"USER".FID AS "ID",
"USER".FNumber AS "NUMBER",
"USER".FType AS "TYPE",
"USER".FName_l2 AS "NAME",
"CU".FName_l2 AS "CU.NAME",
"USERGROUP".FName_l2 AS "GROUP.NAME",
"SECURITY".FAlias_l2 AS "SECURITY.ALIAS",
"USER".FIsBizAdmin AS "BIZADMIN",
"USER".FEffectiveDate AS "EFFECTIVEDATE",
"USER".FInvalidationDate AS "INVALIDATIONDATE",
"USER".FPWEffectiveDate AS "PWEFFECTIVEDATE",
"USER".FForbidden AS "ISFORBIDDEN",
"USER".FIsLocked AS "ISLOCKED",
"USER".FIsDelete AS "ISDELETE",
"USER".FDescription_l2 AS "DESCRIPTION",
"DEFORGUNIT".FName_l2 AS "DEFORGUNIT.NAME",
"USER".FControlUnitID AS "CU.ID",
"USER".FAgentUser AS "AGENTUSER",
"USER".FLoginAuthorWay AS "LOGINAUTHORWAY",
"USER".FAdNumber AS "ADNUMBER"
FROM T_PM_User AS "USER"
LEFT OUTER JOIN T_PM_UserGroup AS "USERGROUP"
ON "USER".FGroupID = "USERGROUP".FID
LEFT OUTER JOIN T_PM_Security AS "SECURITY"
ON "USER".FSecurityId = "SECURITY".FID
INNER JOIN T_ORG_CtrlUnit AS "CU"
ON "USER".FControlUnitID = "CU".FID
LEFT OUTER JOIN T_ORG_BaseUnit AS "DEFORGUNIT"
ON "DEFORGUNIT".FID = "USER".FDefOrgUnitID
WHERE "USER".FID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ("USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1)
ORDER BY
"NUMBER" ASC
Caused exception message is: 列名 'FAdNumber' 无效。
错误详细堆栈信息：com.kingdee.bos.SQLDataException: 列名 'FAdNumber' 无效。. The query sql is:SELECT
"USER".FID AS "ID",
"USER".FNumber AS "NUMBER",
"USER".FType AS "TYPE",
"USER".FName_l2 AS "NAME",
"CU".FName_l2 AS "CU.NAME",
"USERGROUP".FName_l2 AS "GROUP.NAME",
"SECURITY".FAlias_l2 AS "SECURITY.ALIAS",
"USER".FIsBizAdmin AS "BIZADMIN",
"USER".FEffectiveDate AS "EFFECTIVEDATE",
"USER".FInvalidationDate AS "INVALIDATIONDATE",
"USER".FPWEffectiveDate AS "PWEFFECTIVEDATE",
"USER".FForbidden AS "ISFORBIDDEN",
"USER".FIsLocked AS "ISLOCKED",
"USER".FIsDelete AS "ISDELETE",
"USER".FDescription_l2 AS "DESCRIPTION",
"DEFORGUNIT".FName_l2 AS "DEFORGUNIT.NAME",
"USER".FControlUnitID AS "CU.ID",
"USER".FAgentUser AS "AGENTUSER",
"USER".FLoginAuthorWay AS "LOGINAUTHORWAY",
"USER".FAdNumber AS "ADNUMBER"
FROM T_PM_User AS "USER"
LEFT OUTER JOIN T_PM_UserGroup AS "USERGROUP"
ON "USER".FGroupID = "USERGROUP".FID
LEFT OUTER JOIN T_PM_Security AS "SECURITY"
ON "USER".FSecurityId = "SECURITY".FID
INNER JOIN T_ORG_CtrlUnit AS "CU"
ON "USER".FControlUnitID = "CU".FID
LEFT OUTER JOIN T_ORG_BaseUnit AS "DEFORGUNIT"
ON "DEFORGUNIT".FID = "USER".FDefOrgUnitID
WHERE "USER".FID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND ("USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1 OR "USER".FID = ? OR ("USER".FID IS NULL) AND ? = 1)
ORDER BY
"NUMBER" ASC
Caused exception message is: 列名 'FAdNumber' 无效。
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.getRowSetBySeqTableUseSqlCache(VirtualModeDataAccess.java:3671)
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.getRowSet(VirtualModeDataAccess.java:1200)
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.doAllQueryTask(VirtualModeDataAccess.java:2444)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.bos.ResponseInvocationHandler.invoke(ResponseInvocationHandler.java:193)
at $Proxy151.doAllQueryTask(Unknown Source)
at com.kingdee.bos.dao.query.QueryExecutor.doAllQueryTask(QueryExecutor.java:501)
at com.kingdee.eas.framework.app.ListUIHandler.requestData(ListUIHandler.java:464)
at com.kingdee.eas.framework.app.ListUIHandler._tableRequestData(ListUIHandler.java:362)
at com.kingdee.eas.framework.app.ListUIHandler.tableRequestData(ListUIHandler.java:356)
at com.kingdee.eas.framework.app.TreeDetailListUIHandler._queryTableData(TreeDetailListUIHandler.java:80)
at com.kingdee.eas.framework.app.TreeDetailListUIHandler._handleInit(TreeDetailListUIHandler.java:57)
at com.kingdee.eas.base.permission.app.UserListUIHandler._handleInit(UserListUIHandler.java:43)
at com.kingdee.eas.framework.app.ListUIHandler.handleInit(ListUIHandler.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.eas.framework.app.ItemActionUIHandler.actionPerformed(ItemActionUIHandler.java:44)
at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.eas.framework.app.ServiceHandlerFacadeControllerBean._Execute(ServiceHandlerFacadeControllerBean.java:46)
at com.kingdee.eas.framework.app.AbstractServiceHandlerFacadeControllerBean.Execute(AbstractServiceHandlerFacadeControllerBean.java:25)
at com.kingdee.eas.framework.ServiceHandlerFacade.Execute(ServiceHandlerFacade.java:50)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_framework_1_IServiceHandlerFacade.pi4(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_framework_1_IServiceHandlerFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:629)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:125)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:24)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:103)
Caused by: java.sql.SQLException: 列名 'FAdNumber' 无效。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
at com.kingdee.bos.sql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:395)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.bos.dao.query.server.BaseDataAccess.excuteSQL(BaseDataAccess.java:600)
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.getRowSetBySeqTableUseSqlCache(VirtualModeDataAccess.java:3621)
... 35 more
Caused by: java.sql.SQLException
java.sql.SQLException: 列名 'FAdNumber' 无效。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
at com.kingdee.bos.sql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:395)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.bos.dao.query.server.BaseDataAccess.excuteSQL(BaseDataAccess.java:600)
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.getRowSetBySeqTableUseSqlCache(VirtualModeDataAccess.java:3621)
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.getRowSet(VirtualModeDataAccess.java:1200)
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.doAllQueryTask(VirtualModeDataAccess.java:2444)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.bos.ResponseInvocationHandler.invoke(ResponseInvocationHandler.java:193)
at $Proxy151.doAllQueryTask(Unknown Source)
at com.kingdee.bos.dao.query.QueryExecutor.doAllQueryTask(QueryExecutor.java:501)
at com.kingdee.eas.framework.app.ListUIHandler.requestData(ListUIHandler.java:464)
at com.kingdee.eas.framework.app.ListUIHandler._tableRequestData(ListUIHandler.java:362)
at com.kingdee.eas.framework.app.ListUIHandler.tableRequestData(ListUIHandler.java:356)
at com.kingdee.eas.framework.app.TreeDetailListUIHandler._queryTableData(TreeDetailListUIHandler.java:80)
at com.kingdee.eas.framework.app.TreeDetailListUIHandler._handleInit(TreeDetailListUIHandler.java:57)
at com.kingdee.eas.base.permission.app.UserListUIHandler._handleInit(UserListUIHandler.java:43)
at com.kingdee.eas.framework.app.ListUIHandler.handleInit(ListUIHandler.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.eas.framework.app.ItemActionUIHandler.actionPerformed(ItemActionUIHandler.java:44)
at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kingdee.eas.framework.app.ServiceHandlerFacadeControllerBean._Execute(ServiceHandlerFacadeControllerBean.java:46)
at com.kingdee.eas.framework.app.AbstractServiceHandlerFacadeControllerBean.Execute(AbstractServiceHandlerFacadeControllerBean.java:25)
at com.kingdee.eas.framework.ServiceHandlerFacade.Execute(ServiceHandlerFacade.java:50)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_framework_1_IServiceHandlerFacade.pi4(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_framework_1_IServiceHandlerFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:629)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:125)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:24)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:103)
”。请教怎么处理？

1.jpg(25.61KB)

推荐阅读

安装EAS服务器报java io异常

各位同仁: 今天在安装金蝶EAS服务器时查看日志文件在最后一行报 Run SQL Tool 状态﹕错误 其它注释﹕错误 - java.io.FileNotFou …

    文章

    781

FAQ-weblogic，EAS服务器更新补 …

适用版本 通用 问题描述 EAS客户端日志client.log下面提示如下信息： java.io.FileNotFoundException:http://IP …

    文章

    948

系统检测到您的网络连接或服务器响应异常V3

【 Question 】 客户端无法登陆，系统检测到您的网络连接或服务器响应异常 [图片] 【 Analysis 】 1.发现用的是谷歌DNS:8.8.8.8， …

    文章

    1,093