Base solution for your next web application
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?

Markdown is supported
Copy & paste or drag & drop images (max 30 MB per image)
Go to accepted answer
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.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    ajayak created

    Hi @ismcagdas,

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

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi,

    Yes, it shouldn't cause any problem.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
Assignee
No one
Labels
None yet