Base solution for your next web application
Starts in:
01 DAYS
01 HRS
01 MIN
01 SEC
Open Closed

Delete old notifications from AbpTenantNotifications table #10317


User avatar
0
ajayak created

Prerequisites

  • What is your product version? 10.2
  • What is your product type (Angular or MVC)? Angular
  • What is product framework type (.net framework or .net core)? ,net core

Our AbpTenantNotifications table size has grown to 536.11 MB. How can we delete old notifications from this table directly from DB? Any SQL query?


3 Answer(s)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @ajayak

    These records should be deleted automatically. Could you share your ABP NuGet package version ? There was a problem about background jobs, upgrading to 6.3.1 might solve this problem.

    For existing records, you need to delete them manually.

  • User Avatar
    0
    ajayak created

    Hi @ismcagdas,

    Is it ok if I delete records from AbpTenantNotifications table directly?

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi,

    Yes, it shouldn't cause any problem.