on 05-14-2012 4:09 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
Hello,
Would you know why it has only increased in size when SPS were applied?
01.10.2012 | 5.308.416 | 0 | 81 | 0 | 1.024 | ||
01.09.2012 | 5.308.416 | 0 | 81 | 0 | 1.024 | ||
01.08.2012 | 5.308.416 | 0 | 81 | 0 | 1.024 | ||
01.07.2012 | 5.308.416 | 0 | 81 | 0 | 1.024 | ||
01.06.2012 | 5.308.416 | 0 | 81 | 0 | 1.024 | ||
01.05.2012 | 5.308.416 3.080.192 | 81 | 47 | 1.024 | |||
01.04.2012 | 2.228.224 | 0 | 34 | 0 | 1.024 | ||
01.03.2012 | 2.228.224 | 0 | 34 | 0 | 1.024 | ||
01.02.2012 | 2.228.224 | 0 | 34 | 0 | 1.024 | ||
01.01.2012 | 2.228.224 | 0 | 34 | 0 | 1.024 | ||
01.12.2011 | 2.228.224 | 0 | 34 | 0 | 1.024 | ||
01.11.2011 | 2.228.224 | 0 | 34 | 0 | 1.024 |
Thanks in advance for your answer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Would you know why it has only increased in size when SPS were applied?
As mentioned in the article mentioned above "the size of this table will be mainly determined by the roadmap documents contained in ST-ICO"
It makes sense that if you dont use roadmap documents then it will only increase when the templates included in package ST-ICO are imported via a Support Package,
Regard, Juan
This growth looks normal to me. same table is over 4gb in our system too and .
Regards
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.