查询出现异常。ORA-00001: unique constraint (C##K3CLOUD61BUSITH.PK_HS_INSTOCKESTIMATESUMMAR) violated
INSERT /*+ APPEND */ INTO TM_HS_INSTOCKESTIMATESUMMARY (FYEAR, FPERIOD, FBILLFORMID, FBUSINESSTYPE, FSUPPLIERID, FSUPPLIERNUMBER, FMATERTYPEID, FOWNERID, FMATERIALID, FMATERIALNUMBER, FSTOCKID, FSTOCKLOCID, FSTOCKSTATUSID, FLOTID, FMTONO, FBOMID, FAUXPROPID, FBASEUNITID, FINITUNHOOKQTY, FINITUNHOOKAMOUNT, FINQTY, FINAMOUNT, FCURRENTHOOKQTY, FCURRENTHOOKAMOUNT, FENDUNHOOKQTY, FENDUNHOOKAMOUNT) SELECT FYEAR, FPERIOD, FBILLFORMID, FBUSINESSTYPE, FSUPPLIERID, max(FSUPPLIERNUMBER), FMATERTYPEID, FOWNERID, FMATERIALID, max(FMATERIALNUMBER), FSTOCKID, FSTOCKLOCID, FSTOCKSTATUSID, FLOTID, FMTONO, FBOMID, FAUXPROPID, FBASEUNITID, Sum(FINITUNHOOKQTY) FINITUNHOOKQTY, Sum(FINITUNHOOKAMOUNT) FINITUNHOOKAMOUNT, Sum(FINQTY) FINQTY, Sum(FINAMOUNT) FINAMOUNT, Sum(FCURRENTHOOKQTY) FCURRENTHOOKQTY, Sum(FCURRENTHOOKAMOUNT) FCURRENTHOOKAMOUNT, Sum(FENDUNHOOKQTY) FENDUNHOOKQTY, Sum(FENDUNHOOKAMOUNT) FENDUNHOOKAMOUNT FROM TM_HS_INSTOCKESTIMATESUMMARY GROUP BY FYEAR, FPERIOD, FBILLFORMID, FBUSINESSTYPE, FSUPPLIERID, FMATERTYPEID, FOWNERID, FMATERIALID, FSTOCKID, FSTOCKLOCID, FSTOCKSTATUSID, FLOTID, FMTONO, FBOMID, FAUXPROPID, FBASEUNITID
Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteWithTime(Context ctx, String strSQL, IEnumerable`1 paramList, Int32 commandTimeout)
TM_HS_INSTOCKESTIMATESUMMARY 这表是空的
推荐阅读