Project Import Fails With Has No User Associated With The Watch Error

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

When trying to import a project, the import fails with the following error in the UI

Watcher associated with issue id '337461' has no user associated with the watch

Cause

This error occurs because there is watcher or voter with NULL value.

During the project import, JIRA will check for the watcher and voter association in all projects to prevent importing NULL userassociations to the destination instance.

Resolution

Always back up your data before performing any modification to the database. If possible, try your modifications on a test server.


  1. Run the following SQL query to identify all the NULL watcher and/or voter in the instance

    SELECT * FROM userassociation  WHERE source_name = '';
    
  2. Delete every the NULL user returns from the query above.

    DELETE FROM userassociation  WHERE source_name = '';
    

    (warning) Please make sure that you have the latest XML backup before proceeding with the DELETE statement above.

Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.