办公自动化--公告管理--栏目设置。重复新增数据无法插入！

comeonbabyoh

经过测试是因为重复新增，数据重复了无法插入，但是老版本在同一个菜单树下是支持重复新增数据的！

报错信息如下，起步有这方面bug解决办法吗？下载的源码有错。。
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.justep.system.action.Engine.invokeActions(Native Method)
... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksql:INSERT INTO OA_KM_Folder OA_KM_Folder(OA_KM_Folder, OA_KM_Folder.version, OA_KM_Folder.fName, OA_KM_Folder.fDescription, OA_KM_Folder.fParent, OA_KM_Folder.fFullID, OA_KM_Folder.fFullName, OA_KM_Folder.fSequence, OA_KM_Folder.fUseStatus, OA_KM_Folder.fUseStatusName, OA_KM_Folder.fCreatePsnID, OA_KM_Folder.fCreatePsnName, OA_KM_Folder.fCreateTime) VALUES (:OA_KM_Folder, :version, :fName, :fDescription, :fParent, :fFullID, :fFullName, :fSequence, :fUseStatus, :fUseStatusName, :fCreatePsnID, :fCreatePsnName, :fCreateTime)时出错！
at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.impl.TableImpl.insert(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.BizData.save(Unknown Source)
at BizProcedure.save(BizProcedure.java:18)
... 26 more
Caused by: com.justep.model.exception.ModelException: 执行sql：INSERT INTO OA_KM_Folder (OA_KM_Folder.fID, OA_KM_Folder.VERSION, OA_KM_Folder.FNAME, OA_KM_Folder.FDESCRIPTION, OA_KM_Folder.fParent, OA_KM_Folder.FFULLID, OA_KM_Folder.FFULLNAME, OA_KM_Folder.FSEQUENCE, OA_KM_Folder.FUSESTATUS, OA_KM_Folder.FUSESTATUSNAME, OA_KM_Folder.FCREATEPSNID, OA_KM_Folder.FCREATEPSNNAME, OA_KM_Folder.FCREATETIME) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), binds:[DDA6239F8A5842648D5F7B57FB48F81B, 0, 新增栏目, null, notice, public/notice/DDA6239F8A5842648D5F7B57FB48F81B, 知识中心/公告/新增栏目, null, 0, 未启用, PSN01, system, 2013-11-06 09:57:12.109]出错！
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 35 more
Caused by: java.sql.SQLException: Duplicate entry 'notice-鏂板鏍忕洰' for key 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
... 36 more

url:/UI/system/service/common/bizAction.j
param:/OA/knowledge/dataOA_KM_FolderStringOA_KM_FolderwhereVersionOA_KM_Folder.fName,EXPRESS,OA_KM_Folder.fDescription,OA_KM_Folder.fParent,OA_KM_Folder.fFullID,OA_KM_Folder.fFullName,OA_KM_Folder.fSequence,OA_KM_Folder.fUseStatus,OA_KM_Folder.fUseStatusName,OA_KM_Folder.fCreatePsnID,OA_KM_Folder.fCreatePsnName,OA_KM_Folder.fCreateTime,OA_KM_Folder.versionString,Object,String,String,String,String,Integer,Integer,String,String,String,DateTime,IntegerfName,space-column,fDescription,fParent,fFullID,fFullName,fSequence,fUseStatus,fUseStatusName,fCreatePsnID,fCreatePsnName,fCreateTime,versionOA_KM_Folder1OA_KM_FolderOA_KM_FolderwhereVersionnew%E6%96%B0%E5%A2%9E%E6%A0%8F%E7%9B%AEnoticepublic%2Fnotice%2FDDA6239F8A5842648D5F7B57FB48F81B%E7%9F%A5%E8%AF%86%E4%B8%AD%E5%BF%83%2F%E5%85%AC%E5%91%8A%2F%E6%96%B0%E5%A2%9E%E6%A0%8F%E7%9B%AE0%E6%9C%AA%E5%90%AF%E7%94%A8PSN01system2013-11-06T09%3A57%3A12.109Z0

lixin_justep

当前功能的数据表的fParent、fName两个字段做了唯一索引，所以出现上述问题。后续OA中会增加不能重复插入的提示

comeonbabyoh

lixin_justep 发表于 2013-11-7 13:24
当前功能的数据表的fParent、fName两个字段做了唯一索引，所以出现上述问题。后续OA中会增加不能重复插入的 ...

如何去掉？我发现这个问题了，发现不知道怎么修改。。

wangyutao

如果你需要保留这样的特性，那么到数据库删除索引即可。
否则，应该在前台有判断不允许重复，然后给用户一个明确的提示。（接下来ＯＡ产品就会这样调整一下）

comeonbabyoh

可以结贴，已经从数据库删除关联主键，思路错误，一直在概念中找相关设置。

lixin_justep

comeonbabyoh 发表于 2013-11-7 14:56
可以结贴，已经从数据库删除关联主键，思路错误，一直在概念中找相关设置。 ...

已更新资源，请下载最新资源

comeonbabyoh

lixin_justep 发表于 2013-12-4 11:47
已更新资源，请下载最新资源

最新资源上这个问题更改了只是js对吗？还是有错。
我点击新增，明明下面一个节点都没有，还是弹出提示这个重复并且已经存在，问我是否删除，点确认就删除了。。。点否倒是可以重复添加。

lixin_justep

comeonbabyoh 发表于 2013-12-4 14:46
最新资源上这个问题更改了只是js对吗？还是有错。
我点击新增，明明下面一个节点都没有，还是弹出提示这 ...

现在的提示应该是 ：已经存在节点: 知识中心/公告/新增栏目  请先修改重复节点名称，
/UI/OA/knowledge/process/simpleFolderSet/baseFDSetActivity.w 也有修改的，要把dFolder 数据集设成 confirm-delete="false"

comeonbabyoh

lixin_justep 发表于 2013-12-5 08:24
现在的提示应该是 ：已经存在节点: 知识中心/公告/新增栏目  请先修改重复节点名称，
/UI/OA/knowledge/pr ...

按照这样改成false的话，那么只提示这个已经存在节点: 知识中心/公告/新增栏目  请先修改重复节点名称，然后就直接默认删除掉了，没法添加。

lixin_justep

comeonbabyoh 发表于 2013-12-5 09:25
按照这样改成false的话，那么只提示这个已经存在节点: 知识中心/公告/新增栏目  请先修改重复节点名称， ...

请看提示，要把已经存在的新增节点改成其他名字，因为这里添加节点的时候，默认名称是“新增节点”
正常操作，应该是新增节点后，要把节点的名字改成实际需要的，而不是保留系统默认的“新增节点”

如果严谨一点的话，可以做这样一个逻辑：判断当前新增的节点是否存在，存在的话，把名称后边加序号（1、2.....）,以此来保证默认的名称跟现有名称不重复