Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

What is the supported range for VALIDTHROUGH attribute in Accounts table?

rashmirudrappa
New Contributor III
New Contributor III

Hi,

What is the supported range for VALIDTHROUGH attribute in Accounts table?

In AD connector, under ACCOUNT_ATTRIBUTE we have mapped ,VALIDTHROUGH::accountExpires#millisec.

AD Account import job is failing when the accountExpires value is "9223372036854775807" . Is this the expected behavior? How do we resolve this

Thank you

Rashmi

9 REPLIES 9

sk
All-Star
All-Star

Try below mapping

 

VALIDTHROUGH::accountExpires#Winepoch-customDate

 


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

Darshanjain
Saviynt Employee
Saviynt Employee

Use the below Mapping , it should populate the value

VALIDTHROUGH::accountExpires#Winepoch-customDate

sandeepverma
Regular Contributor
Regular Contributor

Hi Darshan,

We tried the same mapping, but job still failed as per the below error

sandeepverma_0-1676435892815.png

Thank you,

Okay, then it might be environment specific, what is the data type for valid through column.

Would suggest you better raise a FD ticket so that support can check on it.

Hi Darshan,

The data type of valid through column is DateTime.

Thank you

Rashmi

Hi Rashmi, 

Just saw the screenshot, try with some custom property mapping instead of valid through column and see if the value is updating

Darshanjain_0-1676467992387.png

 

As the date is not valid, Valid through only will accept if its a proper date format , Hence the issue

Thanks

Darshan

Hi Darshan,

This is working when we map it to customproperty.  The value is Sep 14, 30828. Is this value not acceptable in validthrough attribute?

rashmirudrappa_0-1676468294555.png

Thanks

 

 

It is not acceptable as it is not a valid date as data type variable is date format so it will only accepts standard format of date

No it won't support because the year is not matching the date format(YYYY). If values is in supported date formats then it will be able to accept. Where as CP it is accepting because those are string fields but validthrough is date field.


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.