Details
-
Bug
-
Resolution: Won't Fix
-
Low
-
5
-
Severity 3 - Minor
-
Description
NOTE: This bug report is for JIRA Service Desk Cloud. Using JIRA Service Desk Server? 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
- Create an SD project with key DESK
- Deactivate SD(on PRD via Gear Icon->User management->Billing->Manage applications)
- 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
- is related to
-
-
- Gathering Impact
-