Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-4147

Delete Project After Deactivated SD Will Not Remove Customer Portal

XMLWordPrintable

      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.

            [JSDSERVER-4147] Delete Project After Deactivated SD Will Not Remove Customer Portal

            SET Analytics Bot made changes -
            UIS Original: 3 New: 2
            Conny Postma made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 196830 ]
            Marc Dacanay made changes -
            Labels Original: affects-cloud affects-server cqt New: affects-cloud affects-server cqt ril
            Marc Dacanay made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 954941 ]
            SET Analytics Bot made changes -
            UIS Original: 2 New: 3
            SET Analytics Bot made changes -
            UIS Original: 3 New: 2
            Bruno Moreira made changes -
            Remote Link Original: This issue links to "TESLA-812 (JDOG - JIRA Team Dogfood)" [ 193206 ] New: This issue links to "TESLA-812 (JDOG)" [ 193206 ]
            SET Analytics Bot made changes -
            Support reference count Original: 11 New: 12
            SET Analytics Bot made changes -
            UIS Original: 2 New: 3
            SET Analytics Bot made changes -
            Support reference count Original: 10 New: 11

              Unassigned Unassigned
              cteh Ting
              Affected customers:
              9 This affects my team
              Watchers:
              16 Start watching this issue

                Created:
                Updated: