金蝶云·星空|查询出现异常。违反了 PRIMARY KEY 约束“PK__

0

查询出现异常。违反了 PRIMARY KEY 约束“PK__#B5BEE5E__C1BEA5A205439932”。不能在对象“dbo.@FID_udt1”中插入重复键。重复键值为 (143381)。
语句已终止。
INSERT INTO TMP5F06F03055E511E980CD0A94EF4 (T_STK_INSTOCKENTRY, T_STK_INSTOCKENTRY_SID, t_PUR_POOrderEntry, t_PUR_POOrderEntry_SID, T_PUR_MRBENTRY, T_PUR_MRBENTRY_SID, T_AP_PAYABLEENTRY, T_AP_PAYABLEENTRY_SID, FIDENTITYID) SELECT T_STK_INSTOCKENTRY, T_STK_INSTOCKENTRY_SID, t_PUR_POOrderEntry, t_PUR_POOrderEntry_SID, T_PUR_MRBENTRY, T_PUR_MRBENTRY_SID, T_AP_PAYABLEENTRY, T_AP_PAYABLEENTRY_SID, FIDENTITYID FROM TMP5F06F03A55E511E980CD0A94EF4 T1 WHERE EXISTS (SELECT 1 FROM @FID_udt1 B WHERE B.FID = T1.T_STK_INSTOCKENTRY)

Server stack trace:
   在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
   在 Kingdee.BOS.App.Data.DBUtils.ExecuteBatchWithTime(Context ctx, List`1 lstSqlObj, Int32 commandTimeout)
   在 Kingdee.YPH.K3.SCM.App.Report.PurUtils.GetNeedDataByFields(Context ctx, List`1 lstTable, String flowData, String flowDataTable, Int64[] entryIds, String entryKey)
   在 Kingdee.YPH.K3.SCM.App.Report.InStockComRpt.GetInDataSource(List`1 entryIds)
   在 Kingdee.YPH.K3.SCM.App.Report.InStockComRpt.GetDataSource(List`1 inStockEntryIds, List`1 returnStockEntryIds)
   在 Kingdee.YPH.K3.SCM.App.Report.InStockComRpt.BuilderReportSqlAndTempTable(IRptParams filter, String tableName)
   在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
   在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
   在 Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetData(IRptParams filter)
   在 Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetReportData(ReportServiceParameter parameter)
   在 Kingdee.BOS.App.Core.SysReportService.GetReportData(ReportServiceParameter parameter)

Exception rethrown at [0]:
   在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   在 Kingdee.BOS.Contracts.ISysReportService.GetReportData(ReportServiceParameter parameter)
   在 Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetReportData(ReportServiceParameter parameter)
   在 Kingdee.BOS.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
   在 Kingdee.BOS.Web.Report.SysReportView.GetListData()
   在 Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass55.<ShowProcessQuery>b__51()

---------------------------------------------------------------------------------------------------------------------
奇葩问题,单据:采购入库综合报表,查询19年3月25号以后的就报这个错,查询25号之前日期的则不会报错,有没有大神指点一二,在此感谢