Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Schema import on MSSQL instance slows performance (Tomcat 8)



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 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.


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 September 7, 2017 - Updated October 8, 2020

Was this useful?

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.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us