Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Unable to set accountExpires AD attribute for Validthrough

BalajiEpari
New Contributor III
New Contributor III

Hi Team,

We are trying to map Active Directory attribute accountExpires to Validthrough. Below are the formats we tried. and No value gets mapped to account. but instead of Validthrough if i use any customproperty it is printing the value but year value is getting some 6 digit number.

VALIDTHROUGH::accountExpires#Winepoch-customDate

Error: 

BalajiEpari_0-1697205628398.png

Pls let us know, how to fix it.

8 REPLIES 8

SumathiSomala
All-Star
All-Star

@BalajiEpari did you try with below mapping?

validthrough::accountExpires#millisec

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

Hi Sumathi,

Yes, tried with millisec, in this case validthrough not populated anything.

Regards,

Balaji Epari

@BalajiEpari Could you please share the value present in target?

SumathiSomala_0-1697210216946.png

 

Asper the error screenshot It is not acceptable as it is not a valid date as data type variable . so it will only accept standard format of date.

Let me know if it helps.

 

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

Hi @SumathiSomala 

PFB Target Screenshot

BalajiEpari_0-1697216610104.png

if it does not accept the date format, is there any way to get this.

Regards,

Balaji Epari

 

 

@BalajiEpari  Try with some custom property mapping instead of valid through column and see if the value is updating.

CUSTOMPROPERTYx::accountExpires#Winepoch-customDate

 As the date is not valid format, Valid through only will accept if it is in proper date format . 

Let me know if it helps. 

If this reply answered your question, please Accept it As Solution to help others who may have a similar problem.

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

@BalajiEpari Are you still facing the issue?

 

 

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

If we map with any CP attribute. the value is printing. seems due to issue with year at target it causes issue.

BalajiEpari_0-1697454671429.png

 

@BalajiEpari : Since expiry year looks like future which is out of range than acceptable value for datetime column that's reason it is failing. In this case I would suggest to map it custompropertyxx where I believe it doesn't valid the year. 

CUSTOMPROPERTYxx::accountExpires#Winepoch-customDate


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