# Oracle Aggregation is timing out

**URL:** <https://developer.sailpoint.com/discuss/t/oracle-aggregation-is-timing-out/9917>\
**Category:** SHF Discussion and Questions\
**Tags:** apis, aggregation\
**Created:** [April 4, 2023, 7:39pm UTC](https://developer.sailpoint.com/discuss/t/oracle-aggregation-is-timing-out/9917 "2023-04-04T19:39:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ctiongson](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@ctiongson](https://developer.sailpoint.com/discuss/u/ctiongson)\
**Post date:** [April 4, 2023, 7:39pm UTC](https://developer.sailpoint.com/discuss/t/oracle-aggregation-is-timing-out/9917/1 "2023-04-04T19:39:24Z")

</div>

We had a custom oracle “Web Services” connector built for our environment. The API used was based off of sailpoint OOTB oracle solution.

API is going to:  
OracleURL//hcmRestApi

It has been working for us for 3 year now. In the last month it has been very intermittent. Today is the first time where I was not able to get a manual aggregation to complete as the connector keeps timing out. I have already rebooted the VA’s, cleared the ccg logs…

Sailpoint support is stating that the connection to oracle is timing out. Our network team does not see any network related issues.

Any ideas?

---

<div class="post-metadata">

**Author:** ![colin\_mckibben](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/colin_mckibben/32/37182_2.png) [@colin\_mckibben](https://developer.sailpoint.com/discuss/u/colin_mckibben)\
**Post date:** [April 4, 2023, 8:18pm UTC](https://developer.sailpoint.com/discuss/t/oracle-aggregation-is-timing-out/9917/2 "2023-04-04T20:18:24Z")

</div>

This sounds like an issue with Oracle’s service, not IdentityNow. Oracle might be experiencing latency issues at certain times, and their API is not responding in a reasonable time.

You can try increasing the “Connection Timeout” from the “Connection Settings” page:

 ![image](https://global.discourse-cdn.com/sailpoint/original/2X/b/bb6cb641a9cedb7f0fe149d7f4a4a64499361b06.png)

You might also look at paginating your requests to oracle to reduce the network load of an individual call.

---

<div class="post-metadata">

**Author:** ![ctiongson](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@ctiongson](https://developer.sailpoint.com/discuss/u/ctiongson)\
**Post date:** [July 12, 2023, 8:35pm UTC](https://developer.sailpoint.com/discuss/t/oracle-aggregation-is-timing-out/9917/3 "2023-07-12T20:35:11Z")

</div>

At one point we had 3 oracle engineers along with a lead expert services tech from sailpoint. No one could figure out why all of a sudden our aggregations were failing. The assumption was we now have too much data and oracle does not support API aggregations for employee data.

We ended up having to resign our authoritative source.  
using a delimited file source,  
then oracle spits out an employee data report  
which is now consumed by our IQserver which then passes it to identity now using a scheduled task and sailpoint java script.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [September 10, 2023, 8:35pm UTC](https://developer.sailpoint.com/discuss/t/oracle-aggregation-is-timing-out/9917/4 "2023-09-10T20:35:13Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.