[JSDSERVER-5713] Error when disabling account creation emails

Type: Bug
Resolution: Fixed
Priority: Low
Fix Version/s: 3.10.4, 3.11.4, 3.12.2
Affects Version/s: 3.10.0, 3.10.1, 3.10.2, 3.10.3, 3.11.0, 3.11.1, 3.11.2, 3.12.0, 3.12.1
Component/s: Email - Outgoing
Labels:
None

Symptom Severity:
Severity 3 - Minor
UIS:
3
Bug Fix Policy:
View Atlassian Server bug fix policy

Workaround

Note that multiple projects could be affected by this issue, so you might have to apply the same workaround to multiple projects:

Ensure to make a backup of DB before making any changes to it.
Shutdown JIRA.
Run the following query in the database to determine if there is any duplicate rows corresponding to the warning message:

 select * from "AO_54307E_CAPABILITY" where "CAPABILITY_NAME" like 'CUSTOMER_INVITE_EMAIL_SUPPRESSED%';

Let's assume that you got duplicate rows for a given pservice desk ID, as shown in the screenshot below (in this case, the project ID is 1):

The resolution consists in removing all the duplicate rows with the highest ID. In the example below, there are 2 duplicate rows for the service desk id 1 with the IDs 52 and 53, so the 2 rows below need to be deleted. If you see duplicate rows for other projects, please delete them as well. Note that the query below only applies to the example provided above. The IDs will likely be different in your instance.

 delete from "AO_54307E_CAPABILITY" where "ID" = '52'
 delete from "AO_54307E_CAPABILITY" where "ID" = '53'

Start up JIRA and verify.

i'm having a problem where the "do not send account verification emails" toggle will not stay checked "green"

as it stands, this means i can't actually disable the invite confirmation emails

we're running an eval of Jira software and core 7.7.2, and service desk 3.10.2, currently just on the h2 db

if i pull up google chrome's javascript console and click the toggle, the following is shown:

