User import issue - End date is lesser than the Start date

[GauravJain]

Hi - Getting this error in logs while importing users data using direct connection with LDAP for many user records:

"ERROR services.ImportSAvDataUserService - End date is lesser than the Start date specified in the csv."

When we verified few of the records, we found that those users have some value for "start date" but nothing for "end date". Still, Saviynt is giving above error.

What could be the cause of such issue? Please let me know if you require any further details.

Regards

Gaurav

[rushikeshvartak]

Do you mean blank ?, If you adding end date then start date is needed

[GauravJain]

Yes, end date is blank and start date have some value. still Saviynt is giving that error in user import.

Please let me know if you require any further information.

[GauravJain]

Hi @rushikeshvartak please ignore my earlier post.

It seems the start date and end date is same in few of the user records. still its giving error. Saviynt do not support same start and end date?

[rushikeshvartak]

yes it should be different

[GauravJain]

How to manage such records in Saviynt? Its very much possible to have same start and end date.

[rushikeshvartak]

Change end date to start date +1 using preprocessor

[GauravJain]

Ok but that will give an incorrect view in Saviynt w.r.t end date. Also, leavers process trigger will delay by a day. 

[GauravJain]

Can you share an example of pre-processor query to add timestamp in start and end date?

[rushikeshvartak]

Keep actual date in customproperty