Support Article
Database Schema is not loading
SA-27880
Summary
The 'Schema change tracking' page loads with an error message with Pega 7.2.1.
Error Messages
Errors:
The Flow Action pre-processing activity pzGetAllChanges failed: caught exception during autocommit check
Steps to Reproduce
Open using the following : Designer studio > System > Database >Schema Change Tracking.
Root Cause
Query execution is taking lot of time in their environment.
Resolution
Resolve the issue by updating or enabling the below parameter:
set enable_hashjoin=1;
Published September 23, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.