Getting an error message "Exception occurred while updating issue:" while creating a JIRA issue
I am getting the following error when creating a JIRA issue and I add a post-function of Add as watcher users in field Case Owner Username. Atlassian has determined that it's not an issue on their part.
Exception occurred while updating issue: com.atlassian.jira.workflow.WorkflowException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:UserAssociation][sinkNodeId,null][created,2014-05-23 11:38:03.627][associationType,WatchIssue][sourceName,paul.nienaber][sinkNodeEntity,Issue] (SQL Exception while executing the following:INSERT INTO public.userassociation (SOURCE_NAME, SINK_NODE_ID, SINK_NODE_ENTITY, ASSOCIATION_TYPE, SEQUENCE, CREATED) VALUES (?, ?, ?, ?, ?, ?) (ERROR: null value in column "sink_node_id" violates not-null constraint))
Comments (7)
-
repo owner -
Hi Fidel, The odd thing is that the error message did not have reference to JIRA workflow toolbox plug-in but what I ended up doing is removing the add as watcher in the workflow. I used the following: Add as watcher users in field Case Owner Username. Add as watcher users in field Escalation User
When I removed the above from my workflow, I was able to create a JIRA issue. Now, I am also using customware salesforce/JIRA connector and the two fields Case Owner and Escalation User are coming from the salesforce side.
Version of JIRA is 6.0.8 I can't give you a screenshot of the exception message (it's the same I posted earlier) because I removed the post-functions in order to be able to create these JIRA issues as production support team was down until this was fixed. I am attaching the screenshot of the post-function tab as well (minus the two add watcher ones I mentioned above)
-
- attached PostFunctionErrorJIRA.PNG
-
and I am using Installed version: 2.1.17 of your plugin
-
repo owner Please, ensure that you are inserting the post-functions after post-function "Create the issue originally", since before it the issue doesn't exist yet, and you can't add any watcher.
-
ok, thanks. I'll try this and see if it works. I did originally have it before the Create the issue originally before we upgraded to JIRA 6.0.8 and it worked fine. but i've now changed it and will test it
-
repo owner - changed status to resolved
I close the issue. Please, reopen it if given solution doesn't work.
- Log in to comment
Hi,
I don't see in that exception message any reference to JIRA Workflow Toolbox add-on.
I will need the following information, please:
Best regards,
Fidel