• No results found

SAP Solution Manager

5 Best-Practice Document: Detailed Table-Specific Information

Z_CMF_KKS_DELETE

5.5 SAP Solution Manager

5.5.1 DSVASRESULTS*: Service Sessions in SAP Solution Manager

The content of the service session performed on your solution manager—for example, Early Watch Alert, Going Live Check, and so on—is stored in tables like DSVASRESULTSGEN, DSVASRESULTSATTR, and DSVASRESULTSSEL (see SAP Notes 1300107 [ST 400]).

5.5.1.1 Avoidance

An Early Watch Alert (EWA) session is automatically created for all systems in all solution landscapes. By ensuring that a system is only assigned to one solution landscape instead of assigning it to many different solution landscapes, you can ensure that an Early Watch Alert session is only executed once per system. 5.5.1.2 Summarization

Cannot be used

5.5.1.3 Deletion

Old sessions can be deleted via standard report RDSMOPREDUCEDATA. After the deletion the sessions disappear from the Solution Manager and are irrevocably lost.

This report can be scheduled via transaction SOLMAN_SETUP, choose scenario ‘Basis Configuration’ and step ‘Configure Manually’. Here, you can choose the activity ‘Delete Session Documents and Download’ to schedule this report on a regular basis.

If a service session was not attached to a solution, report RDSVAS_REDUCE_DATA has to be used alternatively (see SAP Note 1799531).

5.5.1.4 Archiving

Sessions can be archived by moving the data to an external content repository. See also SAP Note:

546685 (ST 320 - 400): Archiving in Solution Manager (operation)

5.5.2 SACONT01, SASACONT1: Document Management in Solution Manager

In SAP Solution Manager, you can manage the documents that arise in the various project phases. Each SAP Solution Manager system has an internal SAP Knowledge Warehouse for storing documents created in a project, solution, or roadmap. The system puts the documents in the context in the Knowledge Warehouse, which you specified when you created the project, solution, or roadmap.

Documents in projects, solutions, or project documentation in a roadmap with project link belong to document area IWBSOLAR.

Roadmap documents (topics, accelerators) belong to document area IWBASAP.

The SAP Solution Manager system has its own Knowledge Warehouse to store documents, but you can also connect an external SAP Knowledge Warehouse.

A project can generate a lot of data because SAP Solution Manager saves every version of a document by default. You can relieve the database by moving the contents of documents that you have created in a project into another data repository. You can also delete old versions of documents that you no longer need.

Table SACONT01 basically contains document content belonging to SAP Solution Manager and stored using Knowledge Warehouse. These documents are created and managed in the implementation area (SOLAR01, SOLAR02) and, depending on the usage of projects, this table can grow very big. As long the documents are

being created and managed, every version of these documents is stored (you may access older versions through the document’s history of changes). That is the main reason for the table growth.

Also, even if you don’t use projects and have never created a project, this table will grow as long as you work with SAP Solution Manager implementation content (ST-ICO) packages. This package delivers content for the implementation area, and one example is the Business Process Repository (BPR) content. This includes many previously built business scenarios and documents for usage in projects.

Regarding table SASACONT1, it is very similar to SACONT01 but it is specifically for roadmap content. It handles the content created for roadmaps and content delivered by ST-ICO.

See SAP Note:

966400 (Solution Manager ST 400): Solution Manager and Knowledge Warehouse 5.5.2.1 Avoidance

Cannot be used

5.5.2.2 Summarization Cannot be used

5.5.2.3 Deletion

Report SOLMAN_DOCU_VERSION_DEL deletes older versions of documents in all data repositories. But only table SACONT01 is concerned. Please check SAP Note 1360436 for futher information regarding this report.

If you are authorized, this program also deletes the contents of documents that you have moved into another data repository or archive with program SOLMAN_DOCU_VERSION_ARCHIVE.

Report SOLMAN_UNUSED_DOCUMENTS searches for unused documents. A document is considered unused when it is not assigned to any project but it still exists physically. The report searches for all

documents created by a user and checks whether they are used. The system issues documents for which it cannot find a record of use in a list. The listed documents can be selected individually and deleted if required. For further instructions on how to use this report, please check SAP Note 923203.

Please be aware that only table SACONT01 will be touched by these reports.

See SAP Notes:

1360436 (Solution Manager ST 400): Error in the program SOLMAN_DOCU_VERSION_DEL 923203 (Solution Manager ST 320 - 400): Deleting unused documents from the Solution Manager

5.5.2.4 Archiving

For archiving of table SACONT01, please check use of report SOLMAN_DOCU_VERSION_ARCHIVE. This report moves the contents of documents or older versions of documents into another data repository, for example, into an archive. The document header data and attributes are retained in SAP Solution Manager. The SOLMAN_DOCU_VERSION_ARCHIVE program moves all document versions of the selected status values that were changed last by a person other than SAP, except for the most recent version in each language.

You can find further information and how to use this report in SAP Note 1360988.

1360988 (Solution Manager ST 400): Error in the program SOLMAN_DOCU_VERSION_ARCHIVE 1773780 (Solution Manager ST 700 – 720): How to check if a document was successfully archived by SOLMAN_DOCU_VERSION_ARCHIVE

As far as table SASACONT1 is concerned, the size of the table is either determined by use of a large number of own roadmaps or by the roadmap documents contained in ST-ICO.

Unfortunately, if you delete unused roadmaps, this does not delete the corresponding documents. There will be a deletion report in the future.

However, it is planned to reduce the size of future Support Packages of ST-ICO by deleting unused or outdated roadmap documents. This would be a solution if there is not an acute problem with table space but only concerns of further growth.

The usual way to reduce the size of this table is to move the content to an external content server.

In transaction OAC0, you can change the Customizing of a content repository and assign an external content server instead of the currently maintained DB table. This is explained in SAP Note 546685 and the detailed steps are contained in SAP Note 710711.

See SAP Notes:

546685 (Solution Manager ST 320 - 400): Archiving in Solution Manager (operation) 710711 (Solution Manager ST 310 - 400): Solution Manager: Using a Content Server