[DB Cleaner on Steroids] How to Empty Table for Espace Version?
Forge component by Miguel 'Kelter' Antunes
Application Type
Reactive
Service Studio Version
11.11.14 (Build 48586)

I have been using DB Cleaner on Steroids.

Figure 1 Tablespace usage 

The Espace Version is Consuming Too Much Space,Optimal to reduce to 10MB


Questions

A)Can I truncate this table ossys_Espace_Version  in SQL ?

B)How to Empty this Table ossys_Espace_Version  and Ensure the storage is 0MB ?

C)How to Limit the ossys_Espace_Version  Table to 10MB?

D)How to drop Force table ossys_Espace_Version ?



 

Figure 2. Automated CleanUp Set to one week / 2 days and limited to 100 records


1. Service Center In Application Log I have disable most of the Audit Log and error logs.

2. Remove All oldEspace Version using -1 in the search box

3. Scheduled Automated Clean Up is set up 




Solution

Thanks for your suggestion.

Here is the Updated Settings


I found in the logs 

The DELETE statement conflicted with the REFERENCE constraint "OSFRK_OSSYS_ESPACE_OSSYS_ESPACE_VERSION_VERSION_ID". The conflict occurred in database "T7IBBE011", table "dbo.ossys_Espace", column 'VERSION_ID'.
The statement has been terminated.



This Questions is Closed. Outsystems Espace Version consumes Space.

There is no solution but to Purchase Larger Harddisk.

Interim Procedure it to

1. Limit The audit Log 

2. Do Scheduled Clean Up

3. Be Rich, so that expensive Plan can be purchased in Outsystems to overcome storage problem.

Thanks Community.


Hi Calvin,

Maybe the following helps for your case:

There are 2 Site Properties OldApplicationVersions and OldSolutionVersions in DB Cleaner On Steroids module and are both set to 10 by default. You can change them both to 0. 

This will make it so that only the current version is stored and older versions will be cleaned.

This will be useful in terms of database space savings but won't let you go back to previous versions. 

Regards

Solution

Thanks for your suggestion.

Here is the Updated Settings


I found in the logs 

The DELETE statement conflicted with the REFERENCE constraint "OSFRK_OSSYS_ESPACE_OSSYS_ESPACE_VERSION_VERSION_ID". The conflict occurred in database "T7IBBE011", table "dbo.ossys_Espace", column 'VERSION_ID'.
The statement has been terminated.



This Questions is Closed. Outsystems Espace Version consumes Space.

There is no solution but to Purchase Larger Harddisk.

Interim Procedure it to

1. Limit The audit Log 

2. Do Scheduled Clean Up

3. Be Rich, so that expensive Plan can be purchased in Outsystems to overcome storage problem.

Thanks Community.


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.