cancel
Showing results for 
Search instead for 
Did you mean: 

Sap system is going down every week.

former_member362299
Participant
0 Kudos

Hi experts,

one sap system going down automatically on Sunday night every week, it has MAX DB database running on windows. please help me how to avoid this.

Regards

Manjappa

Accepted Solutions (0)

Answers (6)

Answers (6)

srinivasan_vinayagam
Active Contributor
0 Kudos

Hi Manjappa,

You need to analysis some important points.

1. Get system down time and date for every week file from /usr/sap/SID/DVEBMGS<nr>/work/available.log -> identify the same time or different time for SAP system un-available time.


2. Check Windows Task Scheduler log for all users(Administrator, SIDADM) -> Windows Task Scheduler, Under Advanced there is option for "View Log".

3. If get SAP system down time from available.log - Check logs in Event Viewer the same SAP system unavailable time

4. Go to Run and gpedit.msc check Software Settings and Windows Settings

5. Check C:\windows\Tasks\SCHEDLGU.TXT

6. Disable Task Scheduler Services in services.msc if not find root cause.

7. Check the service SAPSID_<nr> in Services.msc and  :\usr\sap\SID\DVEBMGS<nr>\work\sapstartsrv.log

Regards,

V Srinivasan

0 Kudos

check event logs, it seems some auto events might be putting sap processes down. Also check SAP work logs for that time and check if there is any short dump/sys logs etc..please paste the event error or logs error if any during that time.

ashish_vikas
Active Contributor
0 Kudos

is this problem with SAP only OR your Windows also get Restarted ?

http://social.technet.microsoft.com/wiki/contents/articles/22040.find-windows-and-sql-server-last-re...

Regrads,

Ashish

Reagan
Advisor
Advisor
0 Kudos

If the SAP and DB are stopped at a specific time then first look at the system scheduled tasks.

willi_eimler
Contributor
0 Kudos

Please goto transaction BD13 and change the OFFLINE backup to ONLINE-backup.

divyanshu_srivastava3
Active Contributor
0 Kudos

former_member362299
Participant
0 Kudos

hi willi

we are not scheduling any backup in this system.

divyanshu_srivastava3
Active Contributor
0 Kudos

You should thanks Windows

Please goto Event Viewer and look for that time when the system of restarted.

Also, look at system logs for the reason for a restart.

These should be your starting point.

Regards,

former_member362299
Participant
0 Kudos

small correction, only sap and db going down. system is fine.

divyanshu_srivastava3
Active Contributor
0 Kudos

So what, the event logs can help you if that is because of some external, non-sap issue.

And that is why I asked you to check both place.

Now, you should look at, identify the section which need to be check.

If that is from SAP or DB side, then share the logs.

For eg, dev_w0 before the restart.

Regards,

Matt_Fraser
Active Contributor
0 Kudos

Ah. I was going to suggest you check whether this is when the custodians clean the data center. It happened at small remote site I supported many years ago that their server went down every weekend at about the same time, and they couldn't figure out why, until finally someone actually sat with it. The janitor came in and unplugged the server to plug in his vacuum and boom. Turns out that was his standard practice.