com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '/ab-abcf-dita' for key 'kms_fil_nm_i2'

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,

Check whether privilege has the "not null" restriction. If so it always has to have a value and can never be null.

A different reason could be a wrong implementation of a foreign key. Check whether you always correctly insert/update in both tables.

,

Nothing is wrong with the database. When it gives you those errors, it's telling you that you are trying to input "nothing" (null) into a column that doesn't allow it. Fix it by removing the not null constraint or by passing a value to that field.

Solutions on the web

via Kuali JIRA by Mike Riley, 1 year ago
Duplicate entry '/ab-abcf-dita' for key 'kms_fil_nm_i2'
via Kuali JIRA by Mike Riley, 1 year ago
Duplicate entry '/ab-abcf-dita' for key 'kms_fil_nm_i2'
via Stack Overflow by user5655410
, 1 year ago
Cannot add or update a child row: a foreign key constraint fails (`database`.`Comments_Table`, CONSTRAINT `Comments_Table_ibfk_2` FOREIGN KEY (`Reference_ID`) REFERENCES `A_Table` (`A_Table_ID`) ON DELETE CASCADE ON UPDATE CAS)
via shitaraba.net by Unknown author, 2 years ago
Cann ot add or update a child row: a foreign key constraint fails (`moopledev`.`inventory items`, CONSTRAINT `FK_inventoryitems_2` FOREIGN KEY (`accountid`) REFERENCES `a ccounts` (`id`) ON DELETE CASCADE)
via Stack Overflow by arjun narahari
, 2 years ago
Duplicate entry '1' for key 'UK_qk8e1fl454umkjvarmovmdgrp'
via GitHub by alanpearce
, 2 years ago
Duplicate entry '4011' for key 'PRIMARY'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '/ab-abcf-dita' for key 'kms_fil_nm_i2'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
at org.springmodules.orm.ojb.PersistenceBrokerTemplate$9.doInPersistenceBroker(PersistenceBrokerTemplate.java:246)
at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)
at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244)
at org.kuali.rice.kns.dao.impl.BusinessObjectDaoOjb.save(BusinessObjectDaoOjb.java:217)
at org.kuali.rice.kns.dao.proxy.BusinessObjectDaoProxy.save(BusinessObjectDaoProxy.java:213)
at sun.reflect.GeneratedMethodAccessor301.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at undefined.$Proxy38.save(Unknown Source)
at org.kuali.rice.kns.service.impl.BusinessObjectServiceImpl.save(BusinessObjectServiceImpl.java:74)
at sun.reflect.GeneratedMethodAccessor300.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at undefined.$Proxy39.save(Unknown Source)
at org.kuali.kits.kms.bo.KmsFileName.getOrMakeFileName(KmsFileName.java:245)
at org.kuali.kits.kms.repository.RepositoryPollerTask.addOrModifyDocumentFromSvn(RepositoryPollerTask.java:238)
at org.kuali.kits.kms.repository.RepositoryPollerTask.processLogEntry(RepositoryPollerTask.java:1072)
at org.kuali.kits.kms.repository.RepositoryPollerTask.performRun(RepositoryPollerTask.java:1401)
at org.kuali.kits.kms.repository.RepositoryPollerTask.run(RepositoryPollerTask.java:1489)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)

Users with the same issue

6 times, 5 days ago
Once, 5 days ago
5 times, 3 weeks ago
4 times, 4 weeks ago
2 times, 1 month ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.