Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry. Saviynt Copilot Icon
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Not able to convert CP value to Date while sending to AD in accountExpires

Go to solution
mbh_it
Regular Contributor II
Regular Contributor II

‎04/03/2024 11:33 AM - edited ‎04/03/2024 01:00 PM

Hi All,

I am trying to pass CP value as Date in AD account expires and it is giving error, I am not storing in enddate as I need to set enddate using modify JSON which can be used to check is Updated and trigger termination on last Hour (6 est)

Need expert guidance on how can I convert and pass same in AD?

"accountExpires": "${Date date = formatter.parse(user.customproperty49); date != null ? 10000*(date.getTime() + 11644473600000) : '0'}",

maheshbhoi_it_0-1712169136617.png

 

DB has date in following format: (UTC)

maheshbhoi_it_0-1712174418186.png

 

 

Thanks

Mahesh

 

 

Labels:
0 Kudos
6 REPLIES 6

Go to solution
rushikeshvartak
All-Star
All-Star

‎04/03/2024 07:45 PM

"accountExpires": "${user.customproperty49 != null ? (new Date(user.customproperty49).getTime() * 10000) + 116444736000000000 : 0}"


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Go to solution
mbh_it
Regular Contributor II
Regular Contributor II
In response to rushikeshvartak

‎04/04/2024 06:00 AM

Hi @rushikeshvartak 

 

I am getting following error

