Simple Windows Batch Script to clear the Rhythmyx cahce

Rhythmyx Code & Snippet Repository
1

The batch file has been renamed RxClearCache.bat.txt to be able to attach it to this post.

Make sure the Percussion Rhythmyx service is stopped before running the script RXClearCache.bat

The script will move the following files and directories
\Rhythmyx\AppServer\server\rx\data\hypersonic
\Rhythmyx\AppServer\server\rx mp\
\Rhythmyx\AppServer\server\rx\work\
\Rhythmyx\ObjectStore\UserConfigurations\
\Rhythmyx \ObjectStore.rxlocks\
All dbg_.sys_CEHandler* files at \Rhythmyx\
All .sys_CEHandler* directorites at \Rhythmyx
\Rhythmyx emp\publish

into the directory C:\TEMP\RXCACHE

This script requires the Path to the Rhythmyx directory.

E.g

C:\RhythmyxUtils\RXClearCache.bat C:\Rhythmyx

2

Database Script to Delete the Publishing Log

TRUNCATE TABLE PSX_TEMPIDS;
TRUNCATE TABLE PSLOG;
TRUNCATE TABLE PSLOGDAT;
TRUNCATE TABLE PSX_PUBLICATION_DOC;
TRUNCATE TABLE PSX_PUBLICATION_STATUS

Database Script to Reset Publishing Items History, this SQL statement will make an Incremental Edition do a full Publish
DELETE FROM PSX_PUBLICATION_SITE_ITEM;

3

Database Script to Delete the Publishing Log

TRUNCATE TABLE PSX_TEMPIDS;
TRUNCATE TABLE PSLOG;
TRUNCATE TABLE PSLOGDAT;

(TRUNCATE TABLE PSX_PUBLICATION_DOC;
TRUNCATE TABLE PSX_PUBLICATION_STATUS) These 2 statements will cause a key constraints error, so delete from the table instead.

Database Script to Reset Publishing Items History, this SQL statement will make an Incremental Edition do a full Publish
DELETE FROM PSX_PUBLICATION_SITE_ITEM;
DELETE FROM dbo.PSX_PUBLICATION_DOC;
DELETE FROM dbo.PSX_PUBLICATION_STATUS