发文申请，用印发布 点击文件发布报下图错

soa

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO OA_KM_Rights(OA_KM_Rights.fID, OA_KM_Rights.VERSION, OA_KM_Rights.FKWKIND, OA_KM_Rights.FFOLDERID, OA_KM_Rights.FFOLDERNAME, OA_KM_Rights.fKWID, OA_KM_Rights.FKWNAME, OA_KM_Rights.FKWFULLID, OA_KM_Rights.FKWFULLNAME, OA_KM_Rights.FORGKIND, OA_KM_Rights.FORGID, OA_KM_Rights.FORGNAME, OA_KM_Rights.FORGFID, OA_KM_Rights.FORGFNAME, OA_KM_Rights.FCANCREATEKW, OA_KM_Rights.FCANREADKW, OA_KM_Rights.FCANCREATECOMMENT, OA_KM_Rights.FCANREADCOMMENT, OA_KM_Rights.FCANSCORE, OA_KM_Rights.FCANREADRECORD, OA_KM_Rights.FISINHERIT, OA_KM_Rights.FCREATEPSNID, OA_KM_Rights.FCREATEPSNNAME, OA_KM_Rights.FCREATETIME, OA_KM_Rights.FCANRELEASEKW)(SELECT  ?, ?, ?, OA_KM_Rights.FFOLDERID AS fFolderID,  NULL , ?,  NULL , OA_KM_Rights.FKWFULLID + ? + ?,  NULL , OA_KM_Rights.FORGKIND AS fOrgKind, OA_KM_Rights.FORGID AS fOrgID, OA_KM_Rights.FORGNAME AS fOrgName, OA_KM_Rights.FORGFID AS fOrgFID, OA_KM_Rights.FORGFNAME AS fOrgFName, OA_KM_Rights.FCANCREATEKW AS fCanCreateKW, OA_KM_Rights.FCANREADKW AS fCanReadKW, OA_KM_Rights.FCANCREATECOMMENT AS fCanCreateComment, OA_KM_Rights.FCANREADCOMMENT AS fCanReadComment, OA_KM_Rights.FCANSCORE AS fCanScore, OA_KM_Rights.FCANREADRECORD AS fCanReadRecord, ?, ?, ?,  ? , OA_KM_Rights.FCANRELEASEKW AS fCanReleaseKW FROM OA_KM_Rights OA_KM_Rights  WHERE  (OA_KM_Rights.FKWKIND = ?) AND ( OA_KM_Rights.FFOLDERID IN (?, ?) ) ), binds: [93DBFE779D8F4820B77AADDB43E78CE6, 0, Knowledge, E9BE0F4727234BC0B5EFCE314ECFBBD1, /, E9BE0F4727234BC0B5EFCE314ECFBBD1, 1, 8E6C8C88FEF74D77B183FF1D51A7EA1A, 024, 2014-03-17 16:39:40.508, Folder, doc, ]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 33 more
Caused by: java.sql.SQLException: 违反了 PRIMARY KEY 约束 'PK__OA_KM_RIGHTS__73852659'。不能在对象 'dbo.OA_KM_RIGHTS' 中插入重复键。



是插入了重复键 而且主键重复，但是主键不是系统自动生成的吗？我这边要怎么修改呢？用的x5版本为5.2.6.2457，数据库为 sql2008，是最新网上发布的OA覆盖的，如果把'PK__OA_KM_RIGHTS表里面的数据全部删除，在发布文件就不报错，但是在录入第二遍数据时又报同样的错误。

lixin_justep

主键数据重复了，检查这个OA_KM_Rights表里的PK__OA_KM_RIGHTS__73852659主键是哪个字段，然后检查这个字段的数据是怎么生成的。
最好是在保存前判断一下数据是否合法，把错误数据提前处理

soa

主键不是FID字段吗？不是系统自动生成的吗？这要怎么做呢？

lixin_justep

soa 发表于 2014-3-18 09:25
主键不是FID字段吗？不是系统自动生成的吗？这要怎么做呢？

你检查一下，这个主键应该不是FID，从数据库中查这个主键。FID不会重复的

soa

这个不是主键吗？

lixin_justep

soa 发表于 2014-3-18 14:46
这个不是主键吗？

系统自动填充GUID应该是不会重复的，楼主跟踪数据排查一下，看第二次插入的时候这个FID是什么值

soa

这个怎么跟踪啊