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