KB485488: Platform Analytics Consumer failed to start after upgrade to MicroStrategy 2021 Update 5.1 in Linux

Symptom

After upgrade to Strategy 2021 Update 5.1, platform analytics consumer failed to start. Below error could be found in platform-analytics-consumer.err. 

2022-05-04` 06:20:41,056 ERROR PlatformAnalyticsConsumer:210 - Fatal Exception:com.Strategy.pa.common.exception.PALoadCacheException: Error while loading data from LuMetadata to Redis.        at com.Strategy.pa.persistence.dao.impl.LuMetadataDaoImpl.loadData(LuMetadataDaoImpl.java:106) ~[platform-analytics-consumer.jar:?]        at com.Strategy.pa.kafka.consumer.main.PlatformAnalyticsConsumer.loadData(PlatformAnalyticsConsumer.java:372) ~[platform-analytics-consumer.jar:…        at com.Strategy.pa.persistence.dao.impl.LuMetadataDaoImpl.loadData(LuMetadataDaoImpl.java:100) ~[platform-analytics-consumer.jar:?]        ... 4 moreCaused by: org.postgresql.util.PSQLException: ERROR: column lumetadata0_.hashed_metadata_connection_string does not exist

Cause

When the Platform Analytics Consumer is upgraded without also upgrading the Platform Analytics Repository, the components are out of sync.  The columns:

hashed_metadata_connection_string

raw_metadata_connection_string

Action

Upgrade Platform Analytics repository from configuration wizard by following steps below: 
https://www2.microstrategy.com/producthelp/Current/UpgradeGuide/en-us/Content/upgrade_win_in_place_pa_repo.htm
 

Workaround

1. Manually add missing columns in lu_metadata table:
   ALTER TABLE lu_metadata ADD COLUMN hashed_metadata_connection_string VARCHAR;
   ALTER TABLE lu_metadata ADD COLUMN  raw_metadata_connection_string VARCHAR;

Refer to pgsql official document for more details: 
https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-add-column/ 
 

1. Restart Platform analytics consumer, and the lu_metadata table will be populated correctly as shown below: