if you are using a free license of microsft sql, you have a 10gb limitation on the size of the DB. In my case this is the problem.
Try using the archiving in BP Menu
Try built in session logs archival via system tab. If that doesn't solve the issue, try to get in touch with blueprism support and ask for house keeping script.