SAP HANA account Deletion from ISC

Hi Folks,

We are trying to delete accounts on SAP HANA source, When the lifecycle state is set ISC deletes the account from SAilpoint and it doesn’t come in aggregation also, but when we check on the actual application the account is still there. DO anybody have any idea, how to fix this.

Hi @Amsingh1 ,

Quick question first: are you using the VA-based SAP HANA connector or the SaaS SAP HANA connector?

VA Based connector

Hi,

I’m having the same issue, the account deletion event appears, but on the next aggregation the account comes back and is not deleted from the database.

It returns through the SAP HANA connector as disabled and with its expiration date set to the same day it was deleted.

So Did you find any solution?

Not yet. I’m still trying to understand why it’s disabling the account instead of deleting it, since the operation is a delete.

Hi, the documentation for the SAP HANA connector says that it supports the delete operation, but in my case, when I perform a delete, it is actually disabling the account instead of deleting it. And the connector is VA‑based as well. Do you know why this might be happening?

@Amsingh1 , I saw you opened a support ticket to receive extra help on this issue. Please update us with the solution you end up finding together with support.

How are you triggering the deletion? Is it similar to the original poster and you are using lifecycle states? Or is there  a workflow involved?

Are you seeing this same issue pop up for any other sources?

Yes, it was with the lifecycle state as well. And this issue only happened with the SAP HANA connector,  the SAP Direct connector deleted the account during the operation.

Hi @Amsingh1. Did you find any solution?

Have you tried using the Delete Account API endpoint to see if the connector is behaving correctly when sent the delete request directly (without relying on the lifecycle state triggering it).
https://developer.sailpoint.com/docs/api/v2025/delete-account/

Hi, By anychance do you know if we can check what query being executed by the system on SAP HANA

Hi @Amsingh1. Did you find any solution?

Hi @AndrewFlye

I tested it and it didn’t work, but there is a note in the API documentation saying:
‘NOTE: You can only delete accounts from sources of the “DelimitedFile” type.’

Ah, yeah, good catch.

There are some potential configuration details for the SAP HANA connector that could create potential issues that you can double check.

You could check for permissions on the service account used (check the documentation here).

You might also want to check to make sure the additional parameters are setup properly for deletion as well (check documentation here)

Hi,

I’ve adjusted that part and the delete operation is now working.

‘To drop a user when the delete operation is performed, set the value of the endDateOnDelete parameter to false.’

<entry key="endDateOnDelete"> <br>  <value> <br>    <Boolean>false</Boolean> <br>  </value> <br></entry> 

Thank you very much for your help.

It should be placed under connector attributes in ISC right?