KB73059354: WebCenter - Cleanup script does not run

Summary

When removing projects and documents in WebCenter, their files and database entries are not removed immediately (for speed reasons). Instead, they are marked for deletion in the database so you don't see them anymore in the user interface. 
To remove these files from the filestore, you must regularly (typically every night) run the cleanup script, called Cleanup.bat.

This removes all restfiles from deleted projects and removes entries which are no longer used in the database.

 However the following error can occur:

"Could not log into WebCenter properly. Make sure to submit correct authentication credentials."

For more information on the cleanup tool see: http://help.esko.com/docs/en-us/webcenter/12.1/userguide/en-us/common/wc/task/ta_wc_DBCleanupUtility.html

Solution

This error typically occurs because the cleanup tool needs to logon to Webcenter to execute cleanup.For this it needs a username and a password.

WebCenter 12.1 and later:

There is a dedicated user (CLEANUP) for the CLEANUP tool to perform its tasks. The password is automatically assigned by WebCenter.

Also see:

• Page:
  KB75765203: WebCenter - CADX, CLEANUP and WORKFLOW users

WebCenter 12.0 and before:

There is the access.properties file in the config folder that contains the credentials of the user used by the cleanup tool to login to WebCenter. By default, they are the (encrypted) credentials of the ADMIN user. So, you have to make sure the password in this file is the same one as the encrypted password of the ADMIN user. You can find it in the Pwrd column of the Users table in the WebCenter database.

Procedure:

1. Edit the access.properties file in the config folder (typically at C:\Esko\Artios\WebCenter\ApplicationServer\Cleanup\config folder) for the Cleanup.bat file.
2. Change the password field to the password of the Admin user that you can find in the Pwrd column of the Users table in the WebCenter database (this is an encrypted version of the admin password).
3. Try running the cleanup script again (you need not restart any service).