Support Article

Schema import on MSSQL instance slows performance (Tomcat 8)

SA-36315

Summary



Users report that the Schema import on an MSSQL instance is taking unusually longer than expected and sometime the system itself hangs.
No errors appear in the logs and a restart of the instance also did not help.
The application server is Tomcat 8.


Error Messages



Not Applicable


Steps to Reproduce

  1. Log in to the application.
  2. Go to Designer Studio >Application >Distribution >Import. Click Next.
  3. Select PegaFSIFSampleData_Schema_07.22.zip and click Next.


Root Cause



A defect or configuration issue in the operating environment
The schema import caused more thread creation, which the Tomcat 8 application server configuration does not support.
For the Tomcat 8 application server, some parameters have been changed, for example, maxActive changed to maxTotal and maxWait changed to maxWaitMillis.

Resolution



Perform the following local-change:

Set the Tomcat 8 parameters maxTotal and maxWaitMillis to some higher values to support the creation of additional threads during schema import.

Published April 11, 2017 - Updated September 7, 2017


100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.