Search the VMware Knowledge Base (KB)
View by Article ID

Migration from vRealize Automation 6.x to 7.x can fail with the error (2150006)

  • 0 Ratings

Symptoms

  • When migrating between vRealize Automation 6.x to 7.x, the migration fails.
  • In the migration.log file, you see an error similar to:

    + Exporting vRA databasepg_dump: [archiver (db)] query failed: ERROR:  permission denied for relation res_id
    pg_dump: [archiver (db)] query was: LOCK TABLE "public"."res_id" IN ACCESS SHARE MODE
    ..failed

Cause

This error occurs when the Postgres database contains a table which is not owned by the default vcac owner.  The table could potentially be owned by the postgres user.

Resolution

To resolve this issue:
  1. SSH into vRealize the Automation appliance.
  2. Change users by running the command:

    su postgres

  3. Log into postgres by running the command: 

    /opt/vmware/vcac/vpostgres/current/bin/psql vcac

  4. List all relations in the database by running the command:

    \d+

  5. The output should list the tables and owners (should all be vcac).
  6. If any table has a different owner, you can update it by running the command:

    ALTER TABLE "public"."<table name>" OWNER to vcac;

    For Example:  ALTER TABLE "public"."cms_content" OWNER to vcac;

  7. Re-run the migration.

Additional Information

To be alerted when this article is updated, click Subscribe to Document in the Actions box.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 0 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 0 Ratings
Actions
KB: