Plesk shows error on Home page: New configuration files for the Apache web server were not created

Symptoms

1. The following error is shown on the Home page or in Domains > example.com page:

   PLESK_ERROR: New configuration files for the Apache web server were not created due to the errors in configuration templates: Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainForwarding.php, error = Template_Exception: No data. file: /usr/local/psa/admin/plib/Template/Processor.php line: 27 code: 0 Previous error: Template_Variable_Exception: No data. file: /usr/local/psa/admin/plib/Template/Variable/AbstractCachedData.php line: 65 code: 0. The error message containing the detailed error descriptions was sent to you by e-mail. Please resolve the issues and click here to generate broken configuration files once again or here to generate all configuration files.

2. There are one or more entries in the Configurations table with the error value:
   

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne "SELECT * FROM Configurations WHERE status='error'\G"

Cause

Database inconsistency.

Resolution

1. Connect to the server using SSH.

2. Get the list with affected domains:
   

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne"SELECT name FROM domains WHERE id IN (SELECT objectId FROM Configurations WHERE status='error')"

3. Recreate Apache configuration files for affected domains:
   

   # /usr/local/psa/admin/sbin/httpdmng --reconfigure-domain example.com

4. If steps above did not help, try to restore the default permissions for the virtual host directories:
   

   # /usr/local/psa/bin/repair --update-vhosts-structure

5. If it is required to repair all the affected domains, run the following:
   

   # mysql -sN -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "SELECT name FROM domains WHERE id IN (SELECT objectId FROM Configurations WHERE status='error')" > domains.txt
   # file="domains.txt"
   # for var in $(cat $file) > do > /usr/local/psa/admin/bin/httpdmng --reconfigure-domain `echo " $var"` > echo " $var" > done