OBR Full Backup script fails

  • KM03812388
  • 31-May-2021
  • 31-May-2021

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

We received the following error while running the script: ---------------------------------- [root@swesmd0300 PMDB]# /opt/OV/nonOV/perl/a/bin/perl $PMDB_HOME/DR/SHR_full_Backup.pl /opt/HP/backup/full_backup/ /opt/HP/backup/full_backup///SHR_DR_FullBackup//Wed//Full_BOFileStore_BackUP exists /opt/HP/backup/full_backup///SHR_DR_FullBackup//Wed//Full_SQLAnWr_BackUP exists /opt/HP/backup/full_backup///SHR_DR_FullBackup//Wed//Full_CAC_BackUP exists /opt/HP/backup/full_backup///SHR_DR_FullBackup//Wed//Full_Configuration_BackUP exists /opt/HP/backup/full_backup///SHR_DR_FullBackup//Wed//Full_Configuration_BackUP exists /opt/HP/backup/full_backup///SHR_DR_FullBackup//Wed//Full_Configuration_BackUP exists /opt/HP/backup/full_backup///SHR_DR_FullBackup//Wed//Full_Configuration_BackUP exists /opt/HP/backup/full_backup///SHR_DR_FullBackup//Wed//Full_Configuration_BackUP exists /opt/HP/backup/full_backup///SHR_DR_FullBackup//Wed//Full_Configuration_BackUP exists Configured value :BI4_1531505048 This is BO CMS Database Engine Name : BI4_1531505048 Inside Linux Block BI4_1531505048--------SQL Engine name Configured value :SHR_server_install,SAP_BOBJ These are SHR Installed features ----- SHR_server_install,SAP_BOBJ SHR_server_install - IS INSTALLED /opt/HP/BSM/PMDB//scripts//MgmtDB//Postgres//Mgmt_backup_AGGREGATE_CONTROL.sqlThis is postgresql file name/opt/HP/BSM/PMDB//scripts//MgmtDB//Postgres//Mgmt_backup_AGGREGATE_CONTROL.sqlPID:21623 java.lang.Exception: Exception occurred while set value at com.hp.bto.bsmr.util.DerivedClass.getValue(DerivedClass.java:86) at com.hp.bto.bsmr.util.EncryptionUtility.decryptString(EncryptionUtility.java:69) at com.hp.bto.bsmr.dao.DBConnectionParam.loadMgmtDBConParam(DBConnectionParam.java:371) at com.hp.bto.bsmr.managementdb.dao.PostgresDao.(PostgresDao.java:62) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at java.lang.Class.newInstance(Class.java:442) at com.hp.bto.bsmr.managementdb.ManagementDBFactory.createDAO(ManagementDBFactory.java:82) at com.hp.bto.bsmr.managementdb.ManagementDBFactory.createBSMRDAO(ManagementDBFactory.java:62) at com.hp.bto.bsmr.managementdb.ManagementDBFactory.getManagementDBDao(ManagementDBFactory.java:42) at com.hp.bto.bsmr.managementdb.ManagementDBFactory.getManagementDBDao(ManagementDBFactory.java:30) at com.hp.bto.pmdb.mgmtqlexecutor.InitExecutor.checkMgmtDBConnection(InitExecutor.java:67) at com.hp.bto.pmdb.mgmtqlexecutor.InitExecutor.initialize(InitExecutor.java:36) at com.hp.bto.pmdb.mgmtqlexecutor.MgmtSQLExecutor.execute(MgmtSQLExecutor.java:28) at com.hp.bto.pmdb.mgmtqlexecutor.MgmtSQLExecutor.main(MgmtSQLExecutor.java:18) SAP_BOBJ - IS INSTALLED /opt/HP/BSM/PMDB//DR//ESQLAWCMSDB_lin.txt ########################################################SQL Anywhere Backup Utility Version 17.0.9.4935 Usage: dbbackup [options] target-directory @ expands from environment variable or file Options (use specified case, as shown): -aw enable auto tuning of writers (use -aw- to turn off auto tuning) -b blocksize number of pages in data blocks. Default is 128 -bc "comment" specify backup comment -c "keyword=value;..." supply database connection parameters -d backup main database file -h enable backup history (use -h- to disable backup history) -k

Fix

We found that there are issues in encrypted files and we re-encrypted them using the below commands:

 

- Executed below commands to create a temporary txt files:

 

echo "ENG=<Servername>;DBN=BI4_CMS;UID=dba;PWD=1ShrAdmin" >> $PMDB_HOME/DR/cms.txt

echo "ENG=<Servername>;DBN=BI4_Audit;UID=dba;PWD=1ShrAdmin" >> $PMDB_HOME/DR/Audit.txt

 

- Executed below commands to create new OBR DR encrypted files using above created temporary txt:

 

source $PMDB_HOME/../BOE4/sap_bobj/setup/env.sh;dbfhide $PMDB_HOME/DR/cms.txt $PMDB_HOME/DR/SQLA_Lin_DR_BI4CMS_Enc.enc

 

source $PMDB_HOME/../BOE4/sap_bobj/setup/env.sh;dbfhide $PMDB_HOME/DR/Audit.txt $PMDB_HOME/DR/SQLA_Lin_DR_BI4Audit_Enc.enc