Question Re: SAPHOSTAGENT causing Event ID: 15457 on SQL Server in Technology Q&A

SAPHOSTAGENT causing Event ID: 15457 on SQL Server

Former Member — Tue, 02 Dec 2014 11:48:55 GMT

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

Re: SAPHOSTAGENT causing Event ID: 15457 on SQL Server

S_Sriram — Wed, 03 Dec 2014 12:48:01 GMT

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

Re: SAPHOSTAGENT causing Event ID: 15457 on SQL Server

Former Member — Wed, 03 Dec 2014 13:57:42 GMT

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

Re: SAPHOSTAGENT causing Event ID: 15457 on SQL Server

S_Sriram — Wed, 03 Dec 2014 19:01:21 GMT

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?

Re: SAPHOSTAGENT causing Event ID: 15457 on SQL Server

Former Member — Thu, 04 Dec 2014 07:52:06 GMT

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

Re: SAPHOSTAGENT causing Event ID: 15457 on SQL Server

S_Sriram — Thu, 04 Dec 2014 07:59:37 GMT

Hi Jose

Thanks for your info

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

Re: SAPHOSTAGENT causing Event ID: 15457 on SQL Server

Former Member — Thu, 04 Dec 2014 08:17:46 GMT

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