Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

OOTB Box Connector is not working

JPMac
Regular Contributor
Regular Contributor

I am using the Box connector in OOTB to bring in three Entitlements: Groups/Folder/Files. However, I cannot import entitlement types other than Groups.

CUSTOM_CONFIG_JSON is set to:

{
"IMPORT_FILES_AND_FOLDERS": "YES",
"IMPORT_GROUPS": "YES"
}

I've also tried leaving CUSTOM_CONFIG_JSON blank from a previous forum, but that doesn't work either.

https://forums.saviynt.com/t5/identity-governance/folder-import-is-not-working-in-box-for-out-of-the...

How do I import Folder/Files?

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

Do you see any error in logs. Please share logs


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

JPMac
Regular Contributor
Regular Contributor

@rushikeshvartak 

From Job Details

JPMac_0-1711335140918.png

JPMac_1-1711335153305.png

 

From Log

2024-03-25T11:50:35+09:00-ecm-worker-provisoning.BoxProvisioningService-quartzScheduler_Worker-2-b5x7s-DEBUG-Folders And File import are done
2024-03-25T11:50:33+09:00-ecm-worker-provisoning.BoxProvisioningService-quartzScheduler_Worker-2-b5x7s-DEBUG-fetching and storing all enterprise users
2024-03-25T11:50:33+09:00-ecm-worker-provisoning.BoxProvisioningService-quartzScheduler_Worker-2-b5x7s-DEBUG-calling https://api.box.com/2.0/users?marker=aWQtMQ%3D%3D&limit=1000&fields=id,created_at,modified_at,name,l...
2024-03-25T11:50:34+09:00-ecm-worker-provisoning.BoxProvisioningService-quartzScheduler_Worker-2-b5x7s-DEBUG-Time Taken to get the response : 0.312
2024-03-25T11:50:34+09:00-ecm-worker-provisoning.BoxProvisioningService-quartzScheduler_Worker-2-b5x7s-DEBUG-Time Taken to process userList size- 4 : 0.014
2024-03-25T11:50:34+09:00-ecm-worker-provisoning.BoxProvisioningService-quartzScheduler_Worker-2-b5x7s-DEBUG-calling https://api.box.com/2.0/users?marker=eyJ0eXBlIjoiaWQiLCJkaXIiOiJuZXh0IiwidGFpbCI6IjMyMjE2MjgxNTkxIn0...
2024-03-25T11:50:34+09:00-ecm-worker-provisoning.BoxProvisioningService-quartzScheduler_Worker-2-b5x7s-DEBUG-Time Taken to get the response : 0.314
2024-03-25T11:50:34+09:00-ecm-worker-provisoning.BoxProvisioningService-quartzScheduler_Worker-2-b5x7s-DEBUG-Time Taken to process userList size- 0 : 0.003
2024-03-25T11:50:34+09:00-ecm-worker-provisoning.BoxProvisioningService-quartzScheduler_Worker-2-b5x7s-DEBUG-Time Taken to getAllEnterpriseUsers : 0.643
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-isImportSuccess: true
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Entered markStatusBasedOnThreshold
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Inside markAccountStatus
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Start setActiveAccountStatus
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Setting Batch Size from config = 500
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-params.statusColumn value ::: customproperty2
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Query to get accounts to be active:
2024-03-25T11:50:34+09:00-ecm-worker--null-b5x7s--select a.id from Accounts a WHERE a.endpointkey = 10 and a.customproperty2 in ('active')
2024-03-25T11:50:34+09:00-ecm-worker--null-b5x7s--and (a.status not in ('1','SUSPENDED FROM IMPORT SERVICE','PROCESSING') or a.status is null)
2024-03-25T11:50:34+09:00-ecm-worker--null-b5x7s--and a.name not like '%Deleted on%' and a.jobid = 280424
2024-03-25T11:50:34+09:00-ecm-worker--null-b5x7s--
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-No of Account whose status needs to be made active: 0
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-End setActiveAccountStatus
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Start setInactiveAccountStatus
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Setting Batch Size from config = 500
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Entered getNonActiveAccountsToBeDisabled
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Start appendAdditionalCondition
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-End appendAdditionalCondition
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Query to get accounts to be inactive: select acc.id from Accounts acc WHERE acc.endpointkey = 10 and (acc.customproperty2 not in ('active') or acc.customproperty2 is null) and (acc.status not in ('SUSPENDED FROM IMPORT SERVICE','2','PROCESSING') or acc.status is null) and acc.name not like '%Deleted on%' and acc.jobid=280424 and (accounttype='user' or accounttype is null)
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-No of Account whose status needs to be made inactive: 0
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Size of inactive accounts list: 0
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-End setInactiveAccountStatus
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Entered isThresholdExceeded method
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Start appendAdditionalCondition
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-End appendAdditionalCondition
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-accountsToBeDeletedList qry: select new Map(acc.id as id, acc.status as status) FROM Accounts acc WHERE acc.endpointkey = 10 and acc.jobid <> 280424 and acc.jobid <> 0 and acc.jobid is not null and (acc.status <> 'PROCESSING' or acc.status is null) and acc.name not like '%-Deleted on-%' and (accounttype='user' or accounttype is null)
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-totalAccountsToBeDeleted: 0
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Exiting isThresholdExceeded method
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-ThresholdExceeded: false
2024-03-25T11:50:34+09:00-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-2-b5x7s-DEBUG-Start takeAccountsNotInImportAction: params - [jobID:280424, importType:full, statusAndThresholdJSONMap:[accountThresholdValue:100, correlateInactiveAccounts:true, inactivateAccountsNotInFile:false, statusColumn:customproperty2, activeStatus:[active], deleteLinks:true], endpoint:box, additionalCondition:and (accounttype='user' or accounttype is null), isApiSuccess:true, jobHistoryMap:[Job-Type:full, Import-Type:access, Existing-Folders:0, Existing-Files:0, Existing-Accounts:6, Accounts-Activated:0, Accounts-Inactivated:0], statusColumn:customproperty2, activeStatus:[active], inactiveStatus:null, deleteLinks:true, correlateInactiveAccounts:true, inactivateAccountsNotInFile:false, setReferenceAccountNull:null, lockedStatusColumn:null, lockedStatusMapping:null, inactiveAccountSet:[], actionableAccountsList:[]]