MRP运算报错,运行了3个多小时
1,016次浏览
编辑于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
您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!
请选择打赏金币数 *
10金币20金币30金币40金币50金币60金币
可用金币: 0