Uploaded image for project: 'JIRA Service Desk Server'
  1. JIRA Service Desk Server
  2. JSDSERVER-4147

Delete Project After Deactivated SD Will Not Remove Customer Portal

    XMLWordPrintable

    Details

      Description

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

      Summary

      Delete an SD project after deactivated JSD, customer portal will still remain in the database.

      Environment

      Service Desk Version - 3.3.0-OD-1000.82.0

      Steps to Reproduce

      1. Create an SD project with key DESK
      2. Deactivate SD(on PRD via Gear Icon->User management->Billing->Manage applications)
      3. Delete SD project

      Expected Results

      Customer Portal of that project will be removed.

      Actual Results

      Customer Portal is not removed. After re-activate SD, we will not able to create an SD project call DESK as the customer portal exists.

      Error message on UI:

      Hmm... we couldn't create your project due to an unknown error. Try refreshing the page to start again.

      @4000000057a9752608ec7e14 2016-08-09 01:15:56,135 http-nio-3009-exec-55 ERROR sysadmin 75x13836x1 1n2t2cu 103.233.242.8 /rest/project-templates/1.0/templates [c.a.j.project.ProjectCreateRegistrarImpl.privacy-safe] The handler with id com.atlassian.jira.project-templates-plugin:apply-project-template-handler threw an exception while handling a notification about a project being created
      @4000000057a9752608ec89cc com.querydsl.core.QueryException: Caught PSQLException for delete from "public"."AO_54307E_GROUP" where "AO_54307E_GROUP"."VIEWPORT_ID" = ?
      @4000000057a9752608ed7044       at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
      @4000000057a9752608ed7044       at com.querydsl.sql.Configuration.translate(Configuration.java:453)
      @4000000057a9752608ed742c       at com.querydsl.sql.dml.SQLDeleteClause.execute(SQLDeleteClause.java:209)
      ...
      @4000000057a9752608f18ef4 Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "AO_54307E_GROUP" violates foreign key constraint "fk_ao_54307e_grouptorequesttype_group_id" on table "AO_54307E_GROUPTOREQUESTTYPE"
      @4000000057a9752608f192dc   Detail: Key (ID)=(1) is still referenced from table "AO_54307E_GROUPTOREQUESTTYPE".
      

      Workaround

      Use a different case order as it is case sensitive.
      For example, desk was used by existing customer portal, you could name your new SD project name as DESK or Desk.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              cteh Chiou Ting Teh
              Votes:
              4 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated: