Database connector missing accounts are not marked as suspended

[Subrahmanyam]

Hello team i have configured  accountnotinfileaction="Suspend" and "inactivateAccountsNotInFile": false , but  still, it is not suspending accounts missing from the feed. Is there anything additional to be configured?

[rushikeshvartak]

Please share account XML.

Below Should be Mapper in XML

<mapper description="Database Accounts and Account to Entitlement Import" accountnotinfileaction="suspend" deleteaccountentitlement="true" dateformat="date" systems="'Rushi_DB'">

& STATUS_THRESHOLD_CONFIG

{
"statusAndThresholdConfig": {
"deleteLinks": false,
"accountThresholdValue": 150,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false
}
}

[NM]

Hi @Subrahmanyam can you share account import json

[stalluri]

@Subrahmanyam 

Try This: accountnotinfileaction="suspend# AND (UPDATEDATE < DATE_SUB(NOW(),INTERVAL 2 DAY) or UPDATEDATE IS NULL)"

Make sure you remove incrementalcolumn from JSON.

Note

When incrementalcolumn is defined, for example, incrementalcolumn="updatedate", and a value is not specified for the STATUS_THRESHOLD_CONFIG parameter, the action specified in the accountnotinfileaction property works as intended. However, if STATUS_THRESHOLD_CONFIG is defined, then it takes precedence over the accountnotinfileaction value.