POST [https://jira.MY.FQDN/rest/servicedesk/notifications/1/customerinvite/34|https://jira.my.fqdn/rest/servicedesk/notifications/1/customerinvite/34] 409 ()
 (anonymous)
 XMLHttpRequest.send @ batch.js?agile_globa…erational=true:7006
 send @ batch.js:200
 ajax @ batch.js:194
 value @ context-sd.admin.out…6.js?locale=en-US:1
 value @ context-sd.admin.out…6.js?locale=en-US:1
 update @ context-sd.admin.out…6.js?locale=en-US:1
 value @ context-sd.admin.out…6.js?locale=en-US:1
 change #js-suppress-customer-invite-email @ context-sd.admin.out…6.js?locale=en-US:1
 dispatch @ batch.js:107
 h @ batch.js:99

Uncaught TypeError: t.forEach is not a function
 at Object.<anonymous> (context-sd.admin.out…6.js?locale=en-US:1)
 at j (batch.js:63)
 at Object.fireWith (batch.js:64)
 at Object.fire [as reject] (batch.js:64)
 at Object.<anonymous> (context-sd.admin.out…6.js?locale=en-US:1)
 at j (batch.js:63)
 at Object.fireWith [as rejectWith] (batch.js:64)
 at d (batch.js:189)
 at XMLHttpRequest.b (batch.js:201)
 has anyone else had this issue or similar?

—

edit: maybe i should note, this is running behind nginx for https

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List

Screen Shot 2018-04-16 at 14.30.26.png
114 kB
16/Apr/2018 7:04 AM

relates to

JSDSERVER-5972 Account verification email cannot be disabled.

Closed

JSDSERVER-1708 Provide ability to disable the welcome email to new customers

Closed

is duplicated by: JSDS-1841 You do not have permission to view this issue

Form Name

Owen made changes - 27/Mar/2019 5:47 AM

Workflow	Original: JSD Bug Workflow v5 - TEMP [ 2645873 ]	New: JAC Bug Workflow v3 [ 3126583 ]
Status	Original: Done [ 10044 ]	New: Closed [ 6 ]

Owen made changes - 24/Oct/2018 5:22 AM

Symptom Severity

Original: Minor [ 14432 ]

New: Severity 3 - Minor [ 15832 ]

Lachlan G (Inactive) made changes - 30/Aug/2018 6:13 AM

Link

New: This issue relates to ~~JSDSERVER-5972~~ [ ~~JSDSERVER-5972~~ ]

Lachlan G (Inactive) made changes - 10/May/2018 10:49 PM

Resolution		New: Fixed [ 1 ]
Status	Original: Awaiting Release [ 11372 ]	New: Done [ 10044 ]

moofoo (Inactive) made changes - 08/May/2018 11:54 PM

Fix Version/s		New: 3.11.4 [ 79806 ]
Fix Version/s	Original: 3.11.3 [ 79091 ]

Lachlan G (Inactive) made changes - 04/May/2018 5:10 AM

Description

Original: {panel:title=Workaround}
Note that multiple projects could be affected by this issue, so you might have to apply the same workaround to multiple projects:

Ensure to make a backup of DB before making any changes to it.
Shutdown JIRA.
Run the following query in the database to determine if there is any duplicate rows corresponding to the warning message:
{code:borderStyle=solid}
select * from "AO_54307E_CAPABILITY" where "CAPABILITY_NAME" like 'CUSTOMER_INVITE_EMAIL_SUPPRESSED%';
{code}
Let's assume that you got duplicate rows for a given pservice desk ID, as shown in the screenshot below (in this case, the project ID is 1):
!Screen Shot 2018-04-16 at 14.30.26.png|width=788,height=138!
The resolution consists in removing all the duplicate rows with the highest ID. In the example below, there are 2 duplicate rows for the service desk id 1 with the IDs 52 and 53, so the 2 rows below need to be deleted. If you see duplicate rows for other projects, please delete them as well. Note that the query below only applies to the example provided above. The IDs will likely be different in your instance.
{code:borderStyle=solid}
delete from "AO_54307E_CAPABILITY" where "ID" = '52'
delete from "AO_54307E_CAPABILITY" where "ID" = '53'
{code}
Start up JIRA and verify.
{panel}

i'm having a problem where the "do not send account verification emails" toggle will not stay checked "green"

as it stands, this means i can't actually disable the invite confirmation emails

we're running an eval of Jira software and core 7.7.2, and service desk 3.10.2, currently just on the h2 db

if i pull up google chrome's javascript console and click the toggle, the following is shown:

POST [https://jira.MY.FQDN/rest/servicedesk/notifications/1/customerinvite/34|https://jira.my.fqdn/rest/servicedesk/notifications/1/customerinvite/34] 409 ()
(anonymous)
XMLHttpRequest.send @ batch.js?agile_globa…erational=true:7006
send @ batch.js:200
ajax @ batch.js:194
value @ context-sd.admin.out…6.js?locale=en-US:1
value @ context-sd.admin.out…6.js?locale=en-US:1
update @ context-sd.admin.out…6.js?locale=en-US:1
value @ context-sd.admin.out…6.js?locale=en-US:1
change #js-suppress-customer-invite-email @ context-sd.admin.out…6.js?locale=en-US:1
dispatch @ batch.js:107
h @ batch.js:99

Uncaught TypeError: t.forEach is not a function
at Object.<anonymous> (context-sd.admin.out…6.js?locale=en-US:1)
at j (batch.js:63)
at Object.fireWith (batch.js:64)
at Object.fire [as reject] (batch.js:64)
at Object.<anonymous> (context-sd.admin.out…6.js?locale=en-US:1)
at j (batch.js:63)
at Object.fireWith [as rejectWith] (batch.js:64)
at d (batch.js:189)
at XMLHttpRequest.b (batch.js:201)
has anyone else had this issue or similar?

—

edit: maybe i should note, this is running behind nginx for https

New: {panel:title=Workaround}
Note that multiple projects could be affected by this issue, so you might have to apply the same workaround to multiple projects:

Ensure to make a backup of DB before making any changes to it.
Shutdown JIRA.
Run the following query in the database to determine if there is any duplicate rows corresponding to the warning message:
{code}
select * from "AO_54307E_CAPABILITY" where "CAPABILITY_NAME" like 'CUSTOMER_INVITE_EMAIL_SUPPRESSED%';
{code}
Let's assume that you got duplicate rows for a given pservice desk ID, as shown in the screenshot below (in this case, the project ID is 1):
!Screen Shot 2018-04-16 at 14.30.26.png|width=788,height=138!
The resolution consists in removing all the duplicate rows with the highest ID. In the example below, there are 2 duplicate rows for the service desk id 1 with the IDs 52 and 53, so the 2 rows below need to be deleted. If you see duplicate rows for other projects, please delete them as well. Note that the query below only applies to the example provided above. The IDs will likely be different in your instance.
{code:java}
delete from "AO_54307E_CAPABILITY" where "ID" = '52'
delete from "AO_54307E_CAPABILITY" where "ID" = '53'
{code}
Start up JIRA and verify.
{panel}

i'm having a problem where the "do not send account verification emails" toggle will not stay checked "green"

as it stands, this means i can't actually disable the invite confirmation emails

we're running an eval of Jira software and core 7.7.2, and service desk 3.10.2, currently just on the h2 db

if i pull up google chrome's javascript console and click the toggle, the following is shown:

{code:java}

POST [https://jira.MY.FQDN/rest/servicedesk/notifications/1/customerinvite/34|https://jira.my.fqdn/rest/servicedesk/notifications/1/customerinvite/34] 409 ()
(anonymous)
XMLHttpRequest.send @ batch.js?agile_globa…erational=true:7006
send @ batch.js:200
ajax @ batch.js:194
value @ context-sd.admin.out…6.js?locale=en-US:1
value @ context-sd.admin.out…6.js?locale=en-US:1
update @ context-sd.admin.out…6.js?locale=en-US:1
value @ context-sd.admin.out…6.js?locale=en-US:1
change #js-suppress-customer-invite-email @ context-sd.admin.out…6.js?locale=en-US:1
dispatch @ batch.js:107
h @ batch.js:99

Uncaught TypeError: t.forEach is not a function
at Object.<anonymous> (context-sd.admin.out…6.js?locale=en-US:1)
at j (batch.js:63)
at Object.fireWith (batch.js:64)
at Object.fire [as reject] (batch.js:64)
at Object.<anonymous> (context-sd.admin.out…6.js?locale=en-US:1)
at j (batch.js:63)
at Object.fireWith [as rejectWith] (batch.js:64)
at d (batch.js:189)
at XMLHttpRequest.b (batch.js:201)
has anyone else had this issue or similar?
{code}

—

edit: maybe i should note, this is running behind nginx for https

SET Analytics Bot made changes - 27/Apr/2018 1:02 AM

UIS

Original: 2

New: 3

Lachlan G (Inactive) made changes - 25/Apr/2018 11:52 PM

Affects Version/s		New: 3.11.1 [ 78519 ]
Affects Version/s		New: 3.10.1 [ 77799 ]
Affects Version/s		New: 3.11.2 [ 78520 ]
Affects Version/s		New: 3.10.3 [ 79090 ]
Affects Version/s		New: 3.12.1 [ 79092 ]

Lachlan G (Inactive) made changes - 25/Apr/2018 11:50 PM

Fix Version/s		New: 3.10.4 [ 79893 ]
Fix Version/s		New: 3.12.2 [ 79894 ]
Fix Version/s		New: 3.11.3 [ 79091 ]

Lachlan G (Inactive) made changes - 25/Apr/2018 11:50 PM

Status

Original: In Progress [ 3 ]

New: Awaiting Release [ 11372 ]

Assignee:: Lachlan G (Inactive)

Reporter:: Lachlan G (Inactive)

Affected customers:: 9 This affects my team

Watchers:: 18 Start watching this issue

Created:: 19/Mar/2018 12:40 AM

Updated:: 27/Mar/2019 5:47 AM

Resolved:: 10/May/2018 10:49 PM

Details

Description

Attachments

Attachments

Issue Links

Forms

Activity

People

Dates

Backbone Issue Sync