PR_SYS_TEMP table getting created automatically
PR_SYS_TEMP table is created automatically and is persisted.
Steps to Reproduce
A defect or configuration issue in the operating environment This table is created by the Defragmentation Daemon in order to groom the pr_syslocks table. If the database account used by the Pega platform is not allowed to drop the table it will be persisted to the database.
In this instance there are two possible solutions:
Allow the database account to drop the table
Suppress the running of the daemon by setting this Dynamic System Setting.
This later reverts to pre Pega 7 behavior and the grooming and maintaining tables should be done by DBA operations staff.