ldap.SaviyntGroovyLdapService - UpdateAccount - Binding map is..[ServiceAccountOwnerMap:[:],task:com.saviynt.ecm.task.ArsTasks : 10772,manager:mt@abcd.com,user:Alex.Azer@abcd.com,account:alex.azer,managerAccount:mt,]"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.900365385Z stdout F 2024-04-04 12:53:28,900 [quartzScheduler_Worker-9] DEBUG ldap.SaviyntGroovyLdapService - JSON to be used for Update Account-{"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.900392285Z stdout F "employeetype": "${user.employeeType}","
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.900396385Z stdout F "description": "${user.customproperty63}","
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.900400085Z stdout F "employeeID": "${user.employeeid}","
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.900403685Z stdout F "co": "${user.country}","
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.900406885Z stdout F "department": "${user.departmentname}","
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.900410385Z stdout F "accountExpires": "${user.customproperty49 != null ? (new Date(user.customproperty49).getTime() * 10000) + 116444736000000000 : 0}","
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.900413685Z stdout F "physicalDeliveryOfficeName": "${user.location}","
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.900416885Z stdout F "title": "${user.title}","
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.900419985Z stdout F "manager": "${managerAccount.comments}""
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.900423185Z stdout F }"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.900536685Z stdout F 2024-04-04 12:53:28,900 [quartzScheduler_Worker-9] DEBUG ldap.SaviyntGroovyLdapService - Binding Map-[ServiceAccountOwnerMap:[:],task:com.saviynt.ecm.task.ArsTasks : 10772,manager:mt@abcd.com,sAMAccountName:Alex.Azer,cnRDN:CN=Alex Azer,cn:Alex Azer,user:Alex.Azer@abcd.com,account:alex.azer,userPrincipalName:Alex.Azer@abcd.com,managerAccount:mt,out:java.io.PrintWriter@2b9e422,]"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919812934Z stdout F 2024-04-04 12:53:28,919 [quartzScheduler_Worker-9] ERROR ldap.SaviyntGroovyLdapService - Error Updating the Account from AD - null"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919837034Z stdout F java.lang.IllegalArgumentException"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919842934Z stdout F at java.util.Date.parse(Date.java:617)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919848334Z stdout F at java.util.Date.<init>(Date.java:274)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919855534Z stdout F at SimpleTemplateScript199.run(SimpleTemplateScript199.groovy:7)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919862434Z stdout F at com.saviynt.utility.TemplateUtilityService.getSimpleTemplateString(TemplateUtilityService.groovy:79)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919867434Z stdout F at com.saviynt.utility.TemplateUtilityService.getTemplateString(TemplateUtilityService.groovy:37)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919872634Z stdout F at com.saviynt.ldap.SaviyntGroovyLdapService$_updateAccountGLDAP_closure8.doCall(SaviyntGroovyLdapService.groovy:2551)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919875834Z stdout F at com.saviynt.ldap.SaviyntGroovyLdapService.updateAccountGLDAP(SaviyntGroovyLdapService.groovy:2180)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919879534Z stdout F at com.saviynt.ecm.services.ArsTaskService.updateAccountTarget(ArsTaskService.groovy:11272)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919882834Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService$_whenTaskTypeIsTwelveUpdateAccount_closure46.doCall(ArsTaskHelperService.groovy:2872)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919885934Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService.whenTaskTypeIsTwelveUpdateAccount(ArsTaskHelperService.groovy:2862)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919889034Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService$_completeAutoProvTasksUpgraded_closure1.doCall(ArsTaskHelperService.groovy:197)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919892234Z stdout F at com.saviynt.ecm.services.ArsTaskHelperService.completeAutoProvTasksUpgraded(ArsTaskHelperService.groovy:157)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919895334Z stdout F at MultipleProvisioningJob.execute(MultipleProvisioningJob.groovy:222)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919898734Z stdout F at org.quartz.core.JobRunShell.run(JobRunShell.java:199)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.919901834Z stdout F at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.92237464Z stdout F 2024-04-04 12:53:28,922 [quartzScheduler_Worker-9] DEBUG ldap.SaviyntGroovyLdapService - Exit updateAccountGLDAP"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.92239234Z stdout F 2024-04-04 12:53:28,922 [quartzScheduler_Worker-9] DEBUG services.ArsTaskService - Inside updateProvisioningTries.."
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.94240979Z stdout F 2024-04-04 12:53:28,942 [quartzScheduler_Worker-9] DEBUG services.ArsTaskService - Entering provisionAccesstoAccountSaviynt"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.94243659Z stdout F 2024-04-04 12:53:28,942 [quartzScheduler_Worker-9] DEBUG services.ArsTaskService - {alex.azer=[]}"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.94245979Z stdout F 2024-04-04 12:53:28,942 [quartzScheduler_Worker-9] DEBUG services.ArsTaskService - UPDATEACCOUNT"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.94247369Z stdout F 2024-04-04 12:53:28,942 [quartzScheduler_Worker-9] DEBUG services.ArsTaskService - accountID before merge = b9f0e2c3-eb39-4702-93db-138dbd977a1a"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.944906997Z stdout F 2024-04-04 12:53:28,944 [quartzScheduler_Worker-9] DEBUG services.ArsTaskService - accountID after merge = b9f0e2c3-eb39-4702-93db-138dbd977a1a"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.944931997Z stdout F 2024-04-04 12:53:28,944 [quartzScheduler_Worker-9] DEBUG services.ArsTaskService - completedFFRoleRequestAccessKeys for provisioning - []"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.9463603Z stdout F 2024-04-04 12:53:28,946 [quartzScheduler_Worker-9] DEBUG services.ArsTaskService - Config for ARSTASKCOMPNEWPWDcom.saviynt.ecm.utility.domain.EcmConfig : ARSTASKCOMPNEWPWD"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.947070802Z stdout F 2024-04-04 12:53:28,947 [quartzScheduler_Worker-9] DEBUG services.ArsTaskService - Task Complete Email Template For New Account Password = null"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.947081302Z stdout F 2024-04-04 12:53:28,947 [quartzScheduler_Worker-9] DEBUG services.ArsTaskService - start converting accTasksMap to endpointaccTasksMap"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.947092402Z stdout F 2024-04-04 12:53:28,947 [quartzScheduler_Worker-9] DEBUG services.ArsTaskService - finished converting accTasksMap to endpointaccTasksMap"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.952524716Z stdout F 2024-04-04 12:53:28,952 [quartzScheduler_Worker-9] DEBUG services.ArsTaskHelperService - In whenTaskTypeIsNineUpdateUser"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.952538716Z stdout F 2024-04-04 12:53:28,952 [quartzScheduler_Worker-9] DEBUG services.ArsTaskHelperService - Query Update User Tasks= "
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.952544316Z stdout F select rr from ArsTasks rr where rr.users is not null and rr.externalConnection is not null"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.952549616Z stdout F and rr.tasktype = 9 and (rr.endDate = null or rr.endDate > :ed)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.952555216Z stdout F and rr.id in (10772)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.952559816Z stdout F "
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.957409128Z stdout F 2024-04-04 12:53:28,957 [quartzScheduler_Worker-9] DEBUG services.ArsTaskHelperService - Found List of Update User Tasks[]"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.96239924Z stdout F 2024-04-04 12:53:28,962 [quartzScheduler_Worker-9] DEBUG services.ArsTaskHelperService - in whenTaskTypeIsThreeNewAccountAccess"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.96241224Z stdout F 2024-04-04 12:53:28,962 [quartzScheduler_Worker-9] DEBUG services.ArsTaskHelperService - Query New Account New Access Tasks= "
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.96241824Z stdout F select rr from ArsTasks rr where"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.962423241Z stdout F rr.accountKey is null and (rr.endDate = null or rr.endDate > :ed) and rr.tasktype in (3 , 1, 23 )"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.962427941Z stdout F and rr.id in (10772)"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.962432841Z stdout F "
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.966406551Z stdout F 2024-04-04 12:53:28,966 [quartzScheduler_Worker-9] DEBUG services.ArsTaskHelperService - Found List of Tasks[]"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.970462261Z stdout F 2024-04-04 12:53:28,970 [quartzScheduler_Worker-9] DEBUG services.ArsTaskHelperService - In whenTaskTypeIsTwo"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.970476261Z stdout F 2024-04-04 12:53:28,970 [quartzScheduler_Worker-9] DEBUG services.ArsTaskHelperService - Query Remove Access Tasks= "
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.970482061Z stdout F select rr from ArsTasks rr where"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.970486861Z stdout F rr.accountKey != null"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.970492161Z stdout F and rr.tasktype = 2 and rr.entitlement_valueKey != null"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.970496861Z stdout F and rr.id in (10772 )"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.970501461Z stdout F "
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.977511378Z stdout F 2024-04-04 12:53:28,977 [quartzScheduler_Worker-9] DEBUG services.ArsTaskHelperService - Query Remove Account Tasks= "
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.977539178Z stdout F select rr from ArsTasks rr where"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.977542778Z stdout F rr.accountKey != null"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.977546478Z stdout F and rr.tasktype = 2 and rr.entitlement_valueKey is null"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.977549578Z stdout F and rr.id in (10772 )"
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.977553878Z stdout F "
"2024-04-04T12:53:29.204+00:00","ecm-worker","","","","2024-04-04T12:53:28.984561396Z stdout F 2024-04-04 12:53:28,984 [quartzScheduler_Worker-9] DEBUG services.ArsTaskHelperService - In whenTaskTypeIsFiveChangePassword"

 

Thanks

Mahesh

0 Kudos

Go to solution
mbh_it
Regular Contributor II
Regular Contributor II
In response to mbh_it

‎04/04/2024 07:47 AM - edited ‎04/04/2024 07:48 AM

Hi @rushikeshvartak 

Thanks for your input, appreciate your help here,since it gave an error and while thinking got alternate solution.

I stored date to TermDate with preprocessor and pushed it, which worked as alternate solution.

 

Thanks

Mahesh

0 Kudos

Go to solution
rushikeshvartak
All-Star
All-Star
In response to mbh_it

‎04/04/2024 09:22 AM

"accountExpires": "${Date date = formatter.parse(user.termdate); date != null ? 10000*(date.getTime() + 11644473600000) : '0'}",

Is above is worked for you ?

Please share working JSON to benefit others 

 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.
0 Kudos

Go to solution
mbh_it
Regular Contributor II
Regular Contributor II

‎04/04/2024 10:33 AM

Hi @rushikeshvartak 

I will try this with a test user and let you know., 

Note: As stated earlier, I used TermDate which worked well as thats a date field and data got stored as Date.

Thanks

Mahesh

0 Kudos

Go to solution
rushikeshvartak
All-Star
All-Star
In response to mbh_it

‎04/04/2024 09:29 PM

Please share working json


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.
0 Kudos
Copyright © 2024 Khoros, LLC