入库钩稽汇总表-查询报:查询出现异常。ORA-00001
金蝶云社区-肖明宇
肖明宇
0人赞赏了该文章 444次浏览 未经作者许可,禁止转载编辑于2016年09月28日 19:56:36

查询出现异常。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 这表是空的