com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE userassociation SET SOURCE_NAME = ? WHERE SINK_NODE_ID=? AND SINK_NODE_ENTITY=? AND ASSOCIATION_TYPE=? (Duplicate entry 'przemyslaw.marcinows-24682-Issue-WatchIssue' for key 'PRIMARY')

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

Solutions on the web

via Atlassian JIRA by Matt, 1 year ago
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE userassociation SET SOURCE_NAME = ? WHERE SINK_NODE_ID=? AND SINK_NODE_ENTITY=? AND ASSOCIATION_TYPE=? (Duplicate entry 'przemyslaw.marcinows-24682-Issue-WatchIssue' for key 'PRIMARY')
via Atlassian JIRA by Matt, 1 year ago
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE userassociation SET SOURCE_NAME = ? WHERE SINK_NODE_ID=? AND SINK_NODE_ENTITY=? AND ASSOCIATION_TYPE=? (Duplicate entry 'przemyslaw.marcinows-24682-Issue-WatchIssue' for key 'PRIMARY')
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE userassociation SET SOURCE_NAME = ? WHERE SINK_NODE_ID=? AND SINK_NODE_ENTITY=? AND ASSOCIATION_TYPE=? (Duplicate entry 'przemyslaw.marcinows-24682-Issue-WatchIssue' for key 'PRIMARY')
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:650)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.bulkUpdateByAnd(DefaultOfBizDelegator.java:685)
at com.atlassian.jira.entity.Update$WhereContext.execute(Update.java:136)
at com.atlassian.jira.entity.EntityEngineImpl.execute(EntityEngineImpl.java:45)
at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6039$AssociationVisitor.lowercaseThisRow(UpgradeTask_Build6039.java:250)
at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6039$AssociationVisitor.visit(UpgradeTask_Build6039.java:218)
at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6039$AssociationVisitor.visit(UpgradeTask_Build6039.java:193)
at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl$3.consume(SelectQueryImpl.java:147)
at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.consumeWith(SelectQueryImpl.java:129)
at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.visitWith(SelectQueryImpl.java:142)
at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6039.updateNamesToLowercase(UpgradeTask_Build6039.java:174)
at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6039.updateSimpleColumn(UpgradeTask_Build6039.java:144)
at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6039.doUpgrade(UpgradeTask_Build6039.java:95)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:673)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:526)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:456)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:399)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:333)
at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:100)
at com.atlassian.jira.upgrade.UpgradeLauncher.start(UpgradeLauncher.java:49)
at com.atlassian.jira.startup.DefaultJiraLauncher$3.run(DefaultJiraLauncher.java:117)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:315)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:209)
at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:105)
at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:30)
at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:69)
at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:33)
at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:64)
at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:54)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

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