请教如图，物料清单批量维护时出现错误提示
source:INSERT INTOT_ENG_BBEBOM (FID, FMASTERID, FYIELDRATE, FBILLTYPE, FISDEFAULT, FBASEUNITID,FUNITID, FCREATEDATE, FMODIFIERID, FCREATORID, FAPPROVERID, FFORBIDDERID,FMODIFYDATE, FUSEORGID, FFORBIDSTATUS, FDOCUMENTSTATUS, FCREATEORGID, FNUMBER,FBOMCATEGORY, FAPPROVEDATE, FFORBIDDATE, FMATERIALID, FBOMUSE, FQTY, FGROUP,FBASEQTY, FCFGBOMID, FMDLID, FAUXPROPID, FBOMSRC, FPLMBOMID, FCOMPUTEID) SELECTT1.FID, T1.FMASTERID, T1.FYIELDRATE, T1.FBILLTYPE, T1.FISDEFAULT,T1.FBASEUNITID, T1.FUNITID, 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.FQTY, T1.FGROUP, T1.FBASEQTY, T1.FCFGBOMID, T1.FMDLID, T1.FAUXPROPID,T1.FBOMSRC, T1.FPLMBOMID, '068e9b21-cde0-8150-11e8-6ed2465384f4' FROM T_ENG_BOMT1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FIDINSERT 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.FIDINSERT INTO T_ENG_BBEBOMCHILD (FID,FENTRYID, FSEQ, FOPTQUEUE, FISMINISSUEQTY, 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) SELECTT1.FID, T1.FENTRYID, T1.FSEQ, T1.FOPTQUEUE, T1.FISMINISSUEQTY,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' FROMT_ENG_BOMCHILD T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FIDINSERT INTOT_ENG_BBEBOMCHILD_A (FENTRYID, FID, FBOMENTRYSRC, FPLMBOMENTRYID,FTREEENTRYIDBAK, FISSKIP, FCFGBOMENTRYID, FISCANREPLACE, FISCANEDIT,FCFGFEATUREENTRYID, FISMRPRUN, FECNROWTYPE, FECNBILLNO, FCHANGETIME,FCHANGETYPE, FSUPPLYMODE, FECNCHGDATE, FECNCHGTYPE, FREPLACEPRIORITY, FREPLACETYPE,FREPLACEPOLICY, FISCANCHOOSE, FISKEYITEM, FMRPPRIORITY, FPARENTROWID, FROWID,FROWEXPANDTYPE) SELECT T1.FENTRYID, T1.FID, T1.FBOMENTRYSRC, T1.FPLMBOMENTRYID,T1.FTREEENTRYIDBAK, T1.FISSKIP, T1.FCFGBOMENTRYID, T1.FISCANREPLACE,T1.FISCANEDIT, T1.FCFGFEATUREENTRYID, T1.FISMRPRUN, T1.FECNROWTYPE,T1.FECNBILLNO, T1.FCHANGETIME, T1.FCHANGETYPE, T1.FSUPPLYMODE, T1.FECNCHGDATE,T1.FECNCHGTYPE, T1.FREPLACEPRIORITY, T1.FREPLACETYPE, T1.FREPLACEPOLICY,T1.FISCANCHOOSE, T1.FISKEYITEM, T1.FMRPPRIORITY, T1.FPARENTROWID, T1.FROWID,T1.FROWEXPANDTYPE FROM T_ENG_BOMCHILD_A T1 INNER JOIN @FID_udt1 TMPB ON T1.FID= TMPB.FIDINSERT INTO T_ENG_BBEBOMCHILD_L (FPKID, FENTRYID, FLOCALEID, FMEMO)SELECT T1.FPKID, T1.FENTRYID, T1.FLOCALEID, T1.FMEMO FROM T_ENG_BOMCHILD_L T1 INNERJOIN T_ENG_BOMCHILD T2 ON T1.FENTRYID = T2.FENTRYID INNER JOIN @FID_udt1 TMPBON T2.FID = TMPB.FIDINSERT INTO T_ENG_BBEBOMCHILDLOTBASEDQTY (FENTRYID,FDETAILID, FSEQ, FNUMERATOR, FSCRAPRATE, FNOTE, FBASEUNITID, FUNITID,FDENOMINATOR, FFIXSCRAPQTY, FMATERIALID, FENDQTY, FSTARTQTY, FBASEENDQTY,FBASESTARTQTY, FBASENUMERATOR, FBASEDENOMINATOR, FBASEFIXSCRAPQTY) SELECTT1.FENTRYID, T1.FDETAILID, T1.FSEQ, T1.FNUMERATOR, T1.FSCRAPRATE, T1.FNOTE,T1.FBASEUNITID, T1.FUNITID, T1.FDENOMINATOR, T1.FFIXSCRAPQTY, T1.FMATERIALID,T1.FENDQTY, T1.FSTARTQTY, T1.FBASEENDQTY, T1.FBASESTARTQTY, T1.FBASENUMERATOR,T1.FBASEDENOMINATOR, T1.FBASEFIXSCRAPQTY FROM T_ENG_BOMCHILDLOTBASEDQTY T1INNER JOIN T_ENG_BOMCHILD T2 ON T1.FENTRYID = T2.FENTRYID INNER JOIN @FID_udt1TMPB ON T2.FID = TMPB.FIDINSERT INTO T_ENG_BBEBOMCOBY (FID, FENTRYID, FSEQ,FISBACKFLUSH, FBOMID, FOUTPUTOPTQUEUE, FAUXPROPID, FBASEQTY, FNOTE,FEXPIREDATE, FUNITID, FTASKID, FBASEUNITID, FQTY, FEFFECTDATE, FPPROCESSID,FCOSTRATE, FMATERIALID, 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.FQTY, T1.FEFFECTDATE, T1.FPPROCESSID, T1.FCOSTRATE, T1.FMATERIALID, T1.FCOBYTYPE,'1' FROM T_ENG_BOMCOBY T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FIDINSERTINTO 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 FROMT_ENG_BOMBOPENTRY T1 INNER JOIN @FID_udt1 TMPB ON T1.FID = TMPB.FIDmessage:将截断字符串或二进制数据。语句已终止。stacktrace:Server stack trace: 在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommandcommand, IEnumerable`1 listParam) 在Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1paramList, Boolean needTranslate) 在Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1paramList)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(Contextctx, DynamicObject editDataObject, BomBatchEditOption option) 在Kingdee.K3.MFG.ENG.Business.PlugIn.DynamicForm.WizardForm.BomBatchEditWizardPlugIn.RunSimulationBom() 在 System.Threading.Tasks.Task.Execute()innerexception:source:.Net SqlClient Data Providermessage:将截断字符串或二进制数据。语句已终止。stacktrace: 在System.Data.SqlClient.SqlConnection.OnError(SqlException exception, BooleanbreakConnection, Action`1 wrapCloseInAction) 在System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehaviorrunBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj,Boolean& dataReady) 在System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, BooleanforDescribeParameterEncryption) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async,Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry,SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,RunBehavior runBehavior, Boolean returnStream, String method,TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean&usedCache, Boolean asyncWrite, Boolean inRetry) 在System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean&usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 在Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command,IEnumerable`1 listParam)
推荐阅读