While trying to upgrade Control Compliance Suite Vulnerability Manager Postgress the upgrade fails with the following message: Postgress upgrade fails:Postgress SQL database upgrade fails
PostgresMigration: Postgres migration to PostgreSQL 9.0.3 failed: Results of the tables of source and destination databases do not match., Start CCS Vulnerability Manager and try again to complete the migration.
1. Go to https://CCSVMServerName:3780/admin/diag_query.html
2. Execute the following query: SELECT * FROM web_pages where path LIKE E'%\x1A%';
3. Execute the following query: UPDATE web_pages SET path = 'sanitized' where path LIKE E'%\x1A%';
4. Delete the nxpgsql-temp directory from the /nsc folder, and run the migration again.
Imported Document ID: TECH165829
Subscribing will provide email updates when this Article is updated. Login is required.