Uploaded image for project: 'Jira Service Management Cloud'
  1. Jira Service Management Cloud
  2. JSDCLOUD-3232

Automation throws 'error.retrieving.project' WARN stack traces in the logs.

      NOTE: This bug report is for JIRA Service Desk Cloud. Using JIRA Service Desk Server? See the corresponding bug report.

      Summary:

      There will be multiple WARN stack traces in the logs in regards of JIRA Service Desk Automation.

      Steps to Reproduce.

      1. Create two Service Desk Project, e.g. SD A and SD B.
      2. On "SD B" navigate to the Project Administration > Automation.
      3. Create a "Reopen on Customer Comment" rule and confirm.
      4. Run the following Query:
        select p.id,p.pname,pr."PROJECT_ID",rl."NAME",rl."DESCRIPTION",wh."MODULE_KEY" from "project" p 
        right join "AO_9B2E3B_RSETREV_PROJ_CONTEXT" pr on (p.id = pr."PROJECT_ID")
        join "AO_9B2E3B_RULESET_REVISION" rl on (pr."RULESET_REVISION_ID" = rl."RULE_SET_ID")
        join "AO_9B2E3B_WHEN_HANDLER_CONFIG" wh on (rl."ID" = wh."ID");
        
      5. There will be a result for each project Automation Rule.
      6. Navigate to "SD B" project administration and delete the project.
      7. Create a Request in "SD A" and Resolved the ticket.
      8. As the Reporter, access the ticket in "Customer Portal" view and comment on the ticket.

      Expected Result:

      • Nothing happen as there is no "Reopen on Customer Comment" rule in "SD A" without any stack trace in the logs.

      Actual Result:

      • Nothing happen as well but there will be a WARN stack trace like below written in the logs.
        2016-01-01 20:44:14,471 http-nio-8705-exec-4 WARN admin 1244x2604x1 1rreza0 0:0:0:0:0:0:0:1 /rest/servicedesk/1/servicedesk/customer/comment [c.a.s.p.a.i.e.whenhandler.event.AllEventListenerEventWhenHandlerVisitor] Event when handler execution of com.atlassian.servicedesk.plugins.automation.servicedesk-automation-modules-plugin:servicedesk-commented-automation-rule-event-when-handler failed with error error.retrieving.project : 'error.retrieving.project'
        2016-01-01 20:44:14,471 http-nio-8705-exec-4 WARN admin 1244x2604x1 1rreza0 0:0:0:0:0:0:0:1 /rest/servicedesk/1/servicedesk/customer/comment [c.a.s.p.a.i.e.whenhandler.event.AllEventListenerEventWhenHandlerVisitor] Event when handler execution of com.atlassian.servicedesk.plugins.automation.servicedesk-automation-modules-plugin:servicedesk-commented-automation-rule-event-when-handler failed with error error.retrieving.project : 'error.retrieving.project'
        2016-01-01 20:44:14,471 http-nio-8705-exec-4 WARN admin 1244x2604x1 1rreza0 0:0:0:0:0:0:0:1 /rest/servicedesk/1/servicedesk/customer/comment [c.a.s.p.a.i.e.whenhandler.event.AllEventListenerEventWhenHandlerVisitor] Event when handler execution of com.atlassian.servicedesk.plugins.automation.servicedesk-automation-modules-plugin:servicedesk-commented-automation-rule-event-when-handler failed with error error.retrieving.project : 'error.retrieving.project'
        

      Notes:

      • Run the same query below and there will be an automation rule that did not have any project specified as it is deleted:
        select p.id,p.pname,pr."PROJECT_ID",rl."NAME",rl."DESCRIPTION",wh."MODULE_KEY" from "project" p 
        right join "AO_9B2E3B_RSETREV_PROJ_CONTEXT" pr on (p.id = pr."PROJECT_ID")
        join "AO_9B2E3B_RULESET_REVISION" rl on (pr."RULESET_REVISION_ID" = rl."RULE_SET_ID")
        join "AO_9B2E3B_WHEN_HANDLER_CONFIG" wh on (rl."ID" = wh."ID");
        

      • If we delete an existing Automation Rule while the Project is still exist, the row about that automation rule will still be exist.
      • Tried to do the same for an Automation Rule that is deleted while the Project is still exist could not replicate the same stack trace to be thrown.
      • This is WARN stack trace, it should not affect JIRA operations as it is a WARNING.

            [JSDCLOUD-3232] Automation throws 'error.retrieving.project' WARN stack traces in the logs.

            jhaloot made changes -
            Workflow Original: JAC Bug Workflow v3 [ 3444648 ] New: JAC Bug Workflow v4 [ 4564532 ]
            Raafi Mohammed made changes -
            Labels Original: affects-cloud affects-server pse-request New: affects-cloud affects-server nav-reviewed pse-request
            Monique Khairuliana (Inactive) made changes -
            Workflow Original: JSD Bug Workflow v5 - TEMP [ 2303475 ] New: JAC Bug Workflow v3 [ 3444648 ]
            Status Original: Done [ 10044 ] New: Closed [ 6 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 [ 2057422 ] New: JSD Bug Workflow v5 - TEMP [ 2303475 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 - TEMP [ 2055132 ] New: JSD Bug Workflow v5 [ 2057422 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v5 [ 1954807 ] New: JSD Bug Workflow v5 - TEMP [ 2055132 ]
            Katherine Yabut made changes -
            Workflow Original: JSD Bug Workflow v4 [ 1871605 ] New: JSD Bug Workflow v5 [ 1954807 ]
            jonah (Inactive) made changes -
            Description Original: h3. Summary:
            There will be multiple WARN stack traces in the logs in regards of JIRA Service Desk Automation.

            h3. Steps to Reproduce.
            # Create two Service Desk Project, e.g. SD A and SD B.
            # On "SD B" navigate to the _Project Administration > Automation_.
            # Create a "Reopen on Customer Comment" rule and confirm.
            # Run the following Query:
            {code:sql}
            select p.id,p.pname,pr."PROJECT_ID",rl."NAME",rl."DESCRIPTION",wh."MODULE_KEY" from "project" p
            right join "AO_9B2E3B_RSETREV_PROJ_CONTEXT" pr on (p.id = pr."PROJECT_ID")
            join "AO_9B2E3B_RULESET_REVISION" rl on (pr."RULESET_REVISION_ID" = rl."RULE_SET_ID")
            join "AO_9B2E3B_WHEN_HANDLER_CONFIG" wh on (rl."ID" = wh."ID");
            {code}
            # There will be a result for each project Automation Rule.
            # Navigate to "SD B" project administration and delete the project.
            # Create a Request in "SD A" and Resolved the ticket.
            # As the Reporter, access the ticket in "Customer Portal" view and comment on the ticket.

            h3. Expected Result:
            * Nothing happen as there is no "Reopen on Customer Comment" rule in "SD A" without any stack trace in the logs.

            h3. Actual Result:
            * Nothing happen as well but there will be a WARN stack trace like below written in the logs.
            {code}
            2016-01-01 20:44:14,471 http-nio-8705-exec-4 WARN admin 1244x2604x1 1rreza0 0:0:0:0:0:0:0:1 /rest/servicedesk/1/servicedesk/customer/comment [c.a.s.p.a.i.e.whenhandler.event.AllEventListenerEventWhenHandlerVisitor] Event when handler execution of com.atlassian.servicedesk.plugins.automation.servicedesk-automation-modules-plugin:servicedesk-commented-automation-rule-event-when-handler failed with error error.retrieving.project : 'error.retrieving.project'
            2016-01-01 20:44:14,471 http-nio-8705-exec-4 WARN admin 1244x2604x1 1rreza0 0:0:0:0:0:0:0:1 /rest/servicedesk/1/servicedesk/customer/comment [c.a.s.p.a.i.e.whenhandler.event.AllEventListenerEventWhenHandlerVisitor] Event when handler execution of com.atlassian.servicedesk.plugins.automation.servicedesk-automation-modules-plugin:servicedesk-commented-automation-rule-event-when-handler failed with error error.retrieving.project : 'error.retrieving.project'
            2016-01-01 20:44:14,471 http-nio-8705-exec-4 WARN admin 1244x2604x1 1rreza0 0:0:0:0:0:0:0:1 /rest/servicedesk/1/servicedesk/customer/comment [c.a.s.p.a.i.e.whenhandler.event.AllEventListenerEventWhenHandlerVisitor] Event when handler execution of com.atlassian.servicedesk.plugins.automation.servicedesk-automation-modules-plugin:servicedesk-commented-automation-rule-event-when-handler failed with error error.retrieving.project : 'error.retrieving.project'
            {code}

            h3. Notes:
            * Run the same query below and there will be an automation rule that did not have any project specified as it is deleted:
            {code:sql}
            select p.id,p.pname,pr."PROJECT_ID",rl."NAME",rl."DESCRIPTION",wh."MODULE_KEY" from "project" p
            right join "AO_9B2E3B_RSETREV_PROJ_CONTEXT" pr on (p.id = pr."PROJECT_ID")
            join "AO_9B2E3B_RULESET_REVISION" rl on (pr."RULESET_REVISION_ID" = rl."RULE_SET_ID")
            join "AO_9B2E3B_WHEN_HANDLER_CONFIG" wh on (rl."ID" = wh."ID");
            {code}
             !Screen Shot 2016-01-01 at 6.25.49 PM.png|thumbnail!
            * If we delete an existing Automation Rule while the Project is still exist, the row about that automation rule will still be exist.
            * Tried to do the same for an Automation Rule that is deleted while the Project is still exist could not replicate the same stack trace to be thrown.
            * This is WARN stack trace, it should not affect JIRA operations as it is a WARNING.
            New: {panel:bgColor=#e7f4fa}
              *NOTE:* This bug report is for *JIRA Service Desk Cloud*. Using *JIRA Service Desk Server*? [See the corresponding bug report|http://jira.atlassian.com/browse/JSDSERVER-3232].
              {panel}

            h3. Summary:
            There will be multiple WARN stack traces in the logs in regards of JIRA Service Desk Automation.

            h3. Steps to Reproduce.
            # Create two Service Desk Project, e.g. SD A and SD B.
            # On "SD B" navigate to the _Project Administration > Automation_.
            # Create a "Reopen on Customer Comment" rule and confirm.
            # Run the following Query:
            {code:sql}
            select p.id,p.pname,pr."PROJECT_ID",rl."NAME",rl."DESCRIPTION",wh."MODULE_KEY" from "project" p
            right join "AO_9B2E3B_RSETREV_PROJ_CONTEXT" pr on (p.id = pr."PROJECT_ID")
            join "AO_9B2E3B_RULESET_REVISION" rl on (pr."RULESET_REVISION_ID" = rl."RULE_SET_ID")
            join "AO_9B2E3B_WHEN_HANDLER_CONFIG" wh on (rl."ID" = wh."ID");
            {code}
            # There will be a result for each project Automation Rule.
            # Navigate to "SD B" project administration and delete the project.
            # Create a Request in "SD A" and Resolved the ticket.
            # As the Reporter, access the ticket in "Customer Portal" view and comment on the ticket.

            h3. Expected Result:
            * Nothing happen as there is no "Reopen on Customer Comment" rule in "SD A" without any stack trace in the logs.

            h3. Actual Result:
            * Nothing happen as well but there will be a WARN stack trace like below written in the logs.
            {code}
            2016-01-01 20:44:14,471 http-nio-8705-exec-4 WARN admin 1244x2604x1 1rreza0 0:0:0:0:0:0:0:1 /rest/servicedesk/1/servicedesk/customer/comment [c.a.s.p.a.i.e.whenhandler.event.AllEventListenerEventWhenHandlerVisitor] Event when handler execution of com.atlassian.servicedesk.plugins.automation.servicedesk-automation-modules-plugin:servicedesk-commented-automation-rule-event-when-handler failed with error error.retrieving.project : 'error.retrieving.project'
            2016-01-01 20:44:14,471 http-nio-8705-exec-4 WARN admin 1244x2604x1 1rreza0 0:0:0:0:0:0:0:1 /rest/servicedesk/1/servicedesk/customer/comment [c.a.s.p.a.i.e.whenhandler.event.AllEventListenerEventWhenHandlerVisitor] Event when handler execution of com.atlassian.servicedesk.plugins.automation.servicedesk-automation-modules-plugin:servicedesk-commented-automation-rule-event-when-handler failed with error error.retrieving.project : 'error.retrieving.project'
            2016-01-01 20:44:14,471 http-nio-8705-exec-4 WARN admin 1244x2604x1 1rreza0 0:0:0:0:0:0:0:1 /rest/servicedesk/1/servicedesk/customer/comment [c.a.s.p.a.i.e.whenhandler.event.AllEventListenerEventWhenHandlerVisitor] Event when handler execution of com.atlassian.servicedesk.plugins.automation.servicedesk-automation-modules-plugin:servicedesk-commented-automation-rule-event-when-handler failed with error error.retrieving.project : 'error.retrieving.project'
            {code}

            h3. Notes:
            * Run the same query below and there will be an automation rule that did not have any project specified as it is deleted:
            {code:sql}
            select p.id,p.pname,pr."PROJECT_ID",rl."NAME",rl."DESCRIPTION",wh."MODULE_KEY" from "project" p
            right join "AO_9B2E3B_RSETREV_PROJ_CONTEXT" pr on (p.id = pr."PROJECT_ID")
            join "AO_9B2E3B_RULESET_REVISION" rl on (pr."RULESET_REVISION_ID" = rl."RULE_SET_ID")
            join "AO_9B2E3B_WHEN_HANDLER_CONFIG" wh on (rl."ID" = wh."ID");
            {code}
             !Screen Shot 2016-01-01 at 6.25.49 PM.png|thumbnail!
            * If we delete an existing Automation Rule while the Project is still exist, the row about that automation rule will still be exist.
            * Tried to do the same for an Automation Rule that is deleted while the Project is still exist could not replicate the same stack trace to be thrown.
            * This is WARN stack trace, it should not affect JIRA operations as it is a WARNING.
            jonah (Inactive) made changes -
            Link New: This issue is related to JSDSERVER-3232 [ JSDSERVER-3232 ]
            vkharisma made changes -
            Project Import New: Sun Apr 02 00:24:18 UTC 2017 [ 1491092658763 ]

              pgreig Paul Greig
              jrahmadiputra Julian (Inactive)
              Affected customers:
              6 This affects my team
              Watchers:
              11 Start watching this issue

                Created:
                Updated:
                Resolved: