and more in a single search tool across platforms. Read the announcement here. |
02/14/2023 03:51 AM
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
02/14/2023 06:50 AM
Try below mapping
VALIDTHROUGH::accountExpires#Winepoch-customDate
02/14/2023 08:43 AM
Use the below Mapping , it should populate the value
VALIDTHROUGH::accountExpires#Winepoch-customDate
02/14/2023 08:39 PM
Hi Darshan,
We tried the same mapping, but job still failed as per the below error
Thank you,
02/15/2023 03:42 AM
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.
02/15/2023 05:11 AM
Hi Darshan,
The data type of valid through column is DateTime.
Thank you
Rashmi
02/15/2023 05:25 AM - edited 02/15/2023 05:34 AM
Hi Rashmi,
Just saw the screenshot, try with some custom property mapping instead of valid through column and see if the value is updating
As the date is not valid, Valid through only will accept if its a proper date format , Hence the issue
Thanks
Darshan
02/15/2023 05:39 AM
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?
Thanks
02/15/2023 05:59 AM
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
02/15/2023 06:26 AM
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.