# Aggregate & correlate a single account attribute issue **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** aggregation, sailpoint-identity-security, apis\ **Created:** [September 5, 2024, 12:59pm UTC](https://developer.sailpoint.com/discuss/t/aggregate-correlate-a-single-account-attribute-issue/79393 "2024-09-05T12:59:06Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![abmcleann](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@abmcleann](https://developer.sailpoint.com/discuss/u/abmcleann)\ **Post date:** [September 5, 2024, 12:59pm UTC](https://developer.sailpoint.com/discuss/t/aggregate-correlate-a-single-account-attribute-issue/79393/1 "2024-09-05T12:59:06Z")
Hi, We currently have approximately 7,000 identities in our production SailPoint IDN environment. We have scheduled aggregations running every hour from our Authoritative Source, SAP. However, about 250 identities are in an error state because one of the required attributes for a transform is not being aggregated from the source. We have verified through Postman calls, using the same service account permissions and credentials as those configured in SAP, that the attribute exists in SAP and is accessible with the account permissions. Interestingly, when we manually go into an individual identity, open their SAP account, and click “aggregate account,” we see the attribute populated in the identity. Subsequently, if we click “process” identity, the identity exits the error state. Could you please advise on how we can resolve this issue so that the attribute is aggregated automatically during the scheduled aggregation process? Or if there is an API we can call to trigger identity aggregation for these error state identities? It is not working as expected and it is not realistic to perform these manual steps for 250+ identities. Is there a difference in the API used by Main account aggregation and the API used for individual account aggregation? I cannot see these in the Postman collection. I am seeking advice on how to fix this, I have opened a ticket but I haven’t received any solutions. Support requests SOAP responses, when we are using SFAPI. ---
**Author:** ![agutschow](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/agutschow/32/8543_2.png) [@agutschow](https://developer.sailpoint.com/discuss/u/agutschow)\ **Post date:** [September 5, 2024, 8:36pm UTC](https://developer.sailpoint.com/discuss/t/aggregate-correlate-a-single-account-attribute-issue/79393/2 "2024-09-05T20:36:56Z")
When processing aggregations by default SailPoint is looking to see if data has changed that is required it to be reprocessed in order to optimize the aggregation process. Sometimes you need to run an unoptimized aggregation to reprocess all of the data. You can do this using the API in a tool like Postman with this API to disable Optimization: [import-accounts | SailPoint Developer Community](https://developer.sailpoint.com/docs/api/v2024/import-accounts) You can also use the SailPoint plugin for VSCode: ![image](https://global.discourse-cdn.com/sailpoint/original/3X/d/b/dbd001ce4fb55cf500eb887cf56ef3793b1b3304.png) ---
**Author:** ![abmcleann](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@abmcleann](https://developer.sailpoint.com/discuss/u/abmcleann)\ **Post date:** [September 6, 2024, 9:17am UTC](https://developer.sailpoint.com/discuss/t/aggregate-correlate-a-single-account-attribute-issue/79393/3 "2024-09-06T09:17:02Z")
Thank you so much, this did fix the issue! Is there a way to run this unoptimized aggregation automatically? (on a schedule say every few weeks). We can enforce in policy this is done manually if need be. ---
**Author:** ![mohammedfavazhrb](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/mohammedfavazhrb/32/16892_2.png) [@mohammedfavazhrb](https://developer.sailpoint.com/discuss/u/mohammedfavazhrb)\ **Post date:** [September 6, 2024, 11:30am UTC](https://developer.sailpoint.com/discuss/t/aggregate-correlate-a-single-account-attribute-issue/79393/4 "2024-09-06T11:30:03Z")
Hi @abmcleann , Unoptimized aggregations can be done only via API. There is no option in UI to run that. You can use a powershell script to call this unoptimized aggregation API and save the script it in a windows machine (like iq service server of Active Directory) and schedule this powershell script via windows Task Scheduler to run daily. Thanks ---
**Author:** ![gourab](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/gourab/32/18650_2.png) [@gourab](https://developer.sailpoint.com/discuss/u/gourab)\ **Post date:** [September 6, 2024, 11:44am UTC](https://developer.sailpoint.com/discuss/t/aggregate-correlate-a-single-account-attribute-issue/79393/5 "2024-09-06T11:44:34Z")
Hi @abmcleann , You can use ISC workflows and use “Scheduled Trigger” and “http action” to do the api call for unoptimised aggregation.You will be able to schedule it in every few weeks as you wanted. [Triggers - SailPoint Identity Services](https://documentation.sailpoint.com/saas/help/workflows/workflow-triggers.html#scheduled-trigger) ---
**Author:** ![abmcleann](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@abmcleann](https://developer.sailpoint.com/discuss/u/abmcleann)\ **Post date:** [September 17, 2024, 12:05pm UTC](https://developer.sailpoint.com/discuss/t/aggregate-correlate-a-single-account-attribute-issue/79393/7 "2024-09-17T12:05:16Z")
Appreciate the advice, thank you! ---
**Author:** ![abmcleann](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@abmcleann](https://developer.sailpoint.com/discuss/u/abmcleann)\ **Post date:** [September 17, 2024, 12:05pm UTC](https://developer.sailpoint.com/discuss/t/aggregate-correlate-a-single-account-attribute-issue/79393/8 "2024-09-17T12:05:47Z")
Thank you very much, I will implement this 🙂 ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [November 16, 2024, 12:05pm UTC](https://developer.sailpoint.com/discuss/t/aggregate-correlate-a-single-account-attribute-issue/79393/9 "2024-11-16T12:05:58Z")
Closed on November 16, 2024, 12:05pm UTC This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.