Schema User Import Job Failed with java.lang.OutOfMemoryError

[LokeshSoundar]

Hi Team,

We have recently started the integration in the Saviynt Dev Tenant for the first time for our client. We are testing the users import via Schema user import job. We have just added one user in the csv file and we have added the SAV file with some transformation in to the File Directory. After running the user import job, we are getting below error.

","","","2023-08-10T08:54:04.169149278Z stdout F 2023-08-10 08:54:04,168 [quartzScheduler_Worker-3] ERROR listeners.ExceptionPrinterJobListener - Exception occured in job: Schema.SchemaUserJob"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169188078Z stdout F org.quartz.JobExecutionException: Java heap space [See nested exception: java.lang.OutOfMemoryError: Java heap space]"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169192778Z stdout F at org.quartz.core.JobRunShell.run(JobRunShell.java:199)"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169195778Z stdout F at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169197878Z stdout F Caused by: java.lang.OutOfMemoryError: Java heap space"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169200578Z stdout F at java.util.Arrays.copyOf(Arrays.java:3181)"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169202879Z stdout F at java.util.ArrayList.grow(ArrayList.java:267)"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169205679Z stdout F at java.util.ArrayList.ensureExplicitCapacity(ArrayList.java:241)"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169207879Z stdout F at java.util.ArrayList.ensureCapacityInternal(ArrayList.java:233)"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169210079Z stdout F at java.util.ArrayList.add(ArrayList.java:464)"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169212279Z stdout F at grails.converters.JSON.parse(JSON.java:283)"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169214479Z stdout F at com.saviynt.ecm.services.ImportSAvDataUserService.doImportDataPreprocessing(ImportSAvDataUserService.groovy:168)"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169216879Z stdout F at com.saviynt.ecm.services.ImportSAvDataUserService.importDataFromFile(ImportSAvDataUserService.groovy:728)"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169219179Z stdout F at com.saviynt.ecm.services.ImportSAvDataUserService.importDataFromFile(ImportSAvDataUserService.groovy:682)"
"2023-08-10T08:54:04.833+00:00","ecm-worker","","","","2023-08-10T08:54:04.169222379Z stdout F at SchemaUserJob$_execute_closure2_closure8.doCall(SchemaUserJob.groovy:213)"

Below is our CSV file,

Personal Reference,Full Name,Position,Reporting Unit,Department,Function,Category:Posn,Post,Payroll,Reporting Manager email,Reporting Manager Staff ID,User Email,Joining Date:People,Leaving Date:People,Current Absence Start Date,Current Absence End Date,Current Absence Group,Current Absence Type,Personal Email,Mobile Number,Forename1:People,Surname:People,Site,CostCode:Posn
100018,xxxxx xxxx,Team Manager,Customer Voice Dept | Swansea @Client Group House,Customer Loyalty Voice,Customer Loyalty,Employee,Team Manager,xxx Limited,xxxxxxxxxxxx@xxxxxx.co.uk,100017,xxxx.xxxxx@xxxxx-test.co.uk,12/08/2023,,,,,,xxxxxx.xxxxxx@abc.com,7777777777,xxxxx,xxxxx,London,2SGWQU

Attached the SAV File.

We can see from the logs that both SAV and Users file got picked by the job. Kindly help us to resolve this issue.

Thanks,

Lokesh

[This message has been edited by moderator to mask PII. Note: Please make sure to mask any PII info before posting in public forums. Thanks]

[Sivagami]

Hey,

Please share the SAV file sample used. Make sure there any confidential information is replaced with dummy values before sharing.

-Siva

[LokeshSoundar]

Hi Siva,

PFA the file.

Thanks,

Lokesh

[pmahalle]

Hi @LokeshSoundar ,

Make sure number of column and the order/sequence is same in your CSV and SAV files.

[LokeshSoundar]

Hi,

Yes. We have validated the same. It looks fine. I have restarted the instance and tried again as this is memory leak issue. But still it didnt fix the issue.

Thanks,

Lokesh

[dgandhi]

The error is related to memory, can you restart the instance and retry again and make sure enough memory is available in the server.

[LokeshSoundar]

Hi Devang,

We have restarted the instance and tried again, still the same issue. We are just trying to import only one user and this is a new instance and a new implementation. This is the first integration that we are setting up and doesn't have any other job running.

Thanks

Lokesh

[rushikeshvartak]

Can you column case same in input file & sav file.

EMPLOYEEID is not found in your input file. 

[LokeshSoundar]

Hi Rushikesh,

I have checked in my CSV and SAV file. I can see the employeeid in the first column. Personal Reference in my csv file is mapped to EmployeeID in the SAV file.

Thanks,

Lokesh

[LokeshSoundar]

Hi Team,

Please let me know if there is any update on this.

Since I tried restarting the instance and data mapping seems fine, may I know what is the next step here?

This is related to java memory issue. So please help resolve it from Saviynt end.

Thanks,

Lokesh

[rushikeshvartak]

Remove colon : from column name "Date:People"