AFX fails to create and/or update an Active Directory account with an 'Unparseable date' error in RSA Identity Governance & Lifecycle
Originally Published: 2019-07-18
Article Number
Applies To
RSA Version/Condition: 7.1.1
Issue
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.
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)
********************************************************************************
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)
********************************************************************************
Cause
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].
In the RSA Identity Governance & Lifecycle user interface, go to AFX > Connectors > [name of connector] > Edit > Capabilities > [name of capability].
