Show TOC

Cleaning Up Data in the SAP ECM Back-End SystemLocate this document in the navigation structure

Use

Applications can use the ECM integration layer to save data in repositories of the SAP ECM back-end system and call it up when required. This data is saved as follows:

  • Files: in a file system

  • Metadata for these files: in the database of the SAP Application Server Java

    The metadata includes information about the data structure and the relationship between the hierarchy nodes, as well as parameters of the files and hierarchy nodes.

To make sure that the data in the SAP ECM repository is consistent, you can schedule a data cleanup job to check the entries in the file system and the database, and clean up redundant or inconsistent data.

Checks

The data cleanup is based on the following checks:

  • Does each file have a database entry? Does each database entry have a file?

  • Does a hierarchy node have a reference to a higher-level node?

  • Does an entry, lock flag, or parameter have a reference to a hierarchy node?

  • Does a value have a reference to a parameter?

  • Does a hierarchy node relationship have a reference to a higher-level or lower-level node?

  • Does a hierarchy node relationship exist more than once?

Data Security

To identify in advance the changes that will be made by the data cleanup, you can execute the job in test mode. In this mode the data cleanup is simulated and displayed in the log.

If you execute the data cleanup in normal mode, the system saves the cleaned-up data as follows:

  • Database entries that are deleted due to inconsistencies are written to a backup file in the folder user/sap/<sapsid>/SYS/global/ecmstore_job_backup.

  • Unreferenced files are moved to the backup folder <config-pfad>/content_backup. The path to this folder is defined in the configuration of the repository.

Procedure

  1. Open SAP NetWeaver Administrator in the browser.

  2. Choose Start of the navigation path Operations Next navigation step Jobs Next navigation step Java Scheduler End of the navigation path.

Schedule Data Cleanup

  1. In Java Scheduler , select the Tasks tab page.

  2. Choose Add .

  3. In the Select Job step, select the entry EcmStoreCleanupJob.

  4. To define whether the data cleanup is to be run in test or normal mode, proceed as follows:

    1. Go to the Set Properties step.

    2. Test mode is activated as the default. If you want to run the data cleanup in normal mode, deactivate the TestMode parameter.

  5. Schedule the start time of the data cleanup as follows:

    1. Go to the Set Execution Time step.

    2. Select the Simple tab page.

    3. Enter the start time and choose Add .

  6. To release the data cleanup for execution, choose Finish .

View Results of Data Cleanup

  1. In Java Scheduler , select the Jobs tab page.

  2. Select the executed data cleanup job.

  3. Under Job Details , view the data for the job and the activities that were performed:

    • On the Parameters tab page, check whether the job was executed in the required mode (depending on the TestMode parameter).

    • On the Logs tab page, view the job log.