Question
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Segue Technologies Inc
US
Last activity: 25 Sep 2019 8:49 EDT
Pega 8.3 Deployment Errors
Hello,
I've been working on setting up a test/dev Pega 8.3 instance within a Linux box (Tomcat w/ MSSQL) but been having some trouble with a successful deploy. Originally when I set up the instance, the web app failed to load. It would try resolving the server:port/prweb URL but would fail. After configuring a few things and restarting tomcat a few times, now I keep seeing a MSSQL deadlock error. But if you look at the logs, it displays the error but will continue on to show all logs which indicate it is running. I have attached the logs from today, please advise. I've been stuck on this for over a week and a half now. Thank you.
***Edited by Moderator: Lochan to tag SR***
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689951000/6edb6beb-cf8e-431c-9679-ef67ce5f3aba.jpg?itok=hzTHfrBw)
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689951000/6edb6beb-cf8e-431c-9679-ef67ce5f3aba.jpg?itok=hzTHfrBw)
Pegasystems Inc.
US
Looks like you are starting up too many services (not your fault) for this single node - that causes deadlocks. Suggest you start with this -DNodeType=WebUser,Backgroundprocessing,Stream,Search,Batch (normally set in setenv.sh file) first.
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Segue Technologies Inc
US
Kevin,
Thank you for the reply. I added the line you suggested in the setenv.sh file but I am still getting the deadlocks. Please see attached. Also this is what my current setenv.sh file looks like:
JAVA_OPTS="-Xms9000m -Xmx12000m"
-DNodeType=WebUser,Backgroundprocessing,Stream,Search,Batch
Still unable to bring up the webapp.
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689951000/6edb6beb-cf8e-431c-9679-ef67ce5f3aba.jpg?itok=hzTHfrBw)
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689951000/6edb6beb-cf8e-431c-9679-ef67ce5f3aba.jpg?itok=hzTHfrBw)
Pegasystems Inc.
US
Thanks for the new info! Can you attach your context.xml? I would like to see your datasource configuration.
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Segue Technologies Inc
US
See attached. I intentionally X'd out the password, just a FYI.
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689951000/6edb6beb-cf8e-431c-9679-ef67ce5f3aba.jpg?itok=hzTHfrBw)
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689951000/6edb6beb-cf8e-431c-9679-ef67ce5f3aba.jpg?itok=hzTHfrBw)
Pegasystems Inc.
US
please change maxTotal to maxActive and restart, if still issue persists, please create an SR wit Pega GCS, we will investigate further.
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Segue Technologies Inc
US
Kevin,
Same result. Created SR with Pega GCS (SR-D48497). Thanks.
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689951000/6edb6beb-cf8e-431c-9679-ef67ce5f3aba.jpg?itok=hzTHfrBw)
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689951000/6edb6beb-cf8e-431c-9679-ef67ce5f3aba.jpg?itok=hzTHfrBw)
Pegasystems Inc.
US
thanks Jeremy. One more thing, if you add the following datasource attribute to your context.xml:
connectionProperties="defaultTransactionIsolation=READ_COMMITTED"
Would that make a difference?
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Segue Technologies Inc
US
Kevin,
Is there a specific place I need to insert this attribute, for example can I add it after the last <Environment name /> attribute? Thanks.
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689951000/6edb6beb-cf8e-431c-9679-ef67ce5f3aba.jpg?itok=hzTHfrBw)
![](https://accounts.pega.com/sites/default/files/styles/user_image/public/1689951000/6edb6beb-cf8e-431c-9679-ef67ce5f3aba.jpg?itok=hzTHfrBw)
Pegasystems Inc.
US
Inside <Resource> element in context.xml, you can insert anywhere as an attribute (like maxActive).
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
![](/profiles/pega_profile/modules/pega_user_image/assets/user-icon.png)
Segue Technologies Inc
US
Thanks for clarifying. And add it exactly as shown:
connectionProperties="defaultTransactionIsolation=READ_COMMITTED"