CHECK DB (DB13) Scheduling failed MySQL

[Former Member]

Hi everyone,

just made an upgrade of kernel 7.0 to 7.20 and now the scheduling in db13 is failling. Check in the OS an the log is ok, check DB runs with success.

Any hints on why SAP Logon is giving this error?

PS- all check DB logs previous to the update also indicate that the scheduling failed, but they were ok before.

Thanks in advance,

MV

[Former Member]

Hi Vera,

Please check R3trans -d and R3trans -x and paste the output and screenshot of the DB13 faild schedule.

Regards

Ganesh Datt Tiwari

[Former Member]

Hi tiwari,

here are the transcripts from cmd

R3trans -d

F:\usr\sap\HST\SYS\exe\uc\NTAMD64>R3trans -d

This is R3trans version 6.23 (release 720 - 15.05.12 - 20:12:03).

unicode enabled version

R3trans=>sapparam(1c): No Profile used.

R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

R3trans finished (0000).

R3trans -x

F:\usr\sap\HST\SYS\exe\uc\NTAMD64>R3trans -x

This is R3trans version 6.23 (release 720 - 15.05.12 - 20:12:03).

unicode enabled version

R3trans=>sapparam(1c): No Profile used.

R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

R3trans finished (0000).

[MaheshKumar]

Hi Vera,

Could you please post logs for this. You can get this log from db13 > click on failed check db > Action Log and show detailed action log > detailed log.

Please post tail of the log

[Former Member]

Hi Kumar,

No logs are displayed in db13.

Looked up the logs in OS and they are ok, check DB is made with success.

[MaheshKumar]

Looked up the logs in OS and they are ok, check DB is made with success.

In DB13 calender is the check db showing green? Manually schedule check db for single time and post the logs.

[Former Member]

DB13 calendar is red. Already did a manual check in sap logon and still gives scheduling failed. Only in OS i can see that the check DB is performed correctly

[Former Member]

Hi Vera,

What is your database and OS ?

If oracle then try to run brtools

[Former Member]

hi,

sorry, thought i said that the db was SQL. My fault.

thanks,

MV

[Former Member]

Please check the permissions of files in kernel directory

Please tell us teh OS and DB Plateform of your system.

IF you are runniong UNIX os and Oracle then check the Note 113747 - Owners and authorizations for BR*Tools

Regards

Ganesh Datt Tiwari

[Former Member]

OS Windows MySQL DB

[Former Member]

Hi Vera,

Execute t. code DB02 and check the Alert log.

Reagrds

Ganesh Datt Tiwari

[Former Member]

no alert log in DB02, check in the OS the mysql log and everything is ok. There is no problem with the Check DB the only problem is that the information is not passing from the DB to Sap Logon.