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