# While deploying hippo cms.war, loading the data from db is taking too much time

**URL:** <https://community.bloomreach.com/t/while-deploying-hippo-cms-war-loading-the-data-from-db-is-taking-too-much-time/847>\
**Category:** Experience Manager (PaaS/OnPrem)\
**Created:** [February 26, 2019, 11:09am UTC](https://community.bloomreach.com/t/while-deploying-hippo-cms-war-loading-the-data-from-db-is-taking-too-much-time/847 "2019-02-26T11:09:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mehak20](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.bloomreach.com/mehak20/32/385_2.png) [@mehak20](https://community.bloomreach.com/u/mehak20)\
**Post date:** [February 26, 2019, 11:09am UTC](https://community.bloomreach.com/t/while-deploying-hippo-cms-war-loading-the-data-from-db-is-taking-too-much-time/847/1 "2019-02-26T11:09:06Z")

</div>

Kindly let me know why I am getting this error while reading data from oracle db.

Stack trace:  
java.net.SocketInputStream.socketRead0(Native Method)  
java.net.SocketInputStream.socketRead(SocketInputStream.java:116)  
java.net.SocketInputStream.read(SocketInputStream.java:171)  
java.net.SocketInputStream.read(SocketInputStream.java:141)  
oracle.net.ns.Packet.receive(Packet.java:308)  
oracle.net.ns.DataPacket.receive(DataPacket.java:106)  
oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:324)  
oracle.net.ns.NetInputStream.read(NetInputStream.java:268)  
oracle.net.ns.NetInputStream.read(NetInputStream.java:190)  
oracle.net.ns.NetInputStream.read(NetInputStream.java:107)  
oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)  
oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)  
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)  
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)  
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)  
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)  
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)  
oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1121)  
oracle.jdbc.driver.OracleResultSetImpl.close\_or\_fetch\_from\_next(OracleResultSetImpl.java:384)

- locked oracle.jdbc.driver.T4CConnection@33a2cfab  
oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:288)
- locked oracle.jdbc.driver.T4CConnection@33a2cfab  
org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)  
org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)

---

<div class="post-metadata">

**Author:** ![jasper.floor](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.bloomreach.com/jasper.floor/32/28_2.png) [@jasper.floor](https://community.bloomreach.com/u/jasper.floor)\
**Post date:** [February 26, 2019, 2:54pm UTC](https://community.bloomreach.com/t/while-deploying-hippo-cms-war-loading-the-data-from-db-is-taking-too-much-time/847/2 "2019-02-26T14:54:42Z")

</div>

Any logging on your database logs? When exactly is this occurring? I assume this is a timeout happening. My first guess would be to look at the database, but I don’t really have enough information to say. Maybe someone else has some insights.

---

<div class="post-metadata">

**Author:** ![woonsanko](https://avatars.discourse-cdn.com/v4/letter/w/b5a626/32.png) [@woonsanko](https://community.bloomreach.com/u/woonsanko)\
**Post date:** [February 27, 2019, 1:28am UTC](https://community.bloomreach.com/t/while-deploying-hippo-cms-war-loading-the-data-from-db-is-taking-too-much-time/847/3 "2019-02-27T01:28:25Z")

</div>

Hi,

Is it about taking too long time on startup due to lucene index rebuilding?

> [@](#):
>
> If the repository contains a lot of content, for example hundreds of thousands of documents, this can take several hours. [1]

Woonsan

[1] [Backup and Restore Strategy - Bloomreach Experience Manager (PaaS/Self-Hosted) - The Fast and Flexible Headless CMS](https://documentation.bloomreach.com/library/enterprise/installation-and-configuration/backup-and-restore-strategy.html)