MENU

Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Friday, December 18, 2015

Backup failed with Invalid value for key (bkpmon)


Here , I Explained about backup failed with Invalid value for KEY (bkpmon) and the error message is backup failed with return code [1] and stderr [* -10104: Invalid value for KEY (bkpmon)

ERROR Code -
[lddbabc:9090 (4.1.1.1)] Command [su - abcadm -c "/usr/sap/ABC/home/backup.pl"] failed with return code [1] and stderr [* -10104: Invalid value for KEY (bkpmon)

workaround for the error -

Step 1: Connect to DB using Backup User.

vsa0002:HDB:abcadm ~ 860> hdbsql -jU bkpmon

Welcome to the SAP HANA Database interactive terminal.

Type:  \h for help with commands
       \q to quit

hdbsql=>
* -10104: Invalid value for KEY (bkpmon)
hdbsql=>
* -10104: Invalid value for KEY (bkpmon)

---if we are getting  same error then follow below step----- 

Step 2:  Check  Hana DB Version & Backup Script Version.

vsa0002:HDB:abcadm ~ 862> HDB version
HDB version info:
  version:                 1.00.102.03.1449674847
  branch:                 fa/newdb100_maint_rel
  git hash:                d20cd4981dab98ab6c30307d71d1b111e8725670
  git merge time:      2015-12-09 16:27:27
  weekstone:           0000.00.0
  compile date:        2015-12-09 16:39:52
  compile host:        ld700
  compile type:        rel


vsa0002:HDB:abcadm ~ 863> ./backup.pl   -v
version: 6

1> Remove or Rename old Backup.pl Script .
2> Download Backup Script (backup.pl)  from SAP Support & Check backup Script Version.
vsa0002:HDB:abcadm ~ 871> ./backup.pl -v

Step 3: Install the Backup.pl Script.

vsa0002:HDB:abcadm  ~ 873> ./backup.pl  -i
Installing backup.pl here.

Step 4: login into DB from Command Prompt Using Backup User.

vsa0002:HDB:abcadm ~ 874> hdbsql -jU bkpmon

Welcome to the SAP HANA Database interactive terminal.

Type:  \h for help with commands
       \q to quit

hdbsql=>
hdbsql ABC=>

Congratulation : Issue has been Resolved & wait for next backup run or we can test manually!!!

No comments: