Mail import sessions are not shown in the Mail Importing menu: Failed to write final import status to a file

Note: In this case, previous import sessions will be lost for the domain.

1. Connect to the Plesk server via SSH.

2. Find the ID of the domain to which mail content is being migrated:

   # plesk db "select id from domains where name='example.com'"
   +----+
   | id |
   +----+
   | 89 |
   +----+

3. Remove everything from the session folder of the domain. Use ID found on step 2:

   1. On Linux:

      # rm -rf /usr/local/psa/var/modules/site-import/sessions/mail-migration-89

   2. on Windows Server

      CONFIG_TEXT: %plesk_dir%var\modules\site-import\sessions\mail-migration-89

4. In Plesk, go to Domains > example.com > Mail Importing.

5. Cancel previous import sessions that have their status stuck at "In progress" (if there are any).

1. Connect to the Plesk server via SSH.

2. Find the ID of the domain to which mail content is being migrated:

   # plesk db "select id from domains where name='example.com'"
   +----+
   | id |
   +----+
   | 89 |
   +----+

3. Go to the migration session directory of this domain. Use ID found on step 2:

   # cd /usr/local/psa/var/modules/site-import/sessions/mail-migration-89

4. Run the following script to find corrupted JSON files inside the direcotry:

   # ls *.json | while read i; do echo $i; python -mjson.tool $i > /dev/null ; done

   On some systems, the utility python2 is used instead of python. In this case, run:

   # ls *.json | while read i; do echo $i; python2 -mjson.tool $i > /dev/null ; done

5. Look through the output to find the corrupted JSON file:

   CONFIG_TEXT: mail_migration_status.json
   Extra data: line 52 column 2 - line 52 column 3 (char 1748 - 1749)

6. Use any JSON syntax parser tool (for example, JSONLint JSON Validator) to fix the corrupted JSON file.

7. In Plesk, go to Domains > example.com > Mail Importing.

8. Cancel previous import sessions that have their status stuck at "In progress".

1. Connect to the Plesk server via RDP.

2. Start PowerShell prompt.

3. Find the ID of the domain to which mail content is being migrated:

   PS plesk db "select id from domains where name='example.com'";
   +----+
   | id |
   +----+
   | 89 |
   +----+

4. Go to the migration session directory of this domain. Use ID found on step 2:

   PS cd "C:\Program Files (x86)\Plesk\var\modules\site-import\sessions\mail-migration-89"

5. Run the following script to find corrupted JSON files inside the direcotry:

   PS Get-ChildItem *.json | Foreach-Object { $file = $_.FullName; echo "Checking JSON file: $file"; %{&"C:\Program Files (x86)\Plesk\python3\python.exe" -m json.tool $file 1> $null}; echo ""}

6. Look through the output to find the corrupted JSON file:

   CONFIG_TEXT: Checking JSON file: C:\Plesk\Data\var\modules\site-import\sessions\mail-migration-1\mail_migration_list_2020-01-08-10-27-40.json
   Extra data: line 16 column 2 - line 16 column 3 (char 386 - 387)

7. Use any JSON syntax parser tool (for example, JSONLint JSON Validator) to fix the corrupted JSON file.

8. In Plesk, go to Domains > example.com > Mail Importing.

9. Cancel previous import sessions that have their status stuck at "In progress".