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

Schema upload for Accounts/entitlements not working as expected

AJ23494
New Contributor II
New Contributor II
Hi experts , 

I tried uploading the schema for accounts/entitlements by referring to the below document . But on running the job No action is taking place . 

Could you please help ?

Saviynt Document link
 : https://saviynt.freshdesk.com/support/solutions/articles/43000431762-uploading-accounts-and-associat...



2023-01-13 12:26:23,807 [https-jsse-nio-443-exec-124] DEBUG log.LoggerService - Get 100 lines for debugLog-100.64.232.36.log
2023-01-13 12:26:31,997 [https-jsse-nio-443-exec-135] DEBUG domain.FlatViewJobcontrolController - Inside fireJobAction params = [triggername:schema_upload, triggergroup:GRAILS_JOBS, jobname:SchemaAccountJob, jobgroup:Schema, actn:6, job_name:, job_group:, controller:flatViewJobcontrol, action:fireJobAction]
2023-01-13 12:26:32,078 [https-jsse-nio-443-exec-135] DEBUG domain.FlatViewJobcontrolController - executing manual trigger...
2023-01-13 12:26:33,458 [quartzScheduler_Worker-4] DEBUG jobs.SchemaAccountJob - JOB STARTED SCHEMAACCOUNTJOB
2023-01-13 12:26:33,549 [quartzScheduler_Worker-4] DEBUG jobs.SchemaAccountJob - Schema Location - /datadrive/sharedappdrivepremium/saviynt/Import/SAV/
2023-01-13 12:26:33,549 [quartzScheduler_Worker-4] DEBUG jobs.SchemaAccountJob - Import Files Location - /datadrive/sharedappdrivepremium/saviynt/Import/Datafiles/
2023-01-13 12:26:33,549 [quartzScheduler_Worker-4] DEBUG jobs.SchemaAccountJob - Success Folder Location - /datadrive/sharedappdrivepremium/saviynt/Import/Success/
2023-01-13 12:26:33,549 [quartzScheduler_Worker-4] DEBUG jobs.SchemaAccountJob - Fail Folder Location - /datadrive/sharedappdrivepremium/saviynt/Import/Fail/
2023-01-13 12:26:33,808 [quartzScheduler_Worker-4] DEBUG services.SaviyntCommonUtilityService - Enter runNextTrigger
2023-01-13 12:26:33,808 [quartzScheduler_Worker-4] DEBUG services.SaviyntCommonUtilityService - Exit runNextTrigger
2023-01-13 12:26:38,221 [https-jsse-nio-443-exec-124] DEBUG domain.FlatViewJobcontrolController - ecmjobIdQuery .. select max(eij.JOBID) as 'JobId' from EcmImportJob eij where eij.TRIGGERNAME in (select qrt.TRIGGER_NAME from qrtz_triggers qrt) group by eij.TRIGGERNAME
2023-01-13 12:26:38,450 [https-jsse-nio-443-exec-124] DEBUG domain.FlatViewJobcontrolController - jobIdList size = 95
2023-01-13 12:26:38,477 [https-jsse-nio-443-exec-124] DEBUG domain.FlatViewJobcontrolController -
2023-01-13 12:26:38,477 [https-jsse-nio-443-exec-124] DEBUG domain.FlatViewJobcontrolController - jobAndTriggerQuery .. select e.SAVRESPONSE, e.JOBENDDATE as prev_fire_time, qt.job_name, qt.job_group, qt.trigger_name,qt.trigger_group,qt.next_fire_time, qct.CRON_EXPRESSION from qrtz_triggers qt left join ecmimportjob e on e.TRIGGERNAME=qt.TRIGGER_NAME left join qrtz_cron_triggers qct on qct.TRIGGER_NAME = qt.TRIGGER_NAME where e.JOBID 
 
------------------------------
File details 
--------------------------------
-------------------------
Account.sav
 
SystemName=CSVFileTesting
FileNameStartswith=Account
ENTITLEMENT_TYPE=Groups
DELETEACCOUNTENTITLEMENT=YES
OVERWRITE_USER_ASSIGNED=TRUE
ACCOUNT_NOT_IN_FILE_ACTION=SUSPEND
IGNOREFIRSTLINE=TRUE
FILEIMPORTDELIMETER=,
ENT_TYPE_NOT_AVAILABLE=CREATE
ENT_VAL_NOT_AVAILABLE=CREATE
ACCOUNTNAME,endpointname,Role,status,OWNERTYPE,OWNERUSER,OWNERRANK,OPERATION
 
 
 
Account.csv
 
ACCOUNTNAME,endpointname,Role,status,OWNERTYPE,OWNERUSER,OWNERRANK,OPERATION
00000076601,CSVFileTesting,IT Users,1,USER,adminaj,1,ADD
 

Thanks & Regards , 
Ankit Jindal 
1 REPLY 1

rushikeshvartak
All-Star
All-Star

It should be Accounts


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