请教如图,BOM批量维护时出现错误提示source:SELECT T_ENG_BBEBOM...
金蝶云社区-林兵兴
林兵兴
0人赞赏了该文章 624次浏览 未经作者许可,禁止转载编辑于2018年02月02日 08:03:34

请教如图,BOM批量维护时出现错误提示


source:SELECT T_ENG_BBEBOM.FID, T_ENG_BBEBOM.FMasterId, T_ENG_BBEBOM.FDOCUMENTSTATUS, T_ENG_BBEBOM.FFORBIDSTATUS, T_ENG_BBEBOM.FNUMBER, T_ENG_BBEBOM.FCREATEORGID, T_ENG_BBEBOM.FUSEORGID, T_ENG_BBEBOM.FCREATORID, T_ENG_BBEBOM.FMODIFIERID, T_ENG_BBEBOM.FCREATEDATE, T_ENG_BBEBOM.FMODIFYDATE, T_ENG_BBEBOM.FFORBIDDERID, T_ENG_BBEBOM.FAPPROVERID, T_ENG_BBEBOM.FFORBIDDATE, T_ENG_BBEBOM.FAPPROVEDATE, T_ENG_BBEBOM.FBOMCATEGORY, T_ENG_BBEBOM.FBOMUSE, T_ENG_BBEBOM.FMATERIALID, T_ENG_BBEBOM.FYIELDRATE, T_ENG_BBEBOM.FBILLTYPE, T_ENG_BBEBOM.FUNITID, T_ENG_BBEBOM.FBASEUNITID, T_ENG_BBEBOM.FISDEFAULT, T_ENG_BBEBOM.FCFGBOMID, T_ENG_BBEBOM.FQTY, T_ENG_BBEBOM.FBASEQTY, T_ENG_BBEBOM.FGROUP, T_ENG_BBEBOM.FPLMBOMID, T_ENG_BBEBOM.FBOMSRC, T_ENG_BBEBOM.FAUXPROPID, T_ENG_BBEBOM.FMDLID, T_ENG_BBEBOM.FCOMPUTEID FROM T_ENG_BBEBOM WHERE T_ENG_BBEBOM.FID = @PKValue;
SELECT T_ENG_BBEBOM_L.FPkId, T_ENG_BBEBOM_L.FLocaleId, T_ENG_BBEBOM_L.FNAME, T_ENG_BBEBOM_L.FDESCRIPTION, T_ENG_BBEBOM_L.FID FROM T_ENG_BBEBOM_L INNER JOIN T_ENG_BBEBOM ON T_ENG_BBEBOM_L.FID = T_ENG_BBEBOM.FID WHERE T_ENG_BBEBOM.FID = @PKValue;
SELECT T_ENG_BBEBOMCHILD.FENTRYID, T_ENG_BBEBOMCHILD.FSEQ, T_ENG_BBEBOMCHILD_A.FPARENTROWID, T_ENG_BBEBOMCHILD_A.FROWEXPANDTYPE, T_ENG_BBEBOMCHILD_A.FROWID, T_ENG_BBEBOMCHILD.FMATERIALTYPE, T_ENG_BBEBOMCHILD.FDOSAGETYPE, T_ENG_BBEBOMCHILD.FPROCESSID, T_ENG_BBEBOMCHILD.FFIXSCRAPQTY, T_ENG_BBEBOMCHILD.FEFFECTDATE, T_ENG_BBEBOMCHILD.FEXPIREDATE, T_ENG_BBEBOMCHILD.FISSUETYPE, T_ENG_BBEBOMCHILD.FSUPPLYORG, T_ENG_BBEBOMCHILD.FSTOCKID, T_ENG_BBEBOMCHILD.FSTOCKLOCID, T_ENG_BBEBOMCHILD.FALLOWOVER, T_ENG_BBEBOMCHILD.FBACKFLUSHTYPE, T_ENG_BBEBOMCHILD.FTIMEUNIT, T_ENG_BBEBOMCHILD.FISKEYCOMPONENT, T_ENG_BBEBOMCHILD.FMATERIALID, T_ENG_BBEBOMCHILD.FPOSITIONNO, T_ENG_BBEBOMCHILD.FSCRAPRATE, T_ENG_BBEBOMCHILD.FDISASSMBLERATE, T_ENG_BBEBOMCHILD.FOFFSETTIME, T_ENG_BBEBOMCHILD.FISGETSCRAP, T_ENG_BBEBOMCHILD.FBOMID, T_ENG_BBEBOMCHILD.FNUMERATOR, T_ENG_BBEBOMCHILD.FDENOMINATOR, T_ENG_BBEBOMCHILD.FOWNERTYPEID, T_ENG_BBEBOMCHILD.FOWNERID, T_ENG_BBEBOMCHILD.FOPERID, T_ENG_BBEBOMCHILD.FAUXPROPID, T_ENG_BBEBOMCHILD.FUNITID, T_ENG_BBEBOMCHILD.FENTRYROWID, T_ENG_BBEBOMCHILD.FBASEUNITID, T_ENG_BBEBOMCHILD.FBASENUMERATOR, T_ENG_BBEBOMCHILD.FBASEFIXSCRAPQTY, T_ENG_BBEBOMCHILD.FBASEDENOMINATOR, T_ENG_BBEBOMCHILD.FQTY, T_ENG_BBEBOMCHILD.FACTUALQTY, T_ENG_BBEBOMCHILD.FOVERCONTROLMODE, T_ENG_BBEBOMCHILD.FREPLACEGROUP, T_ENG_BBEBOMCHILD_A.FREPLACEPOLICY, T_ENG_BBEBOMCHILD_A.FREPLACETYPE, T_ENG_BBEBOMCHILD_A.FREPLACEPRIORITY, T_ENG_BBEBOMCHILD_A.FMRPPRIORITY, T_ENG_BBEBOMCHILD_A.FISKEYITEM, T_ENG_BBEBOMCHILD_A.FISCANCHOOSE, T_ENG_BBEBOMCHILD_A.FISCANEDIT, T_ENG_BBEBOMCHILD_A.FISCANREPLACE, T_ENG_BBEBOMCHILD_A.FCFGBOMENTRYID, T_ENG_BBEBOMCHILD_A.FCFGFEATUREENTRYID, T_ENG_BBEBOMCHILD.FCHILDSUPPLYORGID, T_ENG_BBEBOMCHILD.FOPTQUEUE, T_ENG_BBEBOMCHILD_A.FPLMBOMENTRYID, T_ENG_BBEBOMCHILD_A.FBOMENTRYSRC, T_ENG_BBEBOMCHILD_A.FISSKIP, T_ENG_BBEBOMCHILD_A.FTREEENTRYIDBAK, T_ENG_BBEBOMCHILD.FISMINISSUEQTY, T_ENG_BBEBOMCHILD_A.FCHANGETYPE, T_ENG_BBEBOMCHILD_A.FCHANGETIME, T_ENG_BBEBOMCHILD_A.FSUPPLYMODE, T_ENG_BBEBOMCHILD_A.FECNROWTYPE, T_ENG_BBEBOMCHILD.FRECORDDATA, T_ENG_BBEBOMCHILD_A.FPLMBOMENTRYROWID, T_ENG_BBEBOMCHILD.FBBESTATUS, T_ENG_BBEBOMCHILD.FID FROM T_ENG_BBEBOMCHILD INNER JOIN T_ENG_BBEBOM ON T_ENG_BBEBOMCHILD.FID = T_ENG_BBEBOM.FID LEFT OUTER JOIN T_ENG_BBEBOMCHILD_A ON T_ENG_BBEBOMCHILD.FENTRYID = T_ENG_BBEBOMCHILD_A.FENTRYID WHERE T_ENG_BBEBOM.FID = @PKValue;
SELECT T_ENG_BBEBOMCHILD_L.FPkId, T_ENG_BBEBOMCHILD_L.FLocaleId, T_ENG_BBEBOMCHILD_L.FMEMO, T_ENG_BBEBOMCHILD_L.FENTRYID FROM T_ENG_BBEBOMCHILD_L INNER JOIN T_ENG_BBEBOMCHILD ON T_ENG_BBEBOMCHILD_L.FENTRYID = T_ENG_BBEBOMCHILD.FENTRYID INNER JOIN T_ENG_BBEBOM ON T_ENG_BBEBOMCHILD.FID = T_ENG_BBEBOM.FID WHERE T_ENG_BBEBOM.FID = @PKValue;
SELECT T_ENG_BBEBOMCHILDLOTBASEDQTY.FDETAILID, T_ENG_BBEBOMCHILDLOTBASEDQTY.FSeq, T_ENG_BBEBOMCHILDLOTBASEDQTY.FMATERIALID, T_ENG_BBEBOMCHILDLOTBASEDQTY.FSTARTQTY, T_ENG_BBEBOMCHILDLOTBASEDQTY.FENDQTY, T_ENG_BBEBOMCHILDLOTBASEDQTY.FFIXSCRAPQTY, T_ENG_BBEBOMCHILDLOTBASEDQTY.FNOTE, T_ENG_BBEBOMCHILDLOTBASEDQTY.FSCRAPRATE, T_ENG_BBEBOMCHILDLOTBASEDQTY.FNUMERATOR, T_ENG_BBEBOMCHILDLOTBASEDQTY.FDENOMINATOR, T_ENG_BBEBOMCHILDLOTBASEDQTY.FUNITID, T_ENG_BBEBOMCHILDLOTBASEDQTY.FBASEUNITID, T_ENG_BBEBOMCHILDLOTBASEDQTY.FBASENUMERATOR, T_ENG_BBEBOMCHILDLOTBASEDQTY.FBASESTARTQTY, T_ENG_BBEBOMCHILDLOTBASEDQTY.FBASEENDQTY, T_ENG_BBEBOMCHILDLOTBASEDQTY.FBASEFIXSCRAPQTY, T_ENG_BBEBOMCHILDLOTBASEDQTY.FBASEDENOMINATOR, T_ENG_BBEBOMCHILDLOTBASEDQTY.FENTRYID FROM T_ENG_BBEBOMCHILDLOTBASEDQTY INNER JOIN T_ENG_BBEBOMCHILD ON T_ENG_BBEBOMCHILDLOTBASEDQTY.FENTRYID = T_ENG_BBEBOMCHILD.FENTRYID INNER JOIN T_ENG_BBEBOM ON T_ENG_BBEBOMCHILD.FID = T_ENG_BBEBOM.FID WHERE T_ENG_BBEBOM.FID = @PKValue;
SELECT T_ENG_BBEBOMCOBY.FENTRYID, T_ENG_BBEBOMCOBY.FSEQ, T_ENG_BBEBOMCOBY.FCOBYTYPE, T_ENG_BBEBOMCOBY.FMATERIALID, T_ENG_BBEBOMCOBY.FQTY, T_ENG_BBEBOMCOBY.FCOSTRATE, T_ENG_BBEBOMCOBY.FPPROCESSID, T_ENG_BBEBOMCOBY.FEFFECTDATE, T_ENG_BBEBOMCOBY.FEXPIREDATE, T_ENG_BBEBOMCOBY.FNOTE, T_ENG_BBEBOMCOBY.FBASEQTY, T_ENG_BBEBOMCOBY.FBASEUNITID, T_ENG_BBEBOMCOBY.FTASKID, T_ENG_BBEBOMCOBY.FUNITID, T_ENG_BBEBOMCOBY.FAUXPROPID, T_ENG_BBEBOMCOBY.FOUTPUTOPTQUEUE, T_ENG_BBEBOMCOBY.FBOMID, T_ENG_BBEBOMCOBY.FISBACKFLUSH, T_ENG_BBEBOMCOBY.FBBESTATUS, T_ENG_BBEBOMCOBY.FID FROM T_ENG_BBEBOMCOBY INNER JOIN T_ENG_BBEBOM ON T_ENG_BBEBOMCOBY.FID = T_ENG_BBEBOM.FID WHERE T_ENG_BBEBOM.FID = @PKValue;
SELECT T_ENG_BBEBOMBOPENTRY.FEntryID, T_ENG_BBEBOMBOPENTRY.FSeq, T_ENG_BBEBOMBOPENTRY.FREPLACEGROUPBOP, T_ENG_BBEBOMBOPENTRY.FPRODUCTLINE, T_ENG_BBEBOMBOPENTRY.FPRDLINELOCID, T_ENG_BBEBOMBOPENTRY.FBOPMATERIALID, T_ENG_BBEBOMBOPENTRY.FBOPUNITID, T_ENG_BBEBOMBOPENTRY.FBOPDOSAGETYPE, T_ENG_BBEBOMBOPENTRY.FBOPNUMERATOR, T_ENG_BBEBOMBOPENTRY.FBOPDENOMINATOR, T_ENG_BBEBOMBOPENTRY.FBOPBASEUNITID, T_ENG_BBEBOMBOPENTRY.FBASEBOPNUMERATOR, T_ENG_BBEBOMBOPENTRY.FBASEBOPDENOMINATOR, T_ENG_BBEBOMBOPENTRY.FTREEENTRYID, T_ENG_BBEBOMBOPENTRY.FID FROM T_ENG_BBEBOMBOPENTRY INNER JOIN T_ENG_BBEBOM ON T_ENG_BBEBOMBOPENTRY.FID = T_ENG_BBEBOM.FID WHERE T_ENG_BBEBOM.FID = @PKValue;
message:列名 'FPLMBOMENTRYROWID' 无效。
stacktrace:
Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior, Boolean bNewCn)
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior, Boolean bNewCn)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, Boolean bNewCn)
在 Kingdee.BOS.App.Data.Sql.KSql4SQLDataReader..ctor(IList`1 selectSqls, Context ctx, ReadWhere where, IEnumerable`1 tablesSchema, DbMetadataTable rootTable)
在 Kingdee.BOS.App.Data.OLEDbDriver.ExecuteReader(SelectCallback callback, IEnumerable`1 tablesSchema, DbMetadataTable rootTable, IList`1 selectSqls, ReadWhere where, OperateOption option)
在 Kingdee.BOS.Orm.Drivers.DbDriverBase.Select(SelectCallback callback, IEnumerable`1 tablesSchema, DbMetadataTable rootTable, ReadWhere where, OperateOption option)
在 Kingdee.BOS.Orm.DataManager.DataManagerImplement.ReadToDataSet(IDbDriver driver, DbMetadataDatabase database, DbMetadataTable rootTable, ReadWhere where, OperateOption option)
在 Kingdee.BOS.Orm.DataManager.DataManagerImplement.Read(ReadWhere where, OperateOption option)
在 Kingdee.BOS.Orm.DataManager.DataManagerImplement.AutoBatchExecute(IEnumerable ids, OperateOption option, Func`2 func)
在 Kingdee.BOS.Orm.DataManager.DataManagerImplement.Read(IEnumerable ids, OperateOption option)
在 Kingdee.BOS.App.Core.BusinessDataReader.Load(Object[] pkArray, DynamicObjectType type, Boolean loadReferenceData)
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:列名 'FPLMBOMENTRYROWID' 无效。
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.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
在 Kingdee.BOS.App.Data.AbstractDatabase.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior)
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior, Boolean bNewCn)