Data Truncation issue with Enterprise Library Logging WriteLog stored Proc RRS feed

  • Question

  • User-811114996 posted

    Hi ,

    I'm using Enterprise Library Logging  feature for logging. The issue i am facing is when the Logging message is too large(more than 65534 chars) ,complete data  is not logged in the Formatted Mesage column which is  of data Type nText .

    I am able insert complete data if i try inserting from Sql insert Query from sql management studio. Do i need to add any attributes to data base listener or do i need to change the sp.

     Is there any way to increase the WriteLog stored proc param size in EnterpriseLibrary.Logging config file ? . Please let me know.


    Thanks In Advance.

    Tuesday, August 3, 2010 5:53 AM


  • User-811114996 posted

    I have looked into Enterprise Library Logging source code and found that formatted message is

    sent to database with data type dbType.String , may be this was one of the reasons.


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, August 5, 2010 11:22 AM