KB484972: "Metadata is required to be backed up" error occurs when running the MSTRBak tool

Description

When using the MSTRBak tool to back up your environment, the following error occurs when backing up the metadata:
Metadata is required to be backed up

Solution

• Check if the database has write permission to the directory where you want to save the bak file, e.g.,

  /opt/mstr/mstrbak

  . 
  

• Ping the database host in the machine where you are running MSTRBak to check the connectivity to the database host.
• Check if the database user has privilege to access all the tables in the database. If not, change the database user to one who has higher privilege. 
• Check if the bin path is set correctly:
  
• PostgreSQL bin path format is

  <MSTR install path>/install/Repository/bin.

• MySQL bin path format is

  /usr/bin

  .
  For MySQL driver, only

  mysql-connector-java-8.0.x.jar

  is supported. You are recommended to use

  mysql-connector-java-8.0.12.jar

  or

  mysql-connector-java-8.0.18.jar.

  
  
• If the metadata database type is NOT mySQL or PostgreSQL, there is no credential check after inputting your credentials, so double-check your database credential. 
• Run MSTRBak in dump mode, e.g.,

  ./mstrbak -d

  
  
• For MySQL, run the following dump command under the bin path:
  

  
  ./mysqldump -h [hostname] -u [username] -pPASSWORD --single-transaction --databases [database name] > xxxx.sql
  

  
  
• For PostgreSQL, run the following dump command under the bin path:
  

  
  ./mstr_pg_dump -d [database name] -h [hostname] -p 5432 -U [username] -f xxxx.sql
  

  
  If successful, then please contact the Strategy Support team.
  If it fails, contact the Database team. After this issue is fixed, run the MSTRBak tool again and check if Platform Analytics can be successfully backed up.
  
• If the above methods do not solve the problem, contact the Strategy Support team with the following logs:
  

• ~/Mstrbak-client/logs/MSTRBAK - BACKUP.log

• ~/Mstrbak-client/DBMigratorLogger.log

• /log/MACmdMgrW.xml