000037738 - AFX fails to create and/or update an Active Directory account with an 'Unparseable date' error in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jul 22, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037738
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.1.1
 
Issue.AFX requests that create and/or update Active Directory accounts are failing. When viewing the request (Requests > Requests > [name of request]), AFX reports the following error seen in the request screen:
 

AFX reports this item failed with code [-1] and message: 'org.mule.api.transformer.TransformerMessagingException:
Unparseable date: "1567260660000" . Value of 'accountExipres' should be in 'MM/dd/yy HH:mm a' format. (java.lang.Exception).
Message payload is of type: String'. If available, another handler will be used to fulfill this item.


User-added image




The connector log file, /home/oracle/AFX/esb/logs/esb.AFX-CONN-Active_DirectoryConnector.log, has the following errors:
 
********************************************************************************
Message               : Unparseable date: "1567260660000" . Value of 'accountExipres' should be in 'MM/dd/yy HH:mm a' format. (java.lang.Exception)
Code                  : MULE_ERROR--2
--------------------------------------------------------------------------------
Exception stack is:
1. Unparseable date: "1567260660000" . Value of 'accountExipres' should be in 'MM/dd/yy HH:mm a' format. (java.lang.Exception)
  org.mule.transport.ldapx.transformers.MessageToLdapEntry:53 (null)
2. Unparseable date: "1567260660000" . Value of 'accountExipres' should be in 'MM/dd/yy HH:mm a' format. (java.lang.Exception) (org.mule.api.transformer.TransformerException)
  org.mule.transport.ldapx.transformers.MessageToLdapEntry:104 (http://www.mulesoft.org/docs/site/current3/apidocs/org/mule/api/transformer/TransformerException.html)
--------------------------------------------------------------------------------
Root Exception stack trace:
java.lang.Exception: Unparseable date: "1567260660000" . Value of 'accountExipres' should be in 'MM/dd/yy HH:mm a' format.
        at org.mule.transport.ldapx.transformers.MessageToLdapEntry.getLdapAttributeForName(MessageToLdapEntry.java:53)
        at org.mule.transport.ldapx.transformers.MessageToLdapEntry.transformMessage(MessageToLdapEntry.java:91)
        at org.mule.transformer.AbstractMessageTransformer.transform(AbstractMessageTransformer.java:141)
    + 3 more (set debug level logging or '-Dmule.verbose.exceptions=true' for everything)
********************************************************************************
CauseThe format of the accountExpires attribute that AFX is sending to Active Directory is in a format that AFX is unable to process. AFX expects the date of the accountExpires attribute to be in the following format:
 
MM/dd/yy HH:mm a
 


If the accountExpires attribute is in any other date format, AFX will fail. 






 




 
Resolution
Ensure that the accountExpires date format mapped in the Active Directory connector definition is in the required date format for both the Update an Account and Create an Account connector capabilities.The required date format is MM/dd/yy HH:mm a.  For example, when defining a date such as 'July 4, 2019', enter the value as  '07/04/19 00:00 AM'.

In the RSA Identity Governance & Lifecycle user interface, go to AFX > Connectors > [name of connector] > Edit > Capabilities > [name of capability]

 

 

 

User-added image



User-added image
 



 

Attachments

    Outcomes