Error on Home page: New configuration files for the Apache web server were not created

Symptoms

There is an error message on the Home page or in Domains > example.com page:

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.

There are one or more entries in Configurations table with error status:

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne"select * from Configurations where status='error'\G"

Cause

Entries for several domains are absent in psa database.

Resolution

Get the affected domain name:

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')"

Reconfigure domain name in question:

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

If some configurations still need to be fixed, run the following:

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne"delete from Configurations where status='error' \G"