Catalog request areas do not load after selecting

Document ID : KB000095925
Last Modified Date : 29/08/2018
Show Technical Document Details
Question:
Catalog service must be restarted to allow the request selection to load.
Answer:
1) Rename/back up ..\Service Catalog\view\webapps\usm\WEB-INF\applicationContext.xml
2) Update the following:
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> 
<property name="driverClassName" value="${DBSource.driver}" /> 
<property name="url" value="${DBSource.url}" /> 
<property name="username" value="${DBSource.username}" /> 
<property name="password" value="${DBSource.password}" /> 
<property name="logAbandoned" value="true" /> 
<property name="removeAbandoned" value="true" /> 
<property name="maxWait" value="1800000" /> 



<!-- 3 minutes --> 
</bean> 

To: 

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> 
<property name="driverClassName" value="${DBSource.driver}" /> 
<property name="url" value="${DBSource.url}" /> 
<property name="username" value="${DBSource.username}" /> 
<property name="password" value="${DBSource.password}" /> 
<property name="logAbandoned" value="false" /> 
<property name="removeAbandoned" value="true" /> 
<property name="maxWait" value="1800000" /> 

<property name ="maxActive" value ="100" /> 

<!-- 3 minutes --> 
</bean> 

3) Restart Catalog service
Additional Information:
Noticed DBCP Related Errors in the log 
Snippet of the error in the view.log 

Application exception overridden by rollback exception
Local Exception Stack: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Connection ConnectionID:2231 ClientConnectionId: de861844-486f-4815-a9b9-bca1ce8880c6 is closed.
Error Code: 0