cancel
Showing results for 
Search instead for 
Did you mean: 

SLD Service Schedule Export Hana Schema error

fung
Explorer

Hi All,

SLD Service Schedule Export Hana Schem

/*********Success**********/

run_backup.sh(18282) 191224-015501: Instance:XXXXXX:30015 Schema:"XXXXXX" Found stale pid file /var/log/SAPBusinessOne/BackupService/logs/XXXXXX_30015/XXXXXX.pid with pid(16017)

run_backup.sh(18282) 191224-015501: Instance:XXXXXX:30015 Schema:"XXXXXX" Pid file /var/log/SAPBusinessOne/BackupService/logs/XXXXXX_30015/XXXXXX.pid
run_backup.sh(18282) 191224-015501: Instance:XXXXXX:30015 Schema:"XXXXXX" Begin: Timestamp:191224_015501 User:SYSTEM Password:**** BackupPath:/hana/shared/backup_service/backups/XXXXXX_30015 LogFile:/var/log/SAPBusinessOne/BackupService/logs/XXXXXX_30015/XXXXXX.log WorkingPath:/tmp/backup_service
run_backup.sh(18282) 191224-015501: Instance:XXXXXX:30015 Schema:"XXXXXX" GUID:
run_backup.sh(18282) 191224-015501: Instance:XXXXXX:30015 Schema:"XXXXXX" /usr/sap/SAPBusinessOne/ServerTools/Backup/bin//BackupUtility backup -compress -dbserver XXXXXX:30015 -database XXXXXX -location /hana/shared/backup_service/backups/XXXXXX_30015 -dbuser SYSTEM -dbpassword **** -t /tmp/backup_service
INFO SAP BACKUP UTILITY
INFO Creating export of schema XXXXXX on server XXXXXX:30015 in folder /hana/shared/backup_service/backups/XXXXXX_30015/OFL/XXXXXX/bck_20191224015503/bck_20191224015503.zip.
INFO Export finished without error.
run_backup.sh(18282) 191224-015742: Instance:XXXXXX:30015 Schema:"XXXXXX" Finish: Timestamp:191224_015501 BackupExitCode:0

/*********Success**********

/*********Fail**********/

run_backup.sh(16152) 200121-101330: Instance:XXXXXX:30015 Schema:"XXXXXX" Found pid file /var/log/SAPBusinessOne/BackupService/logs/XXXXXX_30015/XXXXXX.pid with running pid(18282)

run_backup.sh(16152) 200121-101330: Instance:XXXXXX:30015 Schema:"XXXXXX" ERROR: Other operation on the same schema in progress XXXXXX:30015 XXXXXX

/*********Fail**********/


Accepted Solutions (0)

Answers (1)

Answers (1)

former_member610331
Contributor
0 Kudos

Hi fung,

Referring to your log messages:

run_backup.sh(18282) 191224-015742: Instance:XXXXXX:30015 Schema:"XXXXXX" Finish: Timestamp:191224_015501 BackupExitCode:0
/*********Success**********
/*********Fail**********/
run_backup.sh(16152) 200121-101330: Instance:XXXXXX:30015 Schema:"XXXXXX" Found pid file /var/log/SAPBusinessOne/BackupService/logs/XXXXXX_30015/XXXXXX.pid with running pid(18282)
run_backup.sh(16152) 200121-101330: Instance:XXXXXX:30015 Schema:"XXXXXX" ERROR: Other operation on the same schema in progress XXXXXX:30015 XXXXXX
/*********Fail**********/

It seems your backup script has locked DB schema and it has not released lock yet (pls refer pid #18282).

Could you perform a clean shutdown of your server and try run_backup.sh again? Please let us know if your issue is resolved or if there is any other error.

Best wishes & Good Luck,
Sam

fung
Explorer
0 Kudos

delete file

/var/log/SAPBusinessOne/BackupService/logs/XXXXXX_30015/XXXXXX.pid and then backup success

former_member610331
Contributor

Hi fung,

It is not recommended to manually delete a file as it could impact any other processes/files already opened. Hence, a clean shutdown of OS was recommended. Nonetheless, I am glad to hear your issue is resolved.

Best wishes,

Sam