SASCONT1 table growing of 3 GB

[benoit-schmid]

Hello,

After applying the support packages in our Solution Manager,

the table SASACONT1 has grown 3 GB.

1. Would you know what does this table contain?

2. Are there standard reports to clean/purge it?

Thanks in advance for your answer.

[aena_dtiddsap · Accepted solution]

Table SASCONT1 contains documents os Solution Manager.

Yo have and explanation of the growing size of the table and how to reduce the size with a report: http://scn.sap.com/community/it-management/alm/solution-manager/blog/2012/07/17/how-to-reduce-the-si...

Regards,

Nerea de Andrés

[benoit-schmid · Accepted solution]

Hello Nerea,

As we say in french, late answer is better than never.

Why has it grown especially during support packages?

Couldn't I use RDSMOPREDUCEDATA to purge this table?

Regards,

[Former Member · Accepted solution]

Hi,

as posted by Fabricius Zatti: It handles the content created for roadmaps and content delivered by ST-ICO as well, more specifically documents. 

In summary, both tables are directly related to the implementation area of Solution Manager and can grow a lot depending on the usage of this area and the amount of content created.

Reports from this post are only valid to clean SACONT1 table and. But if you need to clean table SASACONT1 there is no special report so, you can use report RDSMOPREDUCEDATA as per note Note 546685 - Archiving in Solution Manager (operation).

Regards.

[benoit-schmid · Accepted solution]

Hello,

I have purge old sessions up to 30.6.2012 with th report RDSMOPREDUCEDATA.

But nothing has been deleted in SASACONT1 Table.

Before the report execution:

SQL> select count(*) from sapsr3.sasacont1;

   1405948

After the report execution:

SQL>  select count(*) from sapsr3.sasacont1;

   1405948

Would you know why nothing has been purged in this table?

Thanks in advance for your answer.