Rhythmyx configuration to avoid "name (or sys_title) contains leading or trailing spaces" warning in log trace

Rhythmyx
1

Starting from Rhythmyx version 7.3 during server startup, in the server log we would notice following warning trace for all system title entries with trailing space in them. 

WARN [PSItemEntry] name (or sys_title) contains leading or trailing spaces for contentId: :


To cleanup existing trailing spaces in sys_title field, we can run following sql statement at the database end:

SQLSERVER:
UPDATE CONTENTSTATUS SET TITLE= LTRIM(RTRIM(TITLE));
ORACLE:
UPDATE CONTENTSTATUS SET TITLE= TRIM(TITLE);

To avoid future entries with trailing spaces in system title field, we can configure trim function for sys_title field. Please find attached screenshot where the sys_title field is configured for trim function. This update requires server restart to take effect.