com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.))

Atlassian JIRA | Marcus Silveira [Atlassian] | 2 years ago
  1. 0

    While importing a project from a JIRA backup the import fails with the following error. {noformat} The import was aborted because there were too many errors. Some errors are listed below. For full details about the errors please see your logs. Please note that some elements have been created. You may want to consult your logs to see what caused the errors, delete the project, and perform the import again. {noformat} A few of the following errors can be found in the JIRA logs {noformat} 2015-01-17 15:01:50,542 ProjectImport: CreateIssueRelatedData-10 ERROR admin 901x156x1 4bmvmr 127.0.0.1 /secure/admin/ProjectImportSummary.jspa [jira.imports.project.DefaultProjectImportPersister] DataAccessException occured while trying to create Entity type 'EntityProperty' . {id=10031, entityName=IssueProperty, entityId=10115, propertyKey=request.channel.type, value="Portal", created=2015-01-08 18:51:44.178, updated=2015-01-08 18:51:44.178} com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.)) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:397) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219) at com.atlassian.jira.imports.project.DefaultProjectImportPersister.createEntity(DefaultProjectImportPersister.java:192) at com.atlassian.jira.imports.project.handler.EntityPropertiesPersisterHandler$1.run(EntityPropertiesPersisterHandler.java:63) at com.atlassian.jira.util.concurrent.BoundedExecutor$1.run(BoundedExecutor.java:50) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:695) Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:200) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:392) ... 7 more {noformat} *Steps to reproduce* # Get a JIRA backup from an instance with at least 20 Issue entities for a single project. e.g. create 10 issues with JIRA Service Desk. Each will add 3 issue entities ** You can verify that with the following SQL query {code:SQL}select * from entity_property where entity_name = 'IssueProperty'{code} # Import the project into another JIRA instance already containing data in the entity_property for the same IDs displayed in the query above *Expected results* JIRA Should import the project without any problems, using the next ID available for the entity_property table *Actual results* JIRA aborts the import as it tries to use the same IDs to add the respective Issue properties to the entity_properties table *Workaround* As a workaround you can change the EntityProperty IDs _directly in the entities.xml file of the backup_. # Find entity IDs to change for the project. Run this at source JIRA Insert your project key into this query: {code:sql} SELECT EP.id FROM entity_property EP, jiraissue I, project P WHERE EP.entity_name = 'IssueProperty' AND I.id = EP.entity_id AND P.id = I.project AND P.pkey = 'YOUR_PROJECT_KEY' ORDER BY EP.id; {code} # Determine the current MAX(id), run this at target JIRA: {code:sql} SELECT MAX(id) FROM entity_property {code} # Modify the XML backup file, replacing the entity_property IDs with sequential numbers higher than MAX(id) from the entity_property table. #* Make sure you only modify XML nodes that begin with "<EntityProperty id=". If the entities.xml file is large you may need to use vi or another editor that can handle really big files. # Complete the import # Shut down the target instance # Reset the sequence_value_item table for EntityProperty types, run this at target JIRA: {code:sql} UPDATE sequence_value_item SET seq_id = (SELECT MAX(id)+100 FROM entity_property) WHERE seq_name = 'EntityProperty'; {code} # Restart the target instance See KB for more detailed steps and simplified option to modify the XML backup file: [Project Import fails due to too many errors|https://confluence.atlassian.com/display/JIRAKB/Project+Import+fails+due+to+too+many+errors]

    Atlassian JIRA | 2 years ago | Marcus Silveira [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.))
  2. 0

    While importing a project from a JIRA backup the import fails with the following error. {noformat} The import was aborted because there were too many errors. Some errors are listed below. For full details about the errors please see your logs. Please note that some elements have been created. You may want to consult your logs to see what caused the errors, delete the project, and perform the import again. {noformat} A few of the following errors can be found in the JIRA logs {noformat} 2015-01-17 15:01:50,542 ProjectImport: CreateIssueRelatedData-10 ERROR admin 901x156x1 4bmvmr 127.0.0.1 /secure/admin/ProjectImportSummary.jspa [jira.imports.project.DefaultProjectImportPersister] DataAccessException occured while trying to create Entity type 'EntityProperty' . {id=10031, entityName=IssueProperty, entityId=10115, propertyKey=request.channel.type, value="Portal", created=2015-01-08 18:51:44.178, updated=2015-01-08 18:51:44.178} com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.)) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:397) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219) at com.atlassian.jira.imports.project.DefaultProjectImportPersister.createEntity(DefaultProjectImportPersister.java:192) at com.atlassian.jira.imports.project.handler.EntityPropertiesPersisterHandler$1.run(EntityPropertiesPersisterHandler.java:63) at com.atlassian.jira.util.concurrent.BoundedExecutor$1.run(BoundedExecutor.java:50) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:695) Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:200) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:392) ... 7 more {noformat} *Steps to reproduce* # Get a JIRA backup from an instance with at least 20 Issue entities for a single project. e.g. create 10 issues with JIRA Service Desk. Each will add 3 issue entities ** You can verify that with the following SQL query {code:SQL}select * from entity_property where entity_name = 'IssueProperty'{code} # Import the project into another JIRA instance already containing data in the entity_property for the same IDs displayed in the query above *Expected results* JIRA Should import the project without any problems, using the next ID available for the entity_property table *Actual results* JIRA aborts the import as it tries to use the same IDs to add the respective Issue properties to the entity_properties table *Workaround* As a workaround you can change the EntityProperty IDs _directly in the entities.xml file of the backup_. # Find entity IDs to change for the project. Run this at source JIRA Insert your project key into this query: {code:sql} SELECT EP.id FROM entity_property EP, jiraissue I, project P WHERE EP.entity_name = 'IssueProperty' AND I.id = EP.entity_id AND P.id = I.project AND P.pkey = 'YOUR_PROJECT_KEY' ORDER BY EP.id; {code} # Determine the current MAX(id), run this at target JIRA: {code:sql} SELECT MAX(id) FROM entity_property {code} # Modify the XML backup file, replacing the entity_property IDs with sequential numbers higher than MAX(id) from the entity_property table. #* Make sure you only modify XML nodes that begin with "<EntityProperty id=". If the entities.xml file is large you may need to use vi or another editor that can handle really big files. # Complete the import # Shut down the target instance # Reset the sequence_value_item table for EntityProperty types, run this at target JIRA: {code:sql} UPDATE sequence_value_item SET seq_id = (SELECT MAX(id)+100 FROM entity_property) WHERE seq_name = 'EntityProperty'; {code} # Restart the target instance See KB for more detailed steps and simplified option to modify the XML backup file: [Project Import fails due to too many errors|https://confluence.atlassian.com/display/JIRAKB/Project+Import+fails+due+to+too+many+errors]

    Atlassian JIRA | 2 years ago | Marcus Silveira [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.))
  3. 0

    [JRA-40757] JIRA upgrade fails when DB contains rows in QuartzScheduledJobDetails, FATAL upgrade failure with SQLException ...from com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302 - Atlassian JIRA

    atlassian.com | 1 year ago
    org.ofbiz.core.entity.GenericEntityException: inserting: [GenericEntity:JQRTZJobDetails][jobName,TIMESH EET_SUBSCRIPTION][requestsRecovery, ][isVolatile, ][className,jira.timesheet.plugin.job.TimesheetJob] [isDurable, ][jobGroup,TIMESHEET_SUBSCRIPTION][isStateful, ] (SQL Exception setting value: (Inv alid column type: 2000))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    In a JIRA func test run, I saw this happen: {noformat} 2014-05-16 10:45:08,341 http-bio-18400-exec-4 INFO admin 645x805x1 h6le6z 127.0.0.1 /rest/testkit-test/1.0/log/info [jira.testkit.plugin.LogAccess] ===FTC () Started : com.atlassian.jira.webtests.ztests.subtask.TestIssueToSubTaskConver 2014-05-16 10:45:09,026 http-bio-18400-exec-1 WARN admin 645x817x1 1klyq9v 127.0.0.1 /rest/testkit-test/1.0/dataImport [jira.bc.dataimport.DataImportProductionDependencies] QuickImport is on, doing a fast refresh. 2014-05-16 10:45:09,411 http-bio-18400-exec-1 INFO admin 645x817x1 1klyq9v 127.0.0.1 /rest/testkit-test/1.0/dataImport [jira.whatsnew.listeners.WhatsNewUpgradeFinishedListenerImpl] Disabling show-whats-new-flag for all users 2014-05-16 10:45:12,520 http-bio-18400-exec-5 INFO admin 645x827x1 gt0ibq 127.0.0.1 /rest/testkit-test/1.0/log/info [jira.testkit.plugin.LogAccess] ===FTC () Finished : com.atlassian.jira.webtests.ztests.subtask.TestIssueToSubTaskConve ______________________________ 2014-05-16 10:45:12,578 http-bio-18400-exec-8 INFO admin 645x828x1 qgmu7x 127.0.0.1 /rest/testkit-test/1.0/log/info [jira.testkit.plugin.LogAccess] ===FTC () Started : com.atlassian.jira.webtests.ztests.admin.issuetypes.TestMultiIssueT 2014-05-16 10:45:13,604 http-bio-18400-exec-10 INFO admin 645x843x1 1m5x8i8 127.0.0.1 /secure/admin/XmlRestore.jspa [web.action.util.ImportAll] Running ImportAll 2014-05-16 10:45:13,899 JIRA-Import-Thread-265 ERROR admin 645x843x1 1m5x8i8 127.0.0.1 /secure/admin/XmlRestore.jspa [jira.action.admin.OfbizImportHandler] Exception importing entity: org.ofbiz.core.entity.GenericEntityException: while org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:SequenceValueItem][seqId,11000][seqName,RunDetails] (SQL Exception while executing the following:INSERT INTO PUBLIC.SEQUENCE_VALUE_ITEM (SEQ_NAME, SEQ_ID) VA at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:200) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.action.admin.OfbizImportHandler.createWithDeadlockRetry(OfbizImportHandler.java:712) at com.atlassian.jira.action.admin.OfbizImportHandler$1.run(OfbizImportHandler.java:681) at com.atlassian.jira.util.concurrent.BoundedExecutor$1.run(BoundedExecutor.java:50) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO PUBLIC.SEQUENCE_VALUE_ITEM (SEQ_NAME, SEQ_ID) VALUES (?, ?) (Unique constraint violation: SYS_IDX_181 in statement [INSERT INTO P at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:650) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:192) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.action.admin.OfbizImportHandler.createWithDeadlockRetry(OfbizImportHandler.java:712) at com.atlassian.jira.action.admin.OfbizImportHandler$1.run(OfbizImportHandler.java:681) at com.atlassian.jira.util.concurrent.BoundedExecutor$1.run(BoundedExecutor.java:50) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) java.sql.SQLException: Unique constraint violation: SYS_IDX_181 in statement [INSERT INTO PUBLIC.SEQUENCE_VALUE_ITEM (SEQ_NAME, SEQ_ID) VALUES (?, ?)] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:640) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:192) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.action.admin.OfbizImportHandler.createWithDeadlockRetry(OfbizImportHandler.java:712) {noformat} The only explanation I can think of for what could have happened here is # {{TestIssueToSubTaskConversionParentPickerSameIssue}} uses a restore file that includes scheduled tasks (even if it didn't, plugin jobs will be present anyway) # One of these jobs was in the middle of running when the import started # The scheduler was placed in {{standby()}} mode, but this does not terminate running jobs or wait for jobs to complete before returning, so the job continued unaware. # The import started, purged all existing data, and started to insert the values from the restore file # The running job completed and tried to record its status to the {{RunDetailsDao}} # Finding that there was no {{SequenceValueItem}} to generate IDs for {{RunDetails}} entities, it created a new one # The import continued until it got to the {{SequenceValueItem}} for {{RunDetails}} that is in {{blankprojects.xml}} (what {{TestMultiIssueTypes}} uses for its restore file), at which point it hit the unique constraint on the attempted {{INSERT}}. It is hard to know what to do about this. We really don't want scheduler jobs to continue executing when we shut down the scheduler. We don't want to wait for them to finish (which could take a long time), but we can't be sure that it is safe to terminate them forcibly, either. It's a bit ugly if a job started by the previous incarnation of the system records run details from a job that existed before the import blew it away and no longer does (or may even be an entirely different job, meaning the details are garbage). The reality is that this is not likely to happen to a production system, but the consequences are rather severe (locked JIRA, flakiness of func tests, poor explanation of the problem, and possible temporary data corruption), so it seems appropriate to do *something* to deal with this -- I'm just not sure *what*, yet.

    Atlassian JIRA | 3 years ago | Chris Fuller
    org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:SequenceValueItem][seqId,11000][seqName,RunDetails] (SQL Exception while executing the following:INSERT INTO PUBLIC.SEQUENCE_VALUE_ITEM (SEQ_NAME, SEQ_ID) VA
  6. 0

    When upgrading JIRA 5.1.5 to 6.3 (using MS SQL Server) user reported a following exception: {code} An error occurred performing JIRA upgrade task 2014-05-29 09:59:20 error Exception thrown during upgrade: while inserting: [GenericEntity:JQRTZJobDetails][requestsRecovery,false][jobGroup,TIMESHEET_SUBSCRIPTION][className,jira.timesheet.plugin.job.TimesheetJob][isDurable,true][jobName,TIMESHEET_SUBSCRIPTION][isVolatile,false][isStateful,false] (SQL Exception while executing the following:INSERT INTO JQUARTZ_JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The TDS protocol does not support JDBC datatype 2000.)) org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:JQRTZJobDetails][requestsRecovery,false][jobGroup,TIMESHEET_SUBSCRIPTION][className,jira.timesheet.plugin.job.TimesheetJob][isDurable,true][jobName,TIMESHEET_SUBSCRIPTION][isVolatile,false][isStateful,false] (SQL Exception while executing the following:INSERT INTO JQUARTZ_JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The TDS protocol does not support JDBC datatype 2000.)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:200) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:687) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:536) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:465) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:407) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:342) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.upgradeJira(DefaultDataImportService.java:823) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:711) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:299) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:66) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:29) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:150) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO JQUARTZ_JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The TDS protocol does not support JDBC datatype 2000.) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:650) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:192) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:687) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:536) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:465) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:407) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:342) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.upgradeJira(DefaultDataImportService.java:823) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:711) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:299) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:66) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:29) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:150) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) java.sql.SQLException: The TDS protocol does not support JDBC datatype 2000. at net.sourceforge.jtds.jdbc.TdsData.getNativeType(TdsData.java:1537) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:654) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:640) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:192) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:687) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:536) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:465) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:407) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:342) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.upgradeJira(DefaultDataImportService.java:823) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:711) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:299) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:66) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:29) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:150) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) {code}

    Atlassian JIRA | 2 years ago | Pawel Niewiadomski [Atlassian]
    org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:JQRTZJobDetails][requestsRecovery,false][jobGroup,TIMESHEET_SUBSCRIPTION][className,jira.timesheet.plugin.job.TimesheetJob][isDurable,true][jobName,TIMESHEET_SUBSCRIPTION][isVolatile,false][isStateful,false] (SQL Exception while executing the following:INSERT INTO JQUARTZ_JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The TDS protocol does not support JDBC datatype 2000.))

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.ofbiz.core.entity.GenericEntityException

      while inserting: [GenericEntity:EntityProperty][id,10031][created,2015-01-08 18:51:44.178][updated,2015-01-08 18:51:44.178][entityId,10115][value,"Portal"][propertyKey,request.channel.type][entityName,IssueProperty] (SQL Exception while executing the following:INSERT INTO public.entity_property (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_entity_property" Detail: Key (id)=(10031) already exists.))

      at org.ofbiz.core.entity.GenericDAO.singleInsert()
    2. org.ofbiz.core
      GenericValue.create
      1. org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:200)
      2. org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165)
      3. org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83)
      4. org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554)
      5. org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540)
      6. org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98)
      6 frames
    3. com.atlassian.jira
      BoundedExecutor$1.run
      1. com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:392)
      2. com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:219)
      3. com.atlassian.jira.imports.project.DefaultProjectImportPersister.createEntity(DefaultProjectImportPersister.java:192)
      4. com.atlassian.jira.imports.project.handler.EntityPropertiesPersisterHandler$1.run(EntityPropertiesPersisterHandler.java:63)
      5. com.atlassian.jira.util.concurrent.BoundedExecutor$1.run(BoundedExecutor.java:50)
      5 frames
    4. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
      3. java.lang.Thread.run(Thread.java:695)
      3 frames