部署到测试环境了，但是一打开就显示这个。已经查清楚了TMP_SUBSELECT_ALIAS、CT_SUP_Supplierxxxg 这两个表在sql查不到，但是我本地是正常的，这种要怎么处理。来个大佬吧，就差最后这一步就能上线正式环境了。

错误信息：com.kingdee.bos.BOSException: select key ID error. selectSQL is : SELECT

TOP 10000 TMP_SUBSELECT_ALIAS."ID"

FROM (SELECT

TOP 10000 "SUPPLIERXXXG".FID AS "ID"

FROM CT_SUP_Supplierxxxg AS "SUPPLIERXXXG"

WHERE ("SUPPLIERXXXG".FControlUnitID = ? OR "SUPPLIERXXXG".FControlUnitID = ? OR "SUPPLIERXXXG".FControlUnitID = ?) AND (("SUPPLIERXXXG".FControlUnitID IS NULL) OR "SUPPLIERXXXG".FControlUnitID IN (SELECT

"UNIT".FID

FROM T_ORG_Structure AS "ORGSTRUCTURE"

LEFT OUTER JOIN T_ORG_BaseUnit AS "UNIT"

ON "ORGSTRUCTURE".FUnitId = "UNIT".FID

LEFT OUTER JOIN T_ORG_Tree AS "TREE"

ON "ORGSTRUCTURE".FTreeId = "TREE".FID

LEFT OUTER JOIN T_ORG_OUPartFI AS "PARTFI"

ON "UNIT".FPartFIID = "PARTFI".FID

WHERE ("UNIT".FLongNumber = 'clr' OR ("UNIT".FLongNumber LIKE 'clr!%')) AND "ORGSTRUCTURE".FUnitId IN (SELECT

funitid

FROM t_org_oupartfi

WHERE FIsSealUp = 0) AND "PARTFI".FIsBizUnit = 1 AND "ORGSTRUCTURE".FUnitId IN (SELECT

forgid

FROM t_pm_orgrange

WHERE fuserid = 'kiWz9H+xRxez8C9NSe3zPhO33n8=' AND ftype = 10)))

ORDER BY

"ID" ASC) AS TMP_SUBSELECT_ALIAS

Caused exception message is: ORA-00942: 表或视图不存在

错误详细堆栈信息：java.lang.RuntimeException: com.kingdee.bos.BOSException: select key ID error. selectSQL is : SELECT

TOP 10000 TMP_SUBSELECT_ALIAS."ID"

FROM (SELECT

TOP 10000 "SUPPLIERXXXG".FID AS "ID"

FROM CT_SUP_Supplierxxxg AS "SUPPLIERXXXG"

WHERE ("SUPPLIERXXXG".FControlUnitID = ? OR "SUPPLIERXXXG".FControlUnitID = ? OR "SUPPLIERXXXG".FControlUnitID = ?) AND (("SUPPLIERXXXG".FControlUnitID IS NULL) OR "SUPPLIERXXXG".FControlUnitID IN (SELECT

"UNIT".FID

FROM T_ORG_Structure AS "ORGSTRUCTURE"

LEFT OUTER JOIN T_ORG_BaseUnit AS "UNIT"

ON "ORGSTRUCTURE".FUnitId = "UNIT".FID

LEFT OUTER JOIN T_ORG_Tree AS "TREE"

ON "ORGSTRUCTURE".FTreeId = "TREE".FID

LEFT OUTER JOIN T_ORG_OUPartFI AS "PARTFI"

ON "UNIT".FPartFIID = "PARTFI".FID

WHERE ("UNIT".FLongNumber = 'clr' OR ("UNIT".FLongNumber LIKE 'clr!%')) AND "ORGSTRUCTURE".FUnitId IN (SELECT

funitid

FROM t_org_oupartfi

WHERE FIsSealUp = 0) AND "PARTFI".FIsBizUnit = 1 AND "ORGSTRUCTURE".FUnitId IN (SELECT

forgid

FROM t_pm_orgrange

WHERE fuserid = 'kiWz9H+xRxez8C9NSe3zPhO33n8=' AND ftype = 10)))

ORDER BY

"ID" ASC) AS TMP_SUBSELECT_ALIAS

Caused exception message is: ORA-00942: 表或视图不存在

at: com.kingdee.eas.framework.client.ListUI.fillFirstData(ListUI.java:3108)

at: com.kingdee.eas.framework.client.ListUI.getDataFirsetTime(ListUI.java:2970)

