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

Frozen screen when deploying FSIF

SA-32018

Summary



The screen freezes while importing Financial Services Industry Foundation Version 7.21, in JBOSS and SQL Server 12 environment.

Error Messages



10:28:22,563 INFO [stdout] (Dispatcher-Thread-101) 2016-12-17 10:28:17,716 [8109-3] [TABTHREAD0] [ ] [ PegaRULES:07.10]
(l.access.ConnectionManagerImpl) ERROR your_host | - Not returning connection 16 for database "pegadata" to the pool as it
previously encountered the following error
10:28:22,563 INFO [stdout] (Dispatcher-Thread-101) User ID: (unknown)
10:28:22,563 INFO [stdout] (Dispatcher-Thread-101) Last SQL: (unknown)


Steps to Reproduce

  1. Navigate to Designer Studio > Application > Distribution > Import.
  2. Upload the ZIP files.
  3. Proceed further, and accept Auto for schema changes.

Root Cause



A defect or configuration issue in the operating environment:
Issue with DataSource JNDI configuration. Test SQL string is missing or wrongly configured. The sample entry for test connection SQL is <check-valid-connection-sql>select 1</check-valid-connection-sql>.


Resolution



Perform the following local-change:
Include the check-valid-connection-sql string in the DS JNDI configuration.

Published January 12, 2017 - Updated October 8, 2020

Was this useful?

0% 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?

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