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

[pnagar]

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.

[hariom_garg]

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

[former_member1275988]

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

[pnagar]

sandhya.yandhava

yes my issue got resolved there was time difference at application level. i adjusted my application server time accordingly my issue got resolved.

[former_member1275988]

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.

[hrollizo]

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

[pnagar]

Dear sumitjais

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.

[sumitjais]

Hi Prashant,

Yet can you share the output of below from master

1> sp_helpexternlogin
2> go

You didn't mention SAP_BASIS level of the system.

[sumitjais]

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.

[Sriram2009]

Hi Prashant.

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

Regards

SS