CCB Running Slow Using The Demo Install after upgrade to 2.5.0.1.0 (Doc ID 2163523.1)

Last updated on SEPTEMBER 16, 2022

Applies to:

Symptoms

After importing the demo dmp file from the Customer Care and Billing (CCB) oracle database archive from oracle software delivery cloud (V78183-01 - exp_demo.dmp.gz), starting CCB 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 CCB 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 CCB (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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.