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)
- 
    0hi 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? 
- 
    0unfortunately 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. 
- 
    0hi 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. 
- 
    0This question has been automatically marked as stale because it has not had recent activity. 
 
                                