Skip to main content
commvault.com commvault.com
Solved

Backup of SAP HANA failing

R
Byte
Forum|alt.badge.img+8

Hi Commvault,

 

We have configured backups for SAP HANA and when we re trying the backups we are getting below error.

Error Code: [18:146] Description: SAP HANA Error [hdbsql execution Failed. /usr/sap/EHK/HDB00/exe/hdbsql -t -U BACKUPSYS -d SYSTEMDB -C "backup data for ERK using backint ('1857225_COMPLETE_DATA_BACKUP') TOOLOPTION 'BACKUP -j 1857225 -a 2:3053 -t 1 -jt 1857225:4:1:0:0:30326 -data -at 135 -d bppwcvt02.ad.fujitsu.mazdaeur.com*bppwcvt02*8400 -vm Instance001 -cn bdvlecdb01'"* 447: backup could not be completed: [110122] A data backup cannot be created because another data backup is running or a storage snapshot has been prepared. SQLSTATE: HY000]. Source: bdvlecdb01, Process: ClHanaAgent  

 

Request you to please review the logs. I have attached them.

 

Thanks in Advance.

 

Rahul Raina

Best answer by Gowri Shankar

@Rahul18081 

one of the recommendations on the SAP note to troubleshoot this issue is restart the database 

SAP HANA note → https://launchpad.support.sap.com/#/notes/0002452735

 

SAP Admin could review the SAP KB using the above link for assistance and engage SAP support if you still need assistance

View original
    Did this answer your question?

    10 replies

    G
    Vaulter
    Forum|alt.badge.img+13

    Hi @Rahul18081 

     

    The error could happen if there is another job running either from commvault or  native backup method.

     

    Apart from this please engage your SAP admin to check if there are any hung backint process on the SAP HANA level

     

    Regards,

    Gowri Shankar

    R
    Byte
    Forum|alt.badge.img+8
    • Rahul18081
    • Author
    • Byte
    • 38 replies
    • February 16, 2023

    Hi Shankar,

    Thnaks for you quick reply.

    Did you also re-view the logs that i have uploaded.

     

    G
    Vaulter
    Forum|alt.badge.img+13

    Hi @Rahul18081 

     

    This is one of the common errors we see with SAP HANA backups 

    SAP HANA admin could review the below SAP Note 

    SAP HANA note → https://launchpad.support.sap.com/#/notes/0002452735

     

    One of the queries that could help the admin to check any hung processes 

     

    select * from "SYS"."M_BACKUP_CATALOG" where STATE_NAME = 'running'

     

    Regards,

    R
    Byte
    Forum|alt.badge.img+8
    • Rahul18081
    • Author
    • Byte
    • 38 replies
    • February 22, 2023

    @Gowri Shankar  please find the below output from SAP Hana admin team.

    What does the below output means and what should we do next.

     

    Onno van den Berg
    Commvault Certified Expert
    Forum|alt.badge.img+19
    • Onno van den BergCommvault Certified Expert
    • Commvault Certified Expert
    • 1232 replies
    • February 22, 2023
    Rahul18081 wrote:

    @Gowri Shankar  please find the below output from SAP Hana admin team.

    What does the below output means and what should we do next.

     

    Can you please upload the picture once more, but this time in high resolution. I can't read the line of text being displayed. Maybe also add the output in text. 

    G
    Vaulter
    Forum|alt.badge.img+13

    Hi @Rahul18081  and @Onno van den Berg 

     

    SAP HANA reports that there is a backup in progress.

    It is expected that SAP HANA will not allow another job when a job is currently in progress

     

    If there is no native job running at the moment then it could be a hung process, please engage a SAP HANA admin or SAP support to clear the hung process. Ensure there are no native backups running and rerun the job from Commvault.

     

    Regards,

    Gowri Shankar

    R
    Byte
    Forum|alt.badge.img+8
    • Rahul18081
    • Author
    • Byte
    • 38 replies
    • February 22, 2023

     

    @Onno van den Berg @Gowri Shankar 

    Please find the new screenshot.

     

     

    G
    Vaulter
    Forum|alt.badge.img+13

    Please check my previous response 

     

    Looks like the job was started on Feb 16th which still shows on the hana level

     

    Either the job is still running or its a hung process,

     

     

    ------------

    SAP HANA reports that there is a backup in progress.

    It is expected that SAP HANA will not allow another job when a job is currently in progress

     

    If there is no native job running at the moment then it could be a hung process, please engage a SAP HANA admin or SAP support to clear the hung process. Ensure there are no native backups running and rerun the job from Commvault.

    -----

     

    R
    Byte
    Forum|alt.badge.img+8
    • Rahul18081
    • Author
    • Byte
    • 38 replies
    • February 22, 2023

    @Gowri Shankar 

     

    Shankar if SAP Hana admin can’t clear the hung process then rebooting the server will clear the hung process.

    G
    Vaulter
    Forum|alt.badge.img+13
    • Gowri ShankarVaulter
    • Vaulter
    • 218 replies
    • Answer
    • February 22, 2023

    @Rahul18081 

    one of the recommendations on the SAP note to troubleshoot this issue is restart the database 

    SAP HANA note → https://launchpad.support.sap.com/#/notes/0002452735

     

    SAP Admin could review the SAP KB using the above link for assistance and engage SAP support if you still need assistance

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings