TIM图片20180831143217.png

source:INSERT INTO T_ENG_BBEBOM (FID, FMASTERID, FDOCUMENTSTATUS, FYIELDRATE, FBILLTYPE, FBASEUNITID, FISDEFAULT, FUNITID, FFORBIDSTATUS, FNUMBER, FCREATEORGID, FUSEORGID, FCREATORID, FMODIFIERID, FCREATEDATE, FMODIFYDATE, FFORBIDDERID, FAPPROVERID, FFORBIDDATE, FAPPROVEDATE, FBOMCATEGORY, FBOMUSE, FMATERIALID, F_PAEZ_DECIMAL, FMDLID, FCFGBOMID, FQTY, FBASEQTY, FGROUP, FPLMBOMID, FBOMSRC, FAUXPROPID, FCOMPUTEID) SELECT T1.FID, T1.FMASTERID, T1.FDOCUMENTSTATUS, T1.FYIELDRATE, T1.FBILLTYPE, T1.FBASEUNITID, T1.FISDEFAULT, T1.FUNITID, T1.FFORBIDSTATUS, T1.FNUMBER, T1.FCREATEORGID, T1.FUSEORGID, T1.FCREATORID, T1.FMODIFIERID, T1.FCREATEDATE, T1.FMODIFYDATE, T1.FFORBIDDERID, T1.FAPPROVERID, T1.FFORBIDDATE, T1.FAPPROVEDATE, T1.FBOMCATEGORY, T1.FBOMUSE, T1.FMATERIALID, T1.F_PAEZ_DECIMAL, T1.FMDLID, T1.FCFGBOMID, T1.FQTY, T1.FBASEQTY, T1.FGROUP, T1.FPLMBOMID, T1.FBOMSRC, T1.FAUXPROPID, '1418776e-1f20-8e7c-11e8-ace74fc9c16b' 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, FCHILDSUPPLYORGID, FOPTQUEUE, FISMINISSUEQTY, FRECORDDATA, FBOMID, FNUMERATOR, FDENOMINATOR, FOWNERTYPEID, FOWNERID, FOPERID, FAUXPROPID, FUNITID, FENTRYROWID, FBASEUNITID, FBASEFIXSCRAPQTY, FBASEDENOMINATOR, FQTY, FACTUALQTY, FOVERCONTROLMODE, FREPLACEGROUP, FBASENUMERATOR, F_PAEZ_QTY, FISGETSCRAP, FOFFSETTIME, FDISASSMBLERATE, FSCRAPRATE, FMATERIALTYPE, FDOSAGETYPE, FPROCESSID, FFIXSCRAPQTY, FEFFECTDATE, FISSUETYPE, FSUPPLYORG, FSTOCKID, FSTOCKLOCID, FALLOWOVER, FBACKFLUSHTYPE, FTIMEUNIT, FISKEYCOMPONENT, FMATERIALID, FPOSITIONNO, FEXPIREDATE, FBBESTATUS) SELECT T1.FID, T1.FENTRYID, T1.FSEQ, T1.FCHILDSUPPLYORGID, T1.FOPTQUEUE, T1.FISMINISSUEQTY, T1.FRECORDDATA, T1.FBOMID, T1.FNUMERATOR, T1.FDENOMINATOR, T1.FOWNERTYPEID, T1.FOWNERID, T1.FOPERID, T1.FAUXPROPID, T1.FUNITID, T1.FENTRYROWID, T1.FBASEUNITID, T1.FBASEFIXSCRAPQTY, T1.FBASEDENOMINATOR, T1.FQTY, T1.FACTUALQTY, T1.FOVERCONTROLMODE, T1.FREPLACEGROUP, T1.FBASENUMERATOR, T1.F_PAEZ_QTY, T1.FISGETSCRAP, T1.FOFFSETTIME, T1.FDISASSMBLERATE, T1.FSCRAPRATE, T1.FMATERIALTYPE, T1.FDOSAGETYPE, T1.FPROCESSID, T1.FFIXSCRAPQTY, T1.FEFFECTDATE, T1.FISSUETYPE, T1.FSUPPLYORG, T1.FSTOCKID, T1.FSTOCKLOCID, T1.FALLOWOVER, T1.FBACKFLUSHTYPE, T1.FTIMEUNIT, T1.FISKEYCOMPONENT, T1.FMATERIALID, T1.FPOSITIONNO, T1.FEXPIREDATE, '1' FROM T_ENG_BOMCHILD T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID
INSERT INTO T_ENG_BBEBOMCHILD_A (FENTRYID, FID, FCFGBOMENTRYID, FCFGFEATUREENTRYID, FPLMBOMENTRYID, FBOMENTRYSRC, FISSKIP, FTREEENTRYIDBAK, FISCANREPLACE, FCHANGETIME, FECNBILLNO, FECNCHGTYPE, FECNCHGDATE, FSUPPLYMODE, FECNROWTYPE, FCHANGETYPE, FISCANEDIT, FISKEYITEM, FISCANCHOOSE, FREPLACEPOLICY, FREPLACETYPE, FREPLACEPRIORITY, FMRPPRIORITY, FISMRPRUN, FPARENTROWID, FROWEXPANDTYPE, FROWID) SELECT T1.FENTRYID, T1.FID, T1.FCFGBOMENTRYID, T1.FCFGFEATUREENTRYID, T1.FPLMBOMENTRYID, T1.FBOMENTRYSRC, T1.FISSKIP, T1.FTREEENTRYIDBAK, T1.FISCANREPLACE, T1.FCHANGETIME, T1.FECNBILLNO, T1.FECNCHGTYPE, T1.FECNCHGDATE, T1.FSUPPLYMODE, T1.FECNROWTYPE, T1.FCHANGETYPE, T1.FISCANEDIT, T1.FISKEYITEM, T1.FISCANCHOOSE, T1.FREPLACEPOLICY, T1.FREPLACETYPE, T1.FREPLACEPRIORITY, T1.FMRPPRIORITY, T1.FISMRPRUN, T1.FPARENTROWID, T1.FROWEXPANDTYPE, T1.FROWID 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, FMATERIALID, FSTARTQTY, FENDQTY, FFIXSCRAPQTY, FNOTE, FSCRAPRATE, FNUMERATOR, FDENOMINATOR, FUNITID, FBASEUNITID, FBASENUMERATOR, FBASESTARTQTY, FBASEENDQTY, FBASEFIXSCRAPQTY, FBASEDENOMINATOR) SELECT T1.FENTRYID, T1.FDETAILID, T1.FSEQ, T1.FMATERIALID, T1.FSTARTQTY, T1.FENDQTY, T1.FFIXSCRAPQTY, T1.FNOTE, T1.FSCRAPRATE, T1.FNUMERATOR, T1.FDENOMINATOR, T1.FUNITID, T1.FBASEUNITID, T1.FBASENUMERATOR, T1.FBASESTARTQTY, T1.FBASEENDQTY, T1.FBASEFIXSCRAPQTY, T1.FBASEDENOMINATOR 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, FBASEQTY, FBASEUNITID, FTASKID, FUNITID, FAUXPROPID, FOUTPUTOPTQUEUE, FBOMID, FISBACKFLUSH, FNOTE, FEXPIREDATE, FEFFECTDATE, FPPROCESSID, FCOBYTYPE, FMATERIALID, FQTY, FCOSTRATE, FBBESTATUS) SELECT T1.FID, T1.FENTRYID, T1.FSEQ, T1.FBASEQTY, T1.FBASEUNITID, T1.FTASKID, T1.FUNITID, T1.FAUXPROPID, T1.FOUTPUTOPTQUEUE, T1.FBOMID, T1.FISBACKFLUSH, T1.FNOTE, T1.FEXPIREDATE, T1.FEFFECTDATE, T1.FPPROCESSID, T1.FCOBYTYPE, T1.FMATERIALID, T1.FQTY, T1.FCOSTRATE, '1' FROM T_ENG_BOMCOBY T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FID
INSERT INTO T_ENG_BBEBOMBOPENTRY (FID, FENTRYID, FSEQ, FREPLACEGROUPBOP, FPRODUCTLINE, FBOPMATERIALID, FBOPUNITID, FBOPDOSAGETYPE, FBOPNUMERATOR, FBOPDENOMINATOR, FBOPBASEUNITID, FBASEBOPNUMERATOR, FPRDLINELOCID, FBASEBOPDENOMINATOR, FTREEENTRYID) SELECT T1.FID, T1.FENTRYID, T1.FSEQ, T1.FREPLACEGROUPBOP, T1.FPRODUCTLINE, T1.FBOPMATERIALID, T1.FBOPUNITID, T1.FBOPDOSAGETYPE, T1.FBOPNUMERATOR, T1.FBOPDENOMINATOR, T1.FBOPBASEUNITID, T1.FBASEBOPNUMERATOR, T1.FPRDLINELOCID, T1.FBASEBOPDENOMINATOR, T1.FTREEENTRYID 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' 中插入重复键。
违反了 PRIMARY KEY 约束 'PK_ENG_BBEBOMCHILD_A'。不能在对象 'dbo.T_ENG_BBEBOMCHILD_A' 中插入重复键。
语句已终止。
语句已终止。
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' 中插入重复键。
违反了 PRIMARY KEY 约束 'PK_ENG_BBEBOMCHILD_A'。不能在对象 'dbo.T_ENG_BBEBOMCHILD_A' 中插入重复键。
语句已终止。
语句已终止。
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)
   在 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)

版本7.2.877.3

产品问题物料清单批量维护提示错误

产品问题 物料清单批量维护提示错误

恭喜您！

产品问题
物料清单批量维护提示错误

产品问题物料清单批量维护提示错误