Not able to create username while import

[rohanpandit]

Hi Team,

We are getting error while creating a user via  import Job. We are creating username  from Saviynt only while importing a user from Successfactor. We are getting validation error. Please check.

2024-05-09T17:15:09+05:30-ecm-worker-services.ImportSAvDataUserService-quartzScheduler_Worker-1-vn54c-ERROR-Error in saving user username:null :: employeeid : xxxx

2024-05-09T17:15:09+05:30-ecm-worker--null-vn54c--grails.validation.ValidationException: Validation Error(s) occurred during save():

2024-05-09T17:15:09+05:30-ecm-worker--null-vn54c--- Field error in object 'com.saviynt.ecm.identitywarehouse.domain.Users' on field 'username': rejected value [null]; codes [com.saviynt.ecm.identitywarehouse.domain.Users.username.nullable.error.com.saviynt.ecm.identitywarehouse.domain.Users.username,com.saviynt.ecm.identitywarehouse.domain.Users.username.nullable.error.username,com.saviynt.ecm.identitywarehouse.domain.Users.username.nullable.error.java.lang.String,com.saviynt.ecm.identitywarehouse.domain.Users.username.nullable.error,users.username.nullable.error.com.saviynt.ecm.identitywarehouse.domain.Users.username,users.username.nullable.error.username,users.username.nullable.error.java.lang.String,users.username.nullable.error,com.saviynt.ecm.identitywarehouse.domain.Users.username.nullable.com.saviynt.ecm.identitywarehouse.domain.Users.username,com.saviynt.ecm.identitywarehouse.domain.Users.username.nullable.username,com.saviynt.ecm.identitywarehouse.domain.Users.username.nullable.java.lang.String,com.saviynt.ecm.identitywarehouse.domain.Users.username.nullable,users.username.nullable.com.saviynt.ecm.identitywarehouse.domain.Users.username,users.username.nullable.username,users.username.nullable.java.lang.String,users.username.nullable,nullable.com.saviynt.ecm.identitywarehouse.domain.Users.username,nullable.username,nullable.java.lang.String,nullable]; arguments [User Name,Users]; default message [Property [{0}] of class [{1}] cannot be null]

[Raghu]

@rohanpandit  what is username you expecting may i know ? give some example please?

[rohanpandit]

@Raghu on the basis of first and lastname. PFB example.

[NM]

Is it like working some and failing for others?

[NM]

Hi @rohanpandit, is user first name and last name empty?

[rohanpandit]

@NM it's not empty. Attaching postman Screenshot.

[NM]

Can you share import job ss once.

[rohanpandit]

Attaching screenshot. @NM 

it's not working for all. If i import username from successfactor then it will work but this is not the usecase for us as username generated in successfactor is not correct.

Also this was working before, it is stopped working suddenly.

[Saathvik · Accepted solution]

@rohanpandit : You cannot generate username using the setting you have shared from Global Configuration -> Identity LifeCycle. This will come into picture for users created through Saviynt UI/API.

If you want to generate username as part of import then use inline preprocessor and map it to username. Because username is mandatory mapping as part of import so during import only you have to assign username either by directly mapping any of the attribute from target or generate using inline preprocessor logic and assign it to username column of saviynt. 

[rushikeshvartak]

• How are trying to create user ?

[rohanpandit]

@rushikeshvartak  via import Job.

[rushikeshvartak]

Username is mandatory attribute and you can't compute username during import sheet 

[flegare]

We actually had this requirement with one of our clients and were able to solve it without pre-processor.

Username generation rule:

Importing with basic configuration:

Source file

Import config:

Aside from that, other import mandatory fields were not checked:

Import result:

Inserted user.  Username matches the rule defined in Global configuration

Key part seems to be on systemUserName generation at import.  I tried the exact same import without the systemUserName generation config checked off and ended up with the same error as OP.

[rushikeshvartak]

Share logs in text file

[flegare]

Logs attached

[rushikeshvartak]

Looking like code issue. raise support ticket

"2024-08-06T14:49:18.573+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-31-lxrx5","DEBUG","Error occurred while checking CSV file: Cannot get property 'originalFilename' on null object"

[flegare]

I don't think I need to.  I simply wanted to point out that OP's requirement (generate userName at import time) is achievable, contrary to the answer that was accepted originally.  This worked in our original deployment on 23.10 as well as 24.4.