at: com.kingdee.eas.framework.client.ListUI.tblMain_doRequestRowSetForHasQueryPK(ListUI.java:2849)

at: com.kingdee.eas.framework.client.ListUI.tblMain_doRequestRowSet(ListUI.java:2736)

at: com.kingdee.eas.framework.client.CoreBillListUI.tblMain_doRequestRowSet(CoreBillListUI.java:337)

at: com.kingdee.eas.framework.client.AbstractListUI$2.doRequestRowSet(AbstractListUI.java:332)

at: com.kingdee.bos.ctrl.kdf.data.impl.DataSetWrapperFactory.fireRequestRowSet(DataSetWrapperFactory.java:257)

at: com.kingdee.bos.ctrl.kdf.data.impl.DataSetWrapperFactory.requestData(DataSetWrapperFactory.java:233)

at: com.kingdee.bos.ctrl.kdf.table.KDTDataRequestManager.requestData(KDTDataRequestManager.java:597)

at: com.kingdee.bos.ctrl.kdf.table.KDTDataRequestManager.doDataRequestPage(KDTDataRequestManager.java:515)

at: com.kingdee.bos.ctrl.kdf.table.KDTDataRequestManager.doDataRequest2(KDTDataRequestManager.java:420)

at: com.kingdee.bos.ctrl.kdf.table.KDTDataRequestManager.doDataRequest(KDTDataRequestManager.java:331)

at: com.kingdee.bos.ctrl.kdf.table.KDTBody.getRow(KDTBody.java:145)

at: com.kingdee.bos.ctrl.kdf.table.KDTable.getRow(KDTable.java:4421)

at: com.kingdee.eas.framework.client.ListUI.selectFirstRow(ListUI.java:6630)

at: com.kingdee.eas.framework.client.ListUI.onShow(ListUI.java:6571)

at: com.kingdee.eas.framework.client.CoreBillListUI.onShow(CoreBillListUI.java:2340)

at: com.kingdee.eas.framework.client.CoreUI.doLayout(CoreUI.java:3588)

at: java.awt.Container.validateTree(Container.java:1695)

at: java.awt.Container.validateTree(Container.java:1704)

at: java.awt.Container.validate(Container.java:1630)

at: com.kingdee.eas.base.uiframe.client.BodyUI.setCurTabIndex(BodyUI.java:154)

at: com.kingdee.eas.base.uiframe.client.UIObjectManager.changeTab(UIObjectManager.java:120)

at: com.kingdee.eas.base.uiframe.client.UIObjectManager.changeTab(UIObjectManager.java:128)

at: com.kingdee.eas.base.uiframe.client.UINewTab.show(UINewTab.java:42)

at: com.kingdee.eas.base.uiframe.client.UIShowHelper.showUI(UIShowHelper.java:48)

at: com.kingdee.eas.base.uiframe.client.UIShowHelper.showUI(UIShowHelper.java:24)

at: com.kingdee.eas.base.uiframe.client.LeafMenuCellPane.performDblclick(LeafMenuCellPane.java:220)

at: com.kingdee.eas.base.uiframe.client.LeafMenuCellPane.access$500(LeafMenuCellPane.java:37)

at: com.kingdee.eas.base.uiframe.client.LeafMenuCellPane$TopLabelMouseAdapter.mouseClicked(LeafMenuCellPane.java:89)

at: java.awt.Component.processMouseEvent(Component.java:6536)

at: javax.swing.JComponent.processMouseEvent(JComponent.java:3324)

at: java.awt.Component.processEvent(Component.java:6298)

at: java.awt.Container.processEvent(Container.java:2236)

at: java.awt.Component.dispatchEventImpl(Component.java:4889)

at: java.awt.Container.dispatchEventImpl(Container.java:2294)

at: java.awt.Component.dispatchEvent(Component.java:4711)

at: java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)

at: java.awt.LightweightDispatcher.processMouseEvent(Container.java:4534)

at: java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)

at: java.awt.Container.dispatchEventImpl(Container.java:2280)

at: java.awt.Window.dispatchEventImpl(Window.java:2746)

at: java.awt.Component.dispatchEvent(Component.java:4711)

at: java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)

at: java.awt.EventQueue.access$500(EventQueue.java:97)

at: java.awt.EventQueue$3.run(EventQueue.java:709)

at: java.awt.EventQueue$3.run(EventQueue.java:703)

at: java.security.AccessController.doPrivileged(Native Method)

at: java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)

at: java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)

at: java.awt.EventQueue$4.run(EventQueue.java:731)

at: java.awt.EventQueue$4.run(EventQueue.java:729)

at: java.security.AccessController.doPrivileged(Native Method)

at: java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)

at: java.awt.EventQueue.dispatchEvent(EventQueue.java:728)

at: com.kingdee.bos.invokecounter.RPCLogEventQueue.dispatchEvent(RPCLogEventQueue.java:176)

at: sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)

at: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at: java.lang.reflect.Method.invoke(Method.java:498)

at: com.kingdee.eas.client.recorder.UserInputEventQueue.myDispatchEvent(UserInputEventQueue.java:126)

at: com.kingdee.eas.client.recorder.UserInputEventQueue.dispatchEvent(UserInputEventQueue.java:59)

at: java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)

at: java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

at: java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)

at: java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

at: java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

at: java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

com.kingdee.bos.BOSException: select key ID error. selectSQL is : SELECT

TOP 10000 TMP_SUBSELECT_ALIAS."ID"

FROM (SELECT

TOP 10000 "SUPPLIERXXXG".FID AS "ID"

FROM CT_SUP_Supplierxxxg AS "SUPPLIERXXXG"

WHERE ("SUPPLIERXXXG".FControlUnitID = ? OR "SUPPLIERXXXG".FControlUnitID = ? OR "SUPPLIERXXXG".FControlUnitID = ?) AND (("SUPPLIERXXXG".FControlUnitID IS NULL) OR "SUPPLIERXXXG".FControlUnitID IN (SELECT

"UNIT".FID

FROM T_ORG_Structure AS "ORGSTRUCTURE"

LEFT OUTER JOIN T_ORG_BaseUnit AS "UNIT"

ON "ORGSTRUCTURE".FUnitId = "UNIT".FID

LEFT OUTER JOIN T_ORG_Tree AS "TREE"

ON "ORGSTRUCTURE".FTreeId = "TREE".FID

LEFT OUTER JOIN T_ORG_OUPartFI AS "PARTFI"

ON "UNIT".FPartFIID = "PARTFI".FID

WHERE ("UNIT".FLongNumber = 'clr' OR ("UNIT".FLongNumber LIKE 'clr!%')) AND "ORGSTRUCTURE".FUnitId IN (SELECT

funitid

FROM t_org_oupartfi

WHERE FIsSealUp = 0) AND "PARTFI".FIsBizUnit = 1 AND "ORGSTRUCTURE".FUnitId IN (SELECT

forgid

FROM t_pm_orgrange

WHERE fuserid = 'kiWz9H+xRxez8C9NSe3zPhO33n8=' AND ftype = 10)))

ORDER BY

"ID" ASC) AS TMP_SUBSELECT_ALIAS

Caused exception message is: ORA-00942: 表或视图不存在

at: com.kingdee.bos.dao.query.server.SeqTableDiskCacheAcuquire.acquire(SeqTableDiskCacheAcuquire.java:232)

at: com.kingdee.bos.dao.query.server.SeqTableManager.acquire(SeqTableManager.java:123)

at: com.kingdee.bos.dao.query.server.VirtualModeDataAccess.innerOpenQuery(VirtualModeDataAccess.java:330)

at: com.kingdee.bos.dao.query.server.VirtualModeDataAccess.doAllQueryTask(VirtualModeDataAccess.java:2156)

at: rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_IVirtualModeDataAccess.pi20(Unknown Source)

at: rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_IVirtualModeDataAccess.processInvoke(Unknown Source)

at: com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)

at: com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:618)

at: com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:125)

at: com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)

at: java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at: java.util.concurrent.FutureTask.run(FutureTask.java:266)

at: com.kingdee.bos.rpc.impl.ThreadPoolExecutorReImpl.runWorker(ThreadPoolExecutorReImpl.java:1152)

at: com.kingdee.bos.rpc.impl.ThreadPoolExecutorReImpl$Worker.run(ThreadPoolExecutorReImpl.java:622)

at: java.lang.Thread.run(Thread.java:745)

java.sql.SQLException: ORA-00942: 表或视图不存在

at: oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

at: oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

at: oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)

at: oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

at: oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

at: oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

at: oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)

at: oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:879)

at: oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(Unknown Source)

at: oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Unknown Source)

at: oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3608)

at: oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3652)

at: oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1207)

at: com.kingdee.bos.sql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:322)

at: com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:61)

at: com.kingdee.bos.dao.query.server.SeqTableDiskCacheAcuquire.acquire(SeqTableDiskCacheAcuquire.java:116)