...
JEMH extends this Jira feature as part of ‘Transferring ownership’, where users specified in JEMH Profiles, including Privileged Users, Forward Users and Default Reporters. audit records etc are changed to the new given user or anonymized.
Problem
Anonymization task fails with error along the lines of:
...
This error will show in the logs or on the UI, like below:
...
Solution
Fixing this issue requires access to the database and a simple queryrunning a query to change the entity type to a valid one. As there are many entities used in JEMH as part of anonymization, we have put together a query which includes all of them. Using Microsoft SQL Server Management Studio (SMSS) you can create a new query on your database and execute the following 3 queries:query:
Change ‘jiraschema’ to the name of your schema.
| Code Block |
|---|
ALTER TABLE [jiraschema].[AO_78C957_CONFIG]
ALTER COLUMN REPORTER_USER_NAME NVARCHAR( |
...
255) ALTER TABLE [jiraschema].[AO_78C957_CONFIG] ALTER COLUMN FORWARD_USER NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_CONFIG] ALTER COLUMN PRIVILEGED_USER NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_CONFIG] ALTER COLUMN CUSTOM_EMAIL_FROM_ADDRESS NVARCHAR( |
...
255) ALTER TABLE [jiraschema].[AO_78C957_CONFIG] ALTER COLUMN CUSTOM_EMAIL_REPLY_TO_ADDRESS NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_AUDITEVENTS] ALTER COLUMN EMAIL_SOURCE_USER_KEY NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_AUDITEVENTS] ALTER COLUMN FROM_ADDRESS NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_NOTIF_SOURCE] ALTER COLUMN EVENT_USER_KEY NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_LSNR_PROJ] ALTER COLUMN JIRA_FROM_ADDRESS NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_LSNR_PROJ] ALTER COLUMN JIRA_REPLY_TO_ADDRESS NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_LSNR_PROJ] ALTER COLUMN NON_JIRA_REPLY_TO_ADDRESS NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_LSNR_PROJ] ALTER COLUMN NON_JIRA_FROM_ADDRESS NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_LSNR_CONF] ALTER COLUMN PRIVILEGED_USER |
...
NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_NAGCONFIG] ALTER COLUMN NAGIOS_REPORTER NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_REGEXPPROCCNF] ALTER COLUMN REPORTER NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_PROJCONFIG] ALTER COLUMN REPORTER NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_PROJCONFIG] ALTER COLUMN ASSIGNEE NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_PRJSCRIPTMAP] ALTER COLUMN REPORTER NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_PRJSCRIPTMAP] ALTER COLUMN ASSIGNEE NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_PRJDOMMAP] ALTER COLUMN REPORTER NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_PRJDOMMAP] ALTER COLUMN ASSIGNEE NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_PRJGRPMAP] ALTER COLUMN REPORTER NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_PRJGRPMAP] ALTER COLUMN ASSIGNEE NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_PRJKYWRDMAP] ALTER COLUMN REPORTER NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_PRJKYWRDMAP] ALTER COLUMN ASSIGNEE NVARCHAR(255) ALTER TABLE [jiraschema].[AO_78C957_WFRULE] ALTER COLUMN RUN_AS NVARCHAR(255) |
Now stop Jira, restart the database and start Jira again.