File Upload Utility is throwing 500 Error

[rohit_wekhande]

When I am executing the file upload utility using Jar File - sailpoint-file-upload-utility-4.1.0 i.e. on 4.1.0 version, post successful authentication, I am getting 500 error as below.

Error Details.

Checking credentials...
Analyzing account file: C:\Intel\FileUploadUtil\242fe86cd5854235abd57e0e9e2d25c5-RohitTests.csv
Analyzing account file: 242fe86cd5854235abd57e0e9e2d25c5-RohitTests.csv
        File [242fe86cd5854235abd57e0e9e2d25c5-RohitTests.csv]: Error: HTTP Code[500] Message[] Body[{"detailCode":"500.0 Internal fault","trackingId":"203c35da5581492988c680812cae1dbf","messages":[{"locale":"en-US","localeOrigin":"DEFAULT","text":"An internal fault occurred."},{"locale":"und","localeOrigin":"REQUEST","text":"An internal fault occurred."}],"causes":[]}]
Complete.
------------------------------------------------------------------------------------------------------------
 Elapsed time:       3 seconds
 Files processed:    1
------------------------------------------------------------------------------------------------------------
 Success:            0
------------------------------------------------------------------------------------------------------------
 Error:              1
------------------------------------------------------------------------------------------------------------
 Skipped:            0
------------------------------------------------------------------------------------------------------------

Can someone tell me what could be the issue?

[sandilyabhamidipati]

@rohit_wekhande

When I am executing the file upload utility using Jar File - sailpoint-file-upload-utility-4.1.0 i.e. on 4.1.0 version, post successful authentication, I am getting 500 error as below.

hey Rohit, This may helpful.

500 (Internal Server Error) Aggregation Errors

A 500 Internal Server Error indicates an issue with the processing on the SailPoint Cloud side. If this occurs, it’s recommended to replicate the problem using the REST APIs and notify SailPoint Support.
check this link for File Upload Utility
Thanks,
Sandilya Bhamidipati.

[rohit_wekhande]

Already referred that.

Still its giving the same issue.

[gourab (Gourab Sadhukhan)]

Hi @rohit_wekhande
Review the Account schema and the headers of the CSV file. If any discrepancies are identified, make the necessary corrections.

[rohit_wekhande]

Hello,

The Schema Details are as follows.

Now, the File that I am utilizing to upload the user records are as follows.

242fe86cd5854235abd57e0e9e2d25c5-account-feed.csv (869 Bytes)

Note that as required in the file name, the source ID is also provided for the source. Refer

Based on the existing settings, the JDK i am using is Oracle JDK 11 which should be compatible as the documentations.

But still its throwing 500 error.

Regards,
Rohit Wekhande.

[rohit_wekhande]

Now, based on the documentations it says that if you are getting 500 response, then,

Now, the question is exactly which REST APIs we have to call for aggregating the data using CSV file for Flat File Connector based Application?

[gourab (Gourab Sadhukhan)]

Try this api: import-accounts | SailPoint Developer Community

[gourab (Gourab Sadhukhan)]

@rohit_wekhande

242fe86cd5854235abd57e0e9e2d25c5-account-feed.csv

Hi @rohit_wekhande ,
Try this file name once 242fe86cd5854235abd57e0e9e2d25c5-accountFeed.csv

[Shubhams_009 (Shubham Shende)]

Hi Rohit,

Have you tried running utility outside of C drive? Also add verbose -v flag.

[rohit_wekhande]

This API works as expected with attached CSV file.

{
    "success": true,
    "task": {
        "type": "QUARTZ",
        "id": "e10a64e2031d4950baa162961e1b9040",
        "name": "Cloud Account Aggregation",
        "description": "Aggregates from the specified application.",
        "parentName": null,
        "launcher": "rohit.wekhande",
        "created": 1733501811819,
        "launched": 1733501811822,
        "completed": null,
        "completionStatus": null,
        "messages": [],
        "returns": [
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_APPLICATIONS",
                "attributeName": "applications"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_TOTAL",
                "attributeName": "total"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_OPTIMIZED",
                "attributeName": "optimizedAggregation"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_IGNORED",
                "attributeName": "ignored"
            },
            {
                "displayLabel": "TASK_OUT_UNCHANGED_ACCOUNTS",
                "attributeName": "optimized"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_CREATED",
                "attributeName": "created"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_UPDATED",
                "attributeName": "updated"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_DELETED",
                "attributeName": "deleted"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_MANAGER_CHANGES",
                "attributeName": "managerChanges"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_BUSINESS_ROLE_CHANGES",
                "attributeName": "detectedRoleChanges"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_EXCEPTION_CHANGES",
                "attributeName": "exceptionChanges"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_POLICIES",
                "attributeName": "policies"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_POLICY_VIOLATIONS",
                "attributeName": "policyViolations"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_POLICY_NOTIFICATIONS",
                "attributeName": "policyNotifications"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_SCORES_CHANGED",
                "attributeName": "scoresChanged"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_SNAPSHOTS_CREATED",
                "attributeName": "snapshotsCreated"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_SCOPES_CREATED",
                "attributeName": "scopesCreated"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_SCOPES_CORRELATED",
                "attributeName": "scopesCorrelated"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_SCOPES_SELECTED",
                "attributeName": "scopesSelected"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_SCOPES_DORMANT",
                "attributeName": "scopesDormant"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_UNSCOPED_IDENTITIES",
                "attributeName": "unscopedIdentities"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_CERTIFICATIONS_CREATED",
                "attributeName": "certificationsCreated"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_CERTIFICATIONS_DELETED",
                "attributeName": "certificationsDeleted"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_APPLICATIONS_GENERATED",
                "attributeName": "applicationsGenerated"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_MANAGED_ATTRIBUTES_PROMOTED",
                "attributeName": "managedAttributesCreated"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_MANAGED_ATTRIBUTES_PROMOTED_BY_APP",
                "attributeName": "managedAttributesCreatedByApplication"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_IDENTITYENTITLEMENTS_CREATED",
                "attributeName": "identityEntitlementsCreated"
            },
            {
                "displayLabel": "TASK_OUT_ACCOUNT_AGGREGATION_GROUPS_CREATED",
                "attributeName": "groupsCreated"
            }
        ],
        "attributes": {
            "creatorRequestId": "89a59928cf5b4b499a47289514ed5cd4",
            "eventId": -1,
            "creatorStack": "diana",
            "appId": "242fe86cd5854235abd57e0e9e2d25c5",
            "optimizedAggregation": "enabled",
            "creatorSpanId": "a580838ea52c4acd9a06361f97b5ebfc"
        },
        "progress": null
    }
}

But, now the question remains that even if the file is correct, why the 500 exception is getting thrown?

[rohit_wekhande]

The utility jar file is hosted withing C drive only, hence, I am executing the utility inside C Drive.

Using Verbose, the Output is as follows.

------------------------------------------------------------------------------------------------------------
 SailPoint File Upload Utility
------------------------------------------------------------------------------------------------------------
 Version:            4.1.0
 Date:               2024-09-10 16:15 CST
 Docs:               https://developer.sailpoint.com/discuss/t/file-upload-utility/18181
------------------------------------------------------------------------------------------------------------
 URL:                https://partnerxxxx.api.identitynow-demo.com
 Client ID:          16f5bb57-7777-4112-bd06-7f49fb66d616
 Files:              C:\Intel\FileUploadUtil\242fe86cd5854235abd57e0e9e2d25c5-accountfeed-utf-quotesNoBOM.csv
 ObjectType:         account
 Optimization:       true
 Recursive:          false
 Extensions:         csv
 Simulation:         false
 Verbose:            true
 Timeout:            10000
------------------------------------------------------------------------------------------------------------
Checking credentials...
Analyzing account file: C:\Intel\FileUploadUtil\242fe86cd5854235abd57e0e9e2d25c5-accountfeed-utf-quotesNoBOM.csv
Analyzing account file: 242fe86cd5854235abd57e0e9e2d25c5-accountfeed-utf-quotesNoBOM.csv
        File [242fe86cd5854235abd57e0e9e2d25c5-accountfeed-utf-quotesNoBOM.csv]: detected with source ID reference [242fe86cd5854235abd57e0e9e2d25c5].
        File [242fe86cd5854235abd57e0e9e2d25c5-accountfeed-utf-quotesNoBOM.csv]: Submitting Account Aggregation: Source ID[242fe86cd5854235abd57e0e9e2d25c5], Disable Optimization[false]
        File [242fe86cd5854235abd57e0e9e2d25c5-accountfeed-utf-quotesNoBOM.csv]: Error: HTTP Code[500] Message[] Body[{"detailCode":"500.0 Internal fault","trackingId":"3ab3b9b02f28493ab6e06bf1905ea345","messages":[{"locale":"en-US","localeOrigin":"DEFAULT","text":"An internal fault occurred."},{"locale":"und","localeOrigin":"REQUEST","text":"An internal fault occurred."}],"causes":[]}]
Complete.
------------------------------------------------------------------------------------------------------------
 Elapsed time:       2 seconds
 Files processed:    1
------------------------------------------------------------------------------------------------------------
 Success:            0
------------------------------------------------------------------------------------------------------------
 Error:              1
        C:\Intel\FileUploadUtil\242fe86cd5854235abd57e0e9e2d25c5-accountfeed-utf-quotesNoBOM.csv
------------------------------------------------------------------------------------------------------------
 Skipped:            0
------------------------------------------------------------------------------------------------------------

[gourab (Gourab Sadhukhan)]

I found this :

SailPoint File Upload Utility 4.0.0

Hi @huu11 - Sorry that you’re having issues. For reference, the File Upload Utility has documentation around how to handle various error types in the Troubleshooting section. For 500 Internal Server Error you can see here: If you see a 500 Internal Server Error, this means there is a problem with the SailPoint Cloud processing itself. If you see this, it is best to reproduce the issue using the REST APIs and alert SailPoint Support. This particular issues doesn’t seem to be a problem with…

Try using “Personal Access Tokens” and it run it. Make sure to use sp:scopes:all

[rohit_wekhande]

Hello All,

This issue has been resolved. The issue was with PAT token only, hence, I re-created the PAT using my IDN - Account and used the same in utility.

It works as expected.

Thank You,

Regards,
Rohit Wekhande.