Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Getting this Exception when updating the SubTask

Script is running successfully not sure whiat causing this exception 



2019-12-06 06:20:23,627 ERROR [workflow.AbstractScriptWorkflowFunction]: ************************************************************************************* 2019-12-06 06:20:23,628 ERROR [workflow.AbstractScriptWorkflowFunction]: Script function failed on issue: null, actionId: 1, file: null com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:NodeAssociation][sinkNodeId,11731][associationType,IssueComponent][sourceNodeId,null][sourceNodeEntity,Issue][sinkNodeEntity,Component] (SQL Exception while executing the following:INSERT INTO public.nodeassociation (SOURCE_NODE_ID, SOURCE_NODE_ENTITY, SINK_NODE_ID, SINK_NODE_ENTITY, ASSOCIATION_TYPE, SEQUENCE) VALUES (?, ?, ?, ?, ?, ?) (ERROR: null value in column "source_node_id" violates not-null constraint Detail: Failing row contains (null, Issue, 11731, Component, IssueComponent, null).)) at com.atlassian.jira.association.NodeAssociationStoreImpl.createAssociation(NodeAssociationStoreImpl.java:93) at com.atlassian.jira.association.NodeAssociationStoreImpl.createAssociation(NodeAssociationStoreImpl.java:74) at com.atlassian.jira.bc.project.component.DefaultProjectComponentManager.updateIssueValue(DefaultProjectComponentManager.java:233) at com.atlassian.jira.bc.project.component.DefaultProjectComponentManager.updateIssueProjectComponents(DefaultProjectComponentManager.java:217) at com.atlassian.jira.issue.fields.ComponentsSystemField.updateIssueValue(ComponentsSystemField.java:438) at com.atlassian.jira.issue.fields.ComponentsSystemField.updateValue(ComponentsSystemField.java:411) at com.atlassian.jira.issue.managers.DefaultIssueManager.updateFieldValues(DefaultIssueManager.java:708) at com.atlassian.jira.issue.managers.DefaultIssueManager.updateIssue(DefaultIssueManager.java:673) at com.atlassian.jira.issue.managers.RequestCachingIssueManager.updateIssue(RequestCachingIssueManager.java:219) at com.atlassian.jira.issue.IssueManager$updateIssue$0.call(Unknown Source) at Script1241.run(Script1241.groovy:35) Caused by: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:NodeAssociation][sinkNodeId,11731][associationType,IssueComponent][sourceNodeId,null][sourceNodeEntity,Issue][sinkNodeEntity,Component] (SQL Exception while executing the following:INSERT INTO public.nodeassociation (SOURCE_NODE_ID, SOURCE_NODE_ENTITY, SINK_NODE_ID, SINK_NODE_ENTITY, ASSOCIATION_TYPE, SEQUENCE) VALUES (?, ?, ?, ?, ?, ?) (ERROR: null value in column "source_node_id" violates not-null constraint Detail: Failing row contains (null, Issue, 11731, Component, IssueComponent, null).)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:206) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:171) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:89) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:562) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:548) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:114) at com.atlassian.jira.association.NodeAssociationStoreImpl.createAssociation(NodeAssociationStoreImpl.java:91) ... 10 more Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.nodeassociation (SOURCE_NODE_ID, SOURCE_NODE_ENTITY, SINK_NODE_ID, SINK_NODE_ENTITY, ASSOCIATION_TYPE, SEQUENCE) VALUES (?, ?, ?, ?, ?, ?) (ERROR: null value in column "source_node_id" violates not-null constraint Detail: Failing row contains (null, Issue, 11731, Component, IssueComponent, null).) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:570) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:198) ... 16 more Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "source_node_id" violates not-null constraint Detail: Failing row contains (null, Issue, 11731, Component, IssueComponent, null). at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:135) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:562) ... 17 more

 

1 answer

0 votes
Andy Heinzer Atlassian Team Dec 20, 2019

Hi Anubhav Agrawal,

I see that you are getting a stacktrace when a workflow action is happening.  From reviewing this I can see that you're using a postgresql database.  And that column "source_node_id" in the nodeassociation table is unable to store a null value because there is a constraint in that table of the SQL database against storing such null values for that field.

That said, it's not clear to me yet what is causing this. I have not found any other reports of this specific error that clearly indicate a cause.

  1. What version of Jira is this? 
  2. Is this by chance a Jira Data Center deployment?  

I suspect that you have a postfunction in the workflow that is trying to save some value, but it is unable to do so in the current setup/configuration.

Perhaps you have some plugin to Jira that is providing some additional post function actions here?  If we could establish which plugin that is here, perhaps we could better direct you in regards to which plugin vendor to seek support from in regards to this issue.

Please let me know the results.

Andy

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you