Question
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!
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.
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.
Pegasystems Inc.
US
Thanks for the new info! Can you attach your context.xml? I would like to see your datasource configuration.
Segue Technologies Inc
US
See attached. I intentionally X'd out the password, just a FYI.
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.
Segue Technologies Inc
US
Kevin,
Same result. Created SR with Pega GCS (SR-D48497). Thanks.
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?
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.
Pegasystems Inc.
US
Inside <Resource> element in context.xml, you can insert anywhere as an attribute (like maxActive).
Segue Technologies Inc
US
Thanks for clarifying. And add it exactly as shown:
connectionProperties="defaultTransactionIsolation=READ_COMMITTED"