Skip to Content

SAP ASE Backup status NOT available in dba cockpit nor changing colour as per legend symbol

Dear Experts,

I have scheduled the backup for ase database using dbacokpit but when i check the same in DBA Planning calendar as below i could see the entries.

and when i double click on the same to see its action description then it shows me below status.

then i could see its status is NOT available.However to assure the same i went to os level and checked if dmp file is created their or not and i found the file there So backup is running .My concern here is why the dbacokpit for ase is not changing its color(according to the legend as pasted below) and status according to the right action and result. please suggest as its a pain to check the file at os level every time.

capture.png (3.0 kB)
capture.png (19.1 kB)
capture.png (14.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Posted on Jul 04, 2020 at 01:33 PM

    Hi Prashant.

    Refer the SAP note https://launchpad.support.sap.com/#/notes/1841993

    Regards

    SS

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 05, 2020 at 03:24 AM

    Hi Prashant,

    Please add sapsa to SYB_JSTAS following the resolution in

    2673114 - SYB: Scheduled job shows status as 'Not available' on DBACockpit - SAP ASE

    and check if the forthcoming backups show "Planned"

    Additional Suggestion : What's SAP_BASIS level of the system? You must keep DBACOCKPIT updated with DBA Cockpit Correction Collection notes for relevant SAP_BASIS.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 05, 2020 at 06:05 AM

    Dear Sumit Jaiswal

    For scheduled backup or action s in dbacockpit its showing fine but in case of running backup it show me status as not available and it updates the status ones the backup got finished succesfully or when it got failed.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 06, 2020 at 01:24 PM

    Hi,

    check if the backup services are up and running at OS level:

    • 1> sp_helpserver SYB_BACKUP
    • 2> go
    • ## Verify backup services:
    • ps -ef | grep dataserver
    • ps -ef | grep backupserver

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 25, 2020 at 10:43 AM

    Hi Prashant,

    Did your issue got resolved?

    I too getting the same issue , i have scheduled one database dump action in DBACOCKPIT, but when i check in DBA planning calender i found 2 entries , where first action is with status "scheduling failed" and the second action is with status "finished successfully". there is an duplicate entries , the time difference between two actions is around 30 sec .

    i checked system time, application time and dbacockpit time , all are same.

    Can anyone please suggest , what might be the reason..

    Regards

    sy

    Add a comment
    10|10000 characters needed characters exceeded

    • Thanks for your reply prashant,

      But in my case , database time , application time and system time was same.

      For dump transaction there was no duplicate entries , only for dump database getting duplicate entries

      First database dump action is failed

      Second action is finished successfully , but i did'nt scheduled this action, automatically it is executing.

      Please help me , how to resolve this issue.

  • Posted on Aug 04, 2020 at 10:47 AM

    Hi,

    First check if Backup server process is up or not using below command:-

    ps -ef | grep backupserver

    if its up and running then check

    SID_BS.log on belo location

    /sybase/SID/ASE-16_0/install

    after that please check if all DBs are having enough free space.

    above 3 points will definitely solve your issue.

    if not resolved then share the logs of SID_BS.log

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.