KB-001-priv-key-of-relation-patches_credential-does-not-exist

This migration error may impact versions 2.7 and below.

• After upgrading from a version below 2.8, the following error message may be displayed after attempting to perform some action: { "error": "column "priv_key" of relation "patches_credential" does not exist\nLINE 1: ...escription", "username", "auth_type", "password", "priv_key"...\n ^\n" }

1. To solve the problem, log into the LCC server with the root user, start the postgresql shell with "psql" and run the following queries:

   #1 ALTER TABLE patches_credential ADD COLUMN auth_type INTEGER NOT NULL DEFAULT 0;

   #2 ALTER TABLE patches_credential ADD COLUMN priv_key TEXT NULL;