Open Closed

Audit Dashboard is throwing Error #1051


User avatar
0
shobhit created

Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/ Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, please use the search on the homepage.

  • ABP Framework version: v4.0.2
  • UI type: Angular
  • DB provider: EF Core
  • Tiered (MVC) or Identity Server Separated (Angular): yes
  • Exception message and stack trace:
  • 2021-03-16 16:32:48.458 +05:30 [ERR] An exception occurred while iterating over the results of a query for context type 'Volo.Abp.AuditLogging.EntityFrameworkCore.AbpAuditLoggingDbContext'. Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out.
  • Steps to reproduce the issue:
  • go to home page --> administration menu
  • click the audit log
  • Wait for some time. error thrown.

4 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi

    The timeout period elapsed prior to completion of the operation or the server is not responding.

    Do you have lage of audit log? This seems to be a database problem.

    Can you reproduce this in the brand new template project?

  • User Avatar
    0
    shobhit created

    unfortunately your ticket site don't allow to copy the the complete error log. Please confirm how i can share the log file.

    Regarding new template, yes all is working good but unfortunately in my project i have to add features and so logs table will be of high size. yes you are correct it is db performance issue. Can you help me how i can resolve it or to give this help what all input you need from my side.

  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi

    unfortunately your ticket site don't allow to copy the the complete error log. Please confirm how i can share the log file.

    You can share log by email. liming.ma@volosoft.com

    db performance issue

    You can consider using other ways to store the audit log, such as mongodb or use a separate database to store it.

  • User Avatar
    0
    ServiceBot created
    Support Team Automatic process manager

    This question has been automatically marked as stale because it has not had recent activity.

Made with ❤️ on ABP v9.1.0-preview. Updated on December 05, 2024, 12:19