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
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.