CC&B Running Slow Using The Demo Install after upgrade to 2.5.0.1.0 (Doc ID 2163523.1)

Last updated on JULY 25, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.5.0.1.0 and later
Information in this document applies to any platform.

Symptoms


After importing the demo dmp file from the CC&B oracle database archive from oracle software delivery cloud (V78183-01 - exp_demo.dmp.gz), starting CC&B and any navigation in the application has become significantly slower. For example, going to Control Central > Account Information and Control Central > Customer Information takes about 35 secs to load the page. It also takes 20-25 minutes for the application to start when the issue occurs (when using hibernate.properties). It only takes about 3 minutes for application to start when using weblogic.
As a workaround, switching from hibernate.properties to weblogic by logging into weblogic console, services > data sources > new jdbc data source and modifying hibernate.properties and the installation to use weblogic instead of hibernate.properties seems to resolve the issue.

This issue did not occur in CC&B 2.3.1, where a different issue where sessions were not closing can occur. However, no performance issues were noticed on this version.

If you are using sql developer, you may notice that sessions stay in the database after a user logs out in previous versions of CC&B (2.3.1), but this is not the case for ccb 2.5.0.1.0, where the session is disconnected after 1-2 minutes.

Changes

 STEPS TO REPRODUCE
-----------------------
The issue can be reproduced at will with the following steps on ccb 2.5.0.1.0 :
1. download the CC&B oracle database archive from oracle software delivery cloud (V78183-01 - exp_demo.dmp.gz) and import data into database of CCB 2.5.0.1.0 instance
2. After issue occurs, log into weblogic console, go to services > data sources > new jdbc data source. modify hibernate.properties, run initial setup, and restart the application. The issue should no longer occur

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms