上述代码功能为通过DBlink同步数据至EAS在同步完成后提示 ORA-03146: invalid buffer length for TTC field

如下为日志报错内容：

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

TOP 1000 TMP_SUBSELECT_ALIAS."ID"

FROM (SELECT

TOP 1000 "SALARYBILL".FID AS "ID"

FROM CT_RIZ_SalaryBill AS "SALARYBILL"

LEFT OUTER JOIN T_ORG_Company AS "DEPT"

ON "SALARYBILL".CFDeptID = "DEPT".FID

WHERE "DEPT".FName_l2 = ? AND "SALARYBILL".CFStatYear = ? AND "SALARYBILL".CFStatMonth = ? AND ("SALARYBILL".FControlUnitID = ? OR "SALARYBILL".FControlUnitID = ? OR "SALARYBILL".FControlUnitID = ?)

ORDER BY

"ID" ASC) AS TMP_SUBSELECT_ALIAS

Caused exception message is: ORA-03146: invalid buffer length for TTC field

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

TOP 1000 TMP_SUBSELECT_ALIAS."ID"

FROM (SELECT

TOP 1000 "SALARYBILL".FID AS "ID"

FROM CT_RIZ_SalaryBill AS "SALARYBILL"

LEFT OUTER JOIN T_ORG_Company AS "DEPT"

ON "SALARYBILL".CFDeptID = "DEPT".FID

WHERE "DEPT".FName_l2 = ? AND "SALARYBILL".CFStatYear = ? AND "SALARYBILL".CFStatMonth = ? AND ("SALARYBILL".FControlUnitID = ? OR "SALARYBILL".FControlUnitID = ? OR "SALARYBILL".FControlUnitID = ?)

ORDER BY

"ID" ASC) AS TMP_SUBSELECT_ALIAS

Caused exception message is: ORA-03146: invalid buffer length for TTC field

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

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

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

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

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:598)

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

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

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

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

at: com.kingdee.bos.ctrl.kdf.table.KDTBody.getRowHeight(KDTBody.java:166)

at: com.kingdee.bos.ctrl.kdf.table.KDTVertical.calculateLast(KDTVertical.java:510)

at: com.kingdee.bos.ctrl.kdf.table.KDTVertical.refresh(KDTVertical.java:481)

at: com.kingdee.bos.ctrl.kdf.table.KDTLayoutInfo.setFirst(KDTLayoutInfo.java:211)

at: com.kingdee.bos.ctrl.kdf.table.KDTLayoutInfo.invalidate(KDTLayoutInfo.java:255)

at: com.kingdee.bos.ctrl.kdf.table.KDTLayoutManager.invalidateVertical(KDTLayoutManager.java:192)

at: com.kingdee.bos.ctrl.kdf.table.KDTable.removeRows(KDTable.java:4363)

at: com.kingdee.bos.ctrl.kdf.table.KDTable.removeRows(KDTable.java:4335)

at: com.kingdee.eas.framework.client.ListUI.execQuery(ListUI.java:724)

at: com.kingdee.eas.framework.client.CoreBillListUI.execQuery(CoreBillListUI.java:411)

at: com.kingdee.eas.framework.client.ListUI.refresh(ListUI.java:702)

at: com.kingdee.eas.framework.client.CoreBillListUI.refresh(CoreBillListUI.java:985)

at: com.kingdee.eas.custom.rizhaogang.client.SalaryBillListUI.actionCatchData_actionPerformed(SalaryBillListUI.java:942)

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:597)

at: com.kingdee.bos.ui.face.ItemAction.reflectPerformAction(ItemAction.java:439)

at: com.kingdee.bos.ui.face.ItemAction.innerActionPerformed(ItemAction.java:397)

at: com.kingdee.eas.custom.rizhaogang.client.AbstractSalaryBillListUI$actionCatchData.actionPerformed(AbstractSalaryBillListUI.java:926)

at: com.kingdee.bos.appframework.client.servicebinding.ActionProxy.actionPerformedInvoke(ActionProxy.java:188)

at: com.kingdee.bos.appframework.client.servicebinding.ActionProxy.actionPerformed(ActionProxy.java:112)

at: javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)

at: com.kingdee.bos.ctrl.swing.KDWorkButton.fireActionPerformed(KDWorkButton.java:567)

at: javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)

at: javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)

at: javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)

at: javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)

at: java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)

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

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

at: com.kingdee.bos.ctrl.swing.KDWorkButton.processMouseEvent(KDWorkButton.java:898)

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

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

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

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

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

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

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

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

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

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

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

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

at: java.awt.EventQueue.access$000(EventQueue.java:84)

at: java.awt.EventQueue$1.run(EventQueue.java:602)

at: java.awt.EventQueue$1.run(EventQueue.java:600)

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

at: java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

at: java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)

at: java.awt.EventQueue$2.run(EventQueue.java:616)

at: java.awt.EventQueue$2.run(EventQueue.java:614)

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

at: java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

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

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

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

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

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

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:269)

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

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

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

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

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

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

TOP 1000 TMP_SUBSELECT_ALIAS."ID"

FROM (SELECT

TOP 1000 "SALARYBILL".FID AS "ID"

FROM CT_RIZ_SalaryBill AS "SALARYBILL"

LEFT OUTER JOIN T_ORG_Company AS "DEPT"

ON "SALARYBILL".CFDeptID = "DEPT".FID

WHERE "DEPT".FName_l2 = ? AND "SALARYBILL".CFStatYear = ? AND "SALARYBILL".CFStatMonth = ? AND ("SALARYBILL".FControlUnitID = ? OR "SALARYBILL".FControlUnitID = ? OR "SALARYBILL".FControlUnitID = ?)

ORDER BY

"ID" ASC) AS TMP_SUBSELECT_ALIAS

Caused exception message is: ORA-03146: invalid buffer length for TTC field

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

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

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

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

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:611)

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

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-03146: invalid buffer length for TTC field

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)

产品问题二开在刷新界面是提示数据库报错 ORA-03146: invalid buffer length for TTC fie

20 产品问题 二开在刷新界面是提示数据库报错 ORA-03146: invalid buffer length for TTC fie

恭喜您！

产品问题
二开在刷新界面是提示数据库报错 ORA-03146: invalid buffer length for TTC fie

20 产品问题二开在刷新界面是提示数据库报错 ORA-03146: invalid buffer length for TTC fie