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.
Published February 13, 2016 - Updated October 8, 2020
Was this useful?
0% found this useful
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.