BPASessionLog_NonUnicode
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
21-09-17 06:36 PM
Hello,
In DB table BPASessionLog_NonUnicode is the biggest one (7 GB) can we clean it up or just delete some data?
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-09-17 12:31 PM
Sessions logs and queues normally account for most of the DB size, however I would not recommend deleting data via SQL because you might damage the DB. Use the Archive function in the BP client.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-18 08:04 PM
We are getting same issue as ""database size is full and need to delete some space for ""BPAsessionlog_nonunicode"""". We are deleting logs from BP client archiving function regularly. Is there any other resolution for this issues. Its hammering the data logs and reports.
Previously we used to keep logs around 10 days but now within 4 days its throwing disk full massage.
below is the actual massage:
Number of rows of table [PRD_BP_DBTWO].[dbo].[BPASessionLog_NonUnicode] higher than 100000000 (436184847)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-02-18 11:14 PM
You can also go through processes and disable logging for steps in order to reduce the log sizes for each execution
