These are the steps taken to resolve the error.\n\n1. Check errlog.log, vectorwise.log \n2. Check ownership of all pfmdb directory and change ownership to ingres for directories with root\n3. Checked /II_DATABASE/ingres/data/vectorwise/pfmdb/wal/location_map and found out that it contains only default,data,/II_DATABASE/ingres/data/vectorwise/pfmdb/CBM/default\n4. Restore / recreate location_map from backup to contain all the necessary locations.\n5. Checked existing db_key from /II_DATABASE/ingres/data/vectorwise/pfmdb/CBM and compared to all db locations\n6. Copied master db_key to all db locations\n7. Tried running checkpoint again but with same error.\n8. Copied master db_key to work locations\n9. Successfully ran checkpoint.