locked
I am getting frequent error messages in SQL error log. RRS feed

  • Question

  • I am getting frequent messages in my sql error log on production box.  I searched on google but nothing found related to this error.  as of now no impact on databases & application side.

    What is this error ? related to SQL or app ? what is the solution to resolve it ?

    Database

    Details: 

    Microsoft SQL Server 2012 (SP3-CU6-GDR) (KB3194724) - 11.0.6567.0 (X64) 
    Oct 10 2016 18:45:52 
    Copyright (c) Microsoft Corporation
    Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

    Error messages:

    Verdasys.Database.SP_REGISTER_MACHINE - Exceeded license limit for Agent Type 1Verdasys.Database.SP_REGISTER_MACHINE - Exceeded license limit for Agent Type 1 at line number 148
     ERROR_NUM: 60000
    , ERROR_MESSAGE: UNKNOWN SQL SERVER MESSAGE

    Friday, March 2, 2018 11:38 AM

All replies

  • Verdasys database size ? share event log?

    https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx


    • Edited by AV111 Friday, March 2, 2018 1:14 PM
    Friday, March 2, 2018 12:02 PM
  • Verdasys.Database.SP_REGISTER_MACHINE - Exceeded license limit for Agent Type 1Verdasys.Database.SP_REGISTER_MACHINE - Exceeded license limit for Agent Type 1 at line number 148

     ERROR_NUM: 60000
    , ERROR_MESSAGE: UNKNOWN SQL SERVER MESSAGE

    Error numbers 50000 and greater are application-defined. This looks to be a message generated by a third party application rather than SQL Server. A cursory internet search on verasys turned up https://en.wikipedia.org/wiki/Digital_Guardian. I suggest you review the vendor product documentation and licensing requirements.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    • Proposed as answer by Tom Phillips Friday, March 2, 2018 3:42 PM
    Friday, March 2, 2018 1:21 PM
  • initially i was also assuming same but there is no Digital _guardian installed on SQL server box.  
    Friday, March 2, 2018 1:25 PM
  • That is not an error generated by sql server. And googling indicates verdasys is now digital guardian - so you have software from that company running and that is configured to use this particular server instance. So go find that software and fix it or fix your usage. This isn't a sql server problem. 
    Friday, March 2, 2018 1:29 PM
  • initially i was also assuming same but there is no Digital _guardian installed on SQL server box.  

    I suggest you view the code for stored procedure Verdasys.Database.SP_REGISTER_MACHINE referenced in the error message. Perhaps that will provide a clue as to the root cause.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    Friday, March 2, 2018 1:31 PM