000035895 - Invalid date format error in RSA Identity Governance & Lifecycle Salesforce collections

Document created by RSA Customer Support Employee on Jan 11, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035895
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0.2
IssueWhen using a Salesforce Collector and collecting the LastLoginDate attribute, the attribute does not appear in the UI and the following admin error is seen:
Data Source: Salesforce ADC(ID=89): Found 1390 errors: Data Format Error in Account Record. Record ID=abc@rsa.com, Attribute=LAST_LOGIN_DATE, Value="2017-12-15T21:25:46.000+0000", Expected Data Type=DATE Problem: Invalid Date Format or Date Range Acceptable Date Range From: 01-Jan-0001 00:00:00 To: 31-Dec-9999 23:59:59

User-added image
CauseThe LastloginDate attribute was collected successfully from Salesforce, but it was not in date format and thus, was not shown on the UI after collection. 
ResolutionThis issue has been reported in ACM-79634 and is fixed in 7.1.0 which is expected to be released in February 2018.