在进行批量维护是添加新的子项在计算时显示错误

source:INSERT INTO T_ENG_BBEBOM (FID, FMASTERID, FUNITID, FBILLTYPE, FYIELDRATE, FISDEFAULT, FBASEUNITID, FCREATEDATE, FMODIFIERID, FCREATORID, FAPPROVERID, FFORBIDDERID, FMODIFYDATE, FUSEORGID, FFORBIDSTATUS, FDOCUMENTSTATUS, FCREATEORGID, FNUMBER, FBOMCATEGORY, FAPPROVEDATE, FFORBIDDATE, FMATERIALID, FBOMUSE, FGROUP, FBASEQTY, FQTY, FBOMSRC, FPLMBOMID, FCFGBOMID, FAUXPROPID, FMDLID, FCOMPUTEID) SELECT T1.FID, T1.FMASTERID, T1.FUNITID, T1.FBILLTYPE, T1.FYIELDRATE, T1.FISDEFAULT, T1.FBASEUNITID, T1.FCREATEDATE, T1.FMODIFIERID, T1.FCREATORID, T1.FAPPROVERID, T1.FFORBIDDERID, T1.FMODIFYDATE, T1.FUSEORGID, T1.FFORBIDSTATUS, T1.FDOCUMENTSTATUS, T1.FCREATEORGID, T1.FNUMBER, T1.FBOMCATEGORY, T1.FAPPROVEDATE, T1.FFORBIDDATE, T1.FMATERIALID, T1.FBOMUSE, T1.FGROUP, T1.FBASEQTY, T1.FQTY, T1.FBOMSRC, T1.FPLMBOMID, T1.FCFGBOMID, T1.FAUXPROPID, T1.FMDLID, 'f2010a3c-0122-942f-11ea-3119ae7818f1' FROM T_ENG_BOM T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID

INSERT INTO T_ENG_BBEBOM_L (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION) SELECT T1.FPKID, T1.FID, T1.FLOCALEID, T1.FNAME, T1.FDESCRIPTION FROM T_ENG_BOM_L T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID

INSERT INTO T_ENG_BBEBOMCHILD (FID, FENTRYID, FSEQ, FISMINISSUEQTY, FOPTQUEUE, FCHILDSUPPLYORGID, FRECORDDATA, FAUXPROPID, FOPERID, FBASEUNITID, FENTRYROWID, FUNITID, FOWNERID, FBOMID, FISGETSCRAP, FOFFSETTIME, FOWNERTYPEID, FDENOMINATOR, FNUMERATOR, FREPLACEGROUP, FBASEDENOMINATOR, FBASEFIXSCRAPQTY, FBASENUMERATOR, FOVERCONTROLMODE, FACTUALQTY, FQTY, FDOSAGETYPE, FMATERIALTYPE, FEFFECTDATE, FFIXSCRAPQTY, FPROCESSID, FMATERIALID, FISKEYCOMPONENT, FTIMEUNIT, FDISASSMBLERATE, FSCRAPRATE, FPOSITIONNO, FBACKFLUSHTYPE, FSUPPLYORG, FISSUETYPE, FEXPIREDATE, FALLOWOVER, FSTOCKLOCID, FSTOCKID, FBBESTATUS) SELECT T1.FID, T1.FENTRYID, T1.FSEQ, T1.FISMINISSUEQTY, T1.FOPTQUEUE, T1.FCHILDSUPPLYORGID, T1.FRECORDDATA, T1.FAUXPROPID, T1.FOPERID, T1.FBASEUNITID, T1.FENTRYROWID, T1.FUNITID, T1.FOWNERID, T1.FBOMID, T1.FISGETSCRAP, T1.FOFFSETTIME, T1.FOWNERTYPEID, T1.FDENOMINATOR, T1.FNUMERATOR, T1.FREPLACEGROUP, T1.FBASEDENOMINATOR, T1.FBASEFIXSCRAPQTY, T1.FBASENUMERATOR, T1.FOVERCONTROLMODE, T1.FACTUALQTY, T1.FQTY, T1.FDOSAGETYPE, T1.FMATERIALTYPE, T1.FEFFECTDATE, T1.FFIXSCRAPQTY, T1.FPROCESSID, T1.FMATERIALID, T1.FISKEYCOMPONENT, T1.FTIMEUNIT, T1.FDISASSMBLERATE, T1.FSCRAPRATE, T1.FPOSITIONNO, T1.FBACKFLUSHTYPE, T1.FSUPPLYORG, T1.FISSUETYPE, T1.FEXPIREDATE, T1.FALLOWOVER, T1.FSTOCKLOCID, T1.FSTOCKID, '1' FROM T_ENG_BOMCHILD T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID

INSERT INTO T_ENG_BBEBOMCHILD_A (FENTRYID, FID, FISSKIP, FBOMENTRYSRC, FPLMBOMENTRYID, FCHANGETYPE, FTREEENTRYIDBAK, FCFGFEATUREENTRYID, FCFGBOMENTRYID, FISCANREPLACE, FISMRPRUN, FECNCHGTYPE, FECNBILLNO, FCHANGETIME, FECNROWTYPE, FSUPPLYMODE, FECNCHGDATE, FISCANEDIT, FREPLACEPRIORITY, FREPLACETYPE, FREPLACEPOLICY, FISCANCHOOSE, FISKEYITEM, FMRPPRIORITY, FSUBSTITUTIONID, FSTENTRYID, FPARENTROWID, FROWID, FROWEXPANDTYPE) SELECT T1.FENTRYID, T1.FID, T1.FISSKIP, T1.FBOMENTRYSRC, T1.FPLMBOMENTRYID, T1.FCHANGETYPE, T1.FTREEENTRYIDBAK, T1.FCFGFEATUREENTRYID, T1.FCFGBOMENTRYID, T1.FISCANREPLACE, T1.FISMRPRUN, T1.FECNCHGTYPE, T1.FECNBILLNO, T1.FCHANGETIME, T1.FECNROWTYPE, T1.FSUPPLYMODE, T1.FECNCHGDATE, T1.FISCANEDIT, T1.FREPLACEPRIORITY, T1.FREPLACETYPE, T1.FREPLACEPOLICY, T1.FISCANCHOOSE, T1.FISKEYITEM, T1.FMRPPRIORITY, T1.FSUBSTITUTIONID, T1.FSTENTRYID, T1.FPARENTROWID, T1.FROWID, T1.FROWEXPANDTYPE FROM T_ENG_BOMCHILD_A T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID

INSERT INTO T_ENG_BBEBOMCHILD_L (FPKID, FENTRYID, FLOCALEID, FMEMO) SELECT T1.FPKID, T1.FENTRYID, T1.FLOCALEID, T1.FMEMO FROM T_ENG_BOMCHILD_L T1 INNER JOIN T_ENG_BOMCHILD T2 ON T1.FENTRYID = T2.FENTRYID INNER JOIN @FID_udt1 TMPB ON T2.FID = TMPB.FID

INSERT INTO T_ENG_BBEBOMCHILDLOTBASEDQTY (FENTRYID, FDETAILID, FSEQ, FSCRAPRATE, FNOTE, FFIXSCRAPQTY, FUNITID, FDENOMINATOR, FNUMERATOR, FENDQTY, FMATERIALID, FSTARTQTY, FBASESTARTQTY, FBASENUMERATOR, FBASEUNITID, FBASEDENOMINATOR, FBASEFIXSCRAPQTY, FBASEENDQTY) SELECT T1.FENTRYID, T1.FDETAILID, T1.FSEQ, T1.FSCRAPRATE, T1.FNOTE, T1.FFIXSCRAPQTY, T1.FUNITID, T1.FDENOMINATOR, T1.FNUMERATOR, T1.FENDQTY, T1.FMATERIALID, T1.FSTARTQTY, T1.FBASESTARTQTY, T1.FBASENUMERATOR, T1.FBASEUNITID, T1.FBASEDENOMINATOR, T1.FBASEFIXSCRAPQTY, T1.FBASEENDQTY FROM T_ENG_BOMCHILDLOTBASEDQTY T1 INNER JOIN T_ENG_BOMCHILD T2 ON T1.FENTRYID = T2.FENTRYID INNER JOIN @FID_udt1 TMPB ON T2.FID = TMPB.FID

INSERT INTO T_ENG_BBEBOMCOBY (FID, FENTRYID, FSEQ, FISBACKFLUSH, FBOMID, FOUTPUTOPTQUEUE, FAUXPROPID, FBASEQTY, FNOTE, FEXPIREDATE, FUNITID, FTASKID, FBASEUNITID, FEFFECTDATE, FMATERIALID, FPPROCESSID, FCOSTRATE, FQTY, FCOBYTYPE, FBBESTATUS) SELECT T1.FID, T1.FENTRYID, T1.FSEQ, T1.FISBACKFLUSH, T1.FBOMID, T1.FOUTPUTOPTQUEUE, T1.FAUXPROPID, T1.FBASEQTY, T1.FNOTE, T1.FEXPIREDATE, T1.FUNITID, T1.FTASKID, T1.FBASEUNITID, T1.FEFFECTDATE, T1.FMATERIALID, T1.FPPROCESSID, T1.FCOSTRATE, T1.FQTY, T1.FCOBYTYPE, '1' FROM T_ENG_BOMCOBY T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID

INSERT INTO T_ENG_BBEBOMBOPENTRY (FID, FENTRYID, FSEQ, FPRODUCTLINE, FREPLACEGROUPBOP, FBOPBASEUNITID, FBOPDENOMINATOR, FBOPNUMERATOR, FTREEENTRYID, FBASEBOPDENOMINATOR, FBASEBOPNUMERATOR, FBOPDOSAGETYPE, FBOPMATERIALID, FPRDLINELOCID, FBOPUNITID) SELECT T1.FID, T1.FENTRYID, T1.FSEQ, T1.FPRODUCTLINE, T1.FREPLACEGROUPBOP, T1.FBOPBASEUNITID, T1.FBOPDENOMINATOR, T1.FBOPNUMERATOR, T1.FTREEENTRYID, T1.FBASEBOPDENOMINATOR, T1.FBASEBOPNUMERATOR, T1.FBOPDOSAGETYPE, T1.FBOPMATERIALID, T1.FPRDLINELOCID, T1.FBOPUNITID FROM T_ENG_BOMBOPENTRY T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID

message:违反了 PRIMARY KEY 约束“PK_ENG_BBEBOMCHILD”。不能在对象“dbo.T_ENG_BBEBOMCHILD”中插入重复键。重复键值为 (661514)。

违反了 PRIMARY KEY 约束“PK_ENG_BBEBOMCHILD_A”。不能在对象“dbo.T_ENG_BBEBOMCHILD_A”中插入重复键。重复键值为 (661514)。

语句已终止。

stacktrace:

Server stack trace:

在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)

在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)

在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList)

Exception rethrown at [0]:

在 Kingdee.K3.MFG.ENG.App.Core.BomBatchEditService.RunSimulationBom(Context ctx, DynamicObject editDataObject, BomBatchEditOption option)

在 Kingdee.K3.MFG.ServiceHelper.ENG.BomBatchEditServiceHelper.RunSimulationBom(Context ctx, DynamicObject editDataObject, BomBatchEditOption option)

在 Kingdee.K3.MFG.ENG.Business.PlugIn.DynamicForm.WizardForm.BomBatchEditWizardPlugIn.RunSimulationBom()

在 System.Threading.Tasks.Task.Execute()

inner exception:

source:.Net SqlClient Data Provider

message:违反了 PRIMARY KEY 约束“PK_ENG_BBEBOMCHILD”。不能在对象“dbo.T_ENG_BBEBOMCHILD”中插入重复键。重复键值为 (661514)。

违反了 PRIMARY KEY 约束“PK_ENG_BBEBOMCHILD_A”。不能在对象“dbo.T_ENG_BBEBOMCHILD_A”中插入重复键。重复键值为 (661514)。

语句已终止。

stacktrace: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)

QQ图片20200107150335.png

请问如何解决？

产品问题物料清单批量维护显示计算错误

产品问题 物料清单批量维护显示计算错误

恭喜您！

产品问题
物料清单批量维护显示计算错误

产品问题物料清单批量维护显示计算错误