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
- Navigate to Designer Studio > Application > Distribution > Import.
- Upload the ZIP files.
- 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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.