SAPHOSTAGENT causing Event ID: 15457 on SQL Server

[Former Member]

Hello folks,

While checking the status on a machine, I noticed these entries in Windows log (eventvwr):

Text is:

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

These messages come from SQL Server:

Messages appear each 15 minutes. I monitored the activity at DB level on these moments using sys.dm_exec_requests queries but nothing came up.

Using Profiler, I set up a general trace and found the PID who was launching command sp_configure. Using Sysinternals' Process Explorer, I identified the PID as an instance of sapdbctrl.exe started by SAP Host Agent.

I ensured that these messages were being caused by this program. If SAP Host Agent is stopped or sapdbctrl.exe is not present (renamed to .exe.bak, for example) the messages no longer appear.Also the reconfigure command is always being executed:

OS is Microsoft Windows Server 2008 R2 Standard SP1

DB is Microsoft SQL Server 2008 R2 Service Pack 1 CU1

SAPHOSTAGENT is SAPHOSTAGENT 720 SP 73

Is there any way to avoid these messages?

Thanks in advance and best regards.

José Enrique

[Sriram2009]

Hi Jose

Event ID 15457 is just information, its not warning or error, you can refer the Microsoft link with same issue

SQL server agent- agent Xps disabled

BR

SS

[Former Member]

Hi Sriram,

Thanks for your answer.

I am aware that the messages don't pose any threat but I would like to have only relevant messages in the log (whenever possible).

I think that when config_value matches run_value in SQL Server the message asking for RECONFIGURE should not be issued.

Likewise, SAP Host Agent should verify whether the advanced options are being shown before executing the sp_configure command.

Any of these two behaviors would suffice, but I don't know whether it is even possible to configure them.

Best regards,

José Enrique

[Sriram2009]

Hi Jose

Thanks for info

1. Is it possible to raise the support ticket to Microsoft. to check this message. In my view it may be missing some of MS Sql Service pack or windows update.

The same message appeared in my system last year.

2. On your system which version & release of kernel used?

BR

SS

[Former Member]

Hi Sriram,

We don't have direct support with Microsoft and the issue is not even a problem, its more of a matter of aesthetics.

Versions are:

OS is Microsoft Windows Server 2008 R2 Standard SP1

DB is Microsoft SQL Server 2008 R2 Service Pack 1 CU1

SAPHOSTAGENT is SAPHOSTAGENT 720 SP 73

Best regards,

José Enrique

[Sriram2009]

Hi Jose

Thanks for your info

Is it possible to do the upgrade of kernel 400 and above ?

BR

SS

[Former Member]

Hi Siriam,

Kernel (SAP Host Agent part) is 720 SP 73, I don't know what kernel 400 is.

To pass a kernel upgrade to my control department I would need some evidence (e. g. a SAP note) that it will fix the issue.

Best regards,

José Enrique