Unable to create a dump during migration due corruption of siteapppackages table

Created:

2016-11-16 13:01:43 UTC

Modified:

2017-04-24 11:59:57 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to create a dump during migration due corruption of siteapppackages table

Applicable to:

  • Plesk 11.0 for Windows
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows
  • Plesk 9.x and below for Windows

Symptoms

Unable to perform transfer or backup with following errors:

Error: domain "domain.com"

Can not dump package for Site Application with id='2'
Error:

Can not find package in the database
Error:

The XML document is invalid for XPath exception.
Can not evaluate result of expression 'sapp-spec at path '/migration-dump/admin/domains/domain/phosting/applications/sapp-installed''

Or

Cannot dump site app with id '2' and prefix 'joomla'. However, all the app-related content should be transferred correctly.[Can not find package in the database]

Cause

Relationships between tables ' apsapplicationitems ' and ' siteapppackages ' are broken because there are some missing records in ' siteapppackages ' table in psa database.

Please execute the below query in order to detect records with broken relationships:

"%plesk_bin%\\dbclient.exe" --direct-sql --sql="select * from apsapplicationitems where apsapplicationitems.pkg_id not in (select id from siteapppackages)"

Resolution

Restore needed records of ' siteapppackages ' table from backup of psa database or restore records in ' siteapppackages ' table manually.

Workaround

Delete records which caused issue from "apsapplicationitems" table:

"%plesk_bin%\\dbclient.exe" --direct-sql --sql="DELETE from apsapplicationitems where apsapplicationitems.pkg_id not in (select id from siteapppackages)"
Have more questions? Submit a request
Please sign in to leave a comment.