locked
ESENT error RRS feed

  • Question

  • Hello,

    I am new to SQL and our SQL servers are showing the following errors:

    Log Name:      Application

    Source:        ESENT

    Date:          2/24/2020 10:41:35 AM

    Event ID:      455

    Task Category: Logging/Recovery

    Level:         Error

    Keywords:      Classic

    User:          N/A

    Computer:      Server.Domain.com

    Description:

    sqlservr (4572) SoftwareUsageMetrics-Api: Error -1032 (0xfffffbf8) occurred while opening logfile C:\WINDOWS\system32\LogFiles\Sum\Api.log.

    Event Xml:

    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

      <System>

        <Provider Name="ESENT" />

        <EventID Qualifiers="0">455</EventID>

        <Level>2</Level>

        <Task>3</Task>

        <Keywords>0x80000000000000</Keywords>

        <TimeCreated SystemTime="2020-02-24T15:41:35.244886600Z" />

        <EventRecordID>5276</EventRecordID>

        <Channel>Application</Channel>

        <Computer>Server.Domain.com</Computer>

        <Security />

      </System>

      <EventData>

        <Data>sqlservr</Data>

        <Data>4572</Data>

        <Data>SoftwareUsageMetrics-Api: </Data>

        <Data>C:\WINDOWS\system32\LogFiles\Sum\Api.log</Data>

        <Data>-1032 (0xfffffbf8)</Data>

      </EventData>

    </Event>

    Log Name:      Application

    Source:        ESENT

    Date:          2/24/2020 10:41:25 AM

    Event ID:      490

    Task Category: General

    Level:         Error

    Keywords:      Classic

    User:          N/A

    Computer:      Server.Domain.com

    Description:

    sqlservr (4572) SoftwareUsageMetrics-Api: An attempt to open the file "C:\WINDOWS\system32\LogFiles\Sum\Api.chk" for read / write access failed with system error 5 (0x00000005): "Access is denied. ".  The open file operation will fail with error -1032 (0xfffffbf8).

    Event Xml:

    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

      <System>

        <Provider Name="ESENT" />

        <EventID Qualifiers="0">490</EventID>

        <Level>2</Level>

        <Task>1</Task>

        <Keywords>0x80000000000000</Keywords>

        <TimeCreated SystemTime="2020-02-24T15:41:25.218916300Z" />

        <EventRecordID>5274</EventRecordID>

        <Channel>Application</Channel>

        <Computer>Server.Domain.com</Computer>

        <Security />

      </System>

      <EventData>

        <Data>sqlservr</Data>

        <Data>4572</Data>

        <Data>SoftwareUsageMetrics-Api: </Data>

        <Data>C:\WINDOWS\system32\LogFiles\Sum\Api.chk</Data>

        <Data>-1032 (0xfffffbf8)</Data>

        <Data>5 (0x00000005)</Data>

        <Data>Access is denied. </Data>

      </EventData>

    </Event>

    Log Name:      System

    Source:        Microsoft-Windows-DistributedCOM

    Date:          3/2/2020 9:00:51 AM

    Event ID:      10010

    Task Category: None

    Level:         Error

    Keywords:      Classic

    User:          SYSTEM

    Computer:      Server.Domain.com

    Description:

    The server {784E29F4-5EBE-4279-9948-1E8FE941646D} did not register with DCOM within the required timeout.

    Event Xml:

    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

      <System>

        <Provider Name="Microsoft-Windows-DistributedCOM" Guid="{1B562E86-B7AA-4131-BADC-B6F3A001407E}" EventSourceName="DCOM" />

        <EventID Qualifiers="0">10010</EventID>

        <Version>0</Version>

        <Level>2</Level>

        <Task>0</Task>

        <Opcode>0</Opcode>

        <Keywords>0x8080000000000000</Keywords>

        <TimeCreated SystemTime="2020-03-02T14:00:51.124966600Z" />

        <EventRecordID>6407</EventRecordID>

        <Correlation />

        <Execution ProcessID="644" ThreadID="8412" />

        <Channel>System</Channel>

        <Computer>Server.Domain.com</Computer>

        <Security UserID="S-1-5-18" />

      </System>

      <EventData>

        <Data Name="param1">{784E29F4-5EBE-4279-9948-1E8FE941646D}</Data>

      </EventData>

    </Event>


    r

    Monday, March 2, 2020 2:30 PM

Answers

  • Hi Cathy,

    Thank you for the response.  The issue has been resolved. It was related to a recent update.  

    Thanks,

    Roger


    r

    • Marked as answer by Vallee18 Tuesday, March 3, 2020 5:32 PM
    Tuesday, March 3, 2020 5:32 PM

All replies

  • Are you facing any issue in SQL Server, although message start with SQLSERVER but none of them is related to SQL Server per se

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Monday, March 2, 2020 3:22 PM
  • Hello Shashank,

    One of the SQL servers has latency issues when trying to run a data load.  You said that although the 455 and 490 errors above reference SQL server, what would indicate that they are not truly SQL server related?

    Are you aware if these errors are an indication of an issue that requires attention or something that can be ignored if they don't occur frequently?

    Thanks,

    Roger


    r

    Monday, March 2, 2020 7:02 PM
  • Hi Roger,

    What is your SQL server version? You can check it using select @@version. Please share us the related error message from your SQL server error log. Please refer to Viewing the SQL Server Error Log.

    >>One of the SQL servers has latency issues when trying to run a data load.

    What are you doing when you met the issue? Import data to SQL server in SSMS? Running some T-SQL? Or others?

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, March 3, 2020 7:07 AM
  • Hi Cathy,

    Thank you for the response.  The issue has been resolved. It was related to a recent update.  

    Thanks,

    Roger


    r

    • Marked as answer by Vallee18 Tuesday, March 3, 2020 5:32 PM
    Tuesday, March 3, 2020 5:32 PM