Customer Service ruleset import hangs
SummaryDoing an install of Customer Service for Communications 7.21 on top of a fresh 7.21 platform.
While importing the Customer Service.jar, the user session appears hung, the PegaRULES log contains no error, and the import does not complete.
Error MessagesNot Applicable
Steps to Reproduce
- Import Customer Service.
- Press Next as applicable.
- System hangs without displaying the number of records page.
Root CauseA defect or configuration issue in the operating environment.
Thread dumps from the hung import point to DatabaseDatabaseMetaData.getColumns() call hanging.
Most likely cause is that the DB user has DBA privileges and can look into other schemas which makes this metadata call expensive.
ResolutionMake the following change to the operating environment:
Install Customer Service jar on a Oracle instance with single schema.
Make sure the DB user is set up for run time use according to the install guide:
"Single-user configuration— Base user only Pegasystems recommends that user creates an Admin user separate from the Base user; however, if user opts for a single Base user, grant these permissions to the Base user: l CREATE SESSION l CREATE TABLE l CREATE PROCEDURE l CREATE VIEW l CREATE TYPE l CREATE TRIGGER"
Published August 17, 2016 - Updated September 7, 2016