SQL error 207


  • w3wp.exe is causing this EventID 5586 

    Unknown SQL Exception 207 occurred. Additional error information from SQL Server is included below. Invalid column name 'tp_IsCurrent'.

    Invalid column name 'tp_IsCurrent' - from the SQL executed for AllUserData table of the content database.

    When I read more about this column in the database I found this description.

    tp_IsCurrent: When a file is checked out, tp_IsCurrent is set to false on that file’s record, and a new line is created for the checked-out version of the file (wherein tp_IsCurrent becomes true). 

    but there's no versioning enabled and no checked out document

    How do I avoid this error? 

    Wednesday, April 19, 2017 10:43 AM


  • Hi,

    Which operation causes this issue?

    5586 is a generic SQL error for SharePoint. SharePoint side logs is deeply unlikely to help as that's already going to be coming in at the top end. To find out more detail you'll need to check the SQL server to see if there's more detailed logs there.

    Best Regards,

    Dean Wang

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact

    • Marked as answer by JmATK Monday, April 24, 2017 11:30 AM
    Thursday, April 20, 2017 6:52 AM