MRP运算报错，运行了3个多小时
tengzxd
969次浏览
编辑于2018年01月08日 16:53:50
版本：V7.0+12月1日补丁
环境：应用服务器与数据服务器分开部署，数据服务器：Linux+Oracle
问题：跑MRP报错
source:INSERT INTO T_MRP_MATERIALDATA_C (FID, FENTRYID, FCSDSCRAP, FCSDSTOCK, FCSDYIELDRATE, FCSDSAFESTOCK, FCSDWILLQTY, FCSDORDERSTRATEGY, FPLANMODE, FALLOWPARTAHEAD, FALLOWSTOCKAHEADDAY, FALLOWPARTDELAY, FALLOWSTOCKDELAYDAY, FAHEADGRACEDAYS, FDELAYGRACEDAYS, FISPRODUCTLINE, FCHECKPRODUCT, FCHECKINCOMING, FMAXPOQTY, FSTOREUNITID, FPLANSAFESTOCKQTY, FCONFIGTYPE, FPLANBATCHSPLITQTY, FPLANINTERVALSDAYS, FMAXSTOCK, FREORDERGOOD, FECONREORDERQTY) SELECT FID, FENTRYID, FCSDSCRAP, FCSDSTOCK, FCSDYIELDRATE, FCSDSAFESTOCK, FCSDWILLQTY, FCSDORDERSTRATEGY, FPLANMODE, FALLOWPARTAHEAD, FALLOWSTOCKAHEADDAY, FALLOWPARTDELAY, FALLOWSTOCKDELAYDAY, FAHEADGRACEDAYS, FDELAYGRACEDAYS, FISPRODUCTLINE, FCHECKPRODUCT, FCHECKINCOMING, FMAXPOQTY, FSTOREUNITID, FPLANSAFESTOCKQTY, FCONFIGTYPE, FPLANBATCHSPLITQTY, FPLANINTERVALSDAYS, FMAXSTOCK, FREORDERGOOD, FECONREORDERQTY FROM T_MRP_MATERIALDATA1_Cmessage:ORA-03114: not connected to ORACLEstacktrace:Server stack trace: at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam) at Kingdee.BOS.App.Data.Oracle.OracleDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout) at Kingdee.BOS.App.Data.DBUtils.ExecuteBatchWithTime(Context ctx, List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Kingdee.BOS.Contracts.IDBService.ExecuteBatchWithTime(Context ctx, List`1 sqlArray, Int32 commandTimeout) at Kingdee.K3.MFG.PLN.App.MrpModel.LogicUnitImpl.Mrp.CompleteMrpLogicUnit.MrpLogInfoBak() at Kingdee.K3.MFG.PLN.App.MrpModel.LogicUnitImpl.Mrp.CompleteMrpLogicUnit.OnExecuteLogicUnit() at Kingdee.K3.MFG.PLN.App.MrpModel.AbstractMrpLogicUnit.Execute() at Kingdee.K3.MFG.PLN.App.Core.MrpComputeService.RunMrp(Context ctx, Dynam
环境：应用服务器与数据服务器分开部署，数据服务器：Linux+Oracle
问题：跑MRP报错
source:INSERT INTO T_MRP_MATERIALDATA_C (FID, FENTRYID, FCSDSCRAP, FCSDSTOCK, FCSDYIELDRATE, FCSDSAFESTOCK, FCSDWILLQTY, FCSDORDERSTRATEGY, FPLANMODE, FALLOWPARTAHEAD, FALLOWSTOCKAHEADDAY, FALLOWPARTDELAY, FALLOWSTOCKDELAYDAY, FAHEADGRACEDAYS, FDELAYGRACEDAYS, FISPRODUCTLINE, FCHECKPRODUCT, FCHECKINCOMING, FMAXPOQTY, FSTOREUNITID, FPLANSAFESTOCKQTY, FCONFIGTYPE, FPLANBATCHSPLITQTY, FPLANINTERVALSDAYS, FMAXSTOCK, FREORDERGOOD, FECONREORDERQTY) SELECT FID, FENTRYID, FCSDSCRAP, FCSDSTOCK, FCSDYIELDRATE, FCSDSAFESTOCK, FCSDWILLQTY, FCSDORDERSTRATEGY, FPLANMODE, FALLOWPARTAHEAD, FALLOWSTOCKAHEADDAY, FALLOWPARTDELAY, FALLOWSTOCKDELAYDAY, FAHEADGRACEDAYS, FDELAYGRACEDAYS, FISPRODUCTLINE, FCHECKPRODUCT, FCHECKINCOMING, FMAXPOQTY, FSTOREUNITID, FPLANSAFESTOCKQTY, FCONFIGTYPE, FPLANBATCHSPLITQTY, FPLANINTERVALSDAYS, FMAXSTOCK, FREORDERGOOD, FECONREORDERQTY FROM T_MRP_MATERIALDATA1_Cmessage:ORA-03114: not connected to ORACLEstacktrace:Server stack trace: at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam) at Kingdee.BOS.App.Data.Oracle.OracleDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout) at Kingdee.BOS.App.Data.DBUtils.ExecuteBatchWithTime(Context ctx, List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Kingdee.BOS.Contracts.IDBService.ExecuteBatchWithTime(Context ctx, List`1 sqlArray, Int32 commandTimeout) at Kingdee.K3.MFG.PLN.App.MrpModel.LogicUnitImpl.Mrp.CompleteMrpLogicUnit.MrpLogInfoBak() at Kingdee.K3.MFG.PLN.App.MrpModel.LogicUnitImpl.Mrp.CompleteMrpLogicUnit.OnExecuteLogicUnit() at Kingdee.K3.MFG.PLN.App.MrpModel.AbstractMrpLogicUnit.Execute() at Kingdee.K3.MFG.PLN.App.Core.MrpComputeService.RunMrp(Context ctx, Dynam