000035261 - ORA-01840: Input value not long enough for date format error while setting the date type attribute filter in the review in RSA Identity Governance and Lifecycle

Document created by RSA Customer Support Employee on Jun 16, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035261
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0+
IssueThe following error occurs when attempting to add an attribute of type date in the user access review under the user selection tab:
ORA-01840: input value not long enough for date format

To reproduce,
  1. Click on Reviews and pick any review of type User Access and click Edit Definition
User-added image

  1. Navigate to the User Selection tab and click Include users with the following attributes.  
  2. Select any attribute of type date and select between in the drop down.
  3. Enter any value for the days and press OK.
  4. The ORA-01840 error occurs:
User-added image
CauseThis is a bug and reported in engineering ticket ACM-63517. 
ResolutionUpgrade to V7.0.1 P03 or V7.0.2 P02 to overcome this issue.
  1. Create a User Review with everything configured as desired, except the User Selection condition populated with the following advanced filter:
users."Deletion Date" is not null

User-added image

  1. Export the review in an XML format and open it any text editor.
  2. Navigate to Admin > Import/Export > Export.  
  3. Click Review Definition and pick the corresponding review definition.
User-added image 

  1. Find the following line in the file:
<rev:userSpec>users.DELETION_DATE is not null</rev:userSpec>

  1. Replace the string shown in step 5 with the following:
<rev:userSpec>users.DELETION_DATE between '${reviewCreationDate(-2,d)}' and '${reviewCreationDate(-1,d)}'</rev:userSpec>

User-added image

  1. Save the exported xml file and import it back to the system by selecting the Object Overwrite option.
    1. Click on Admin > Import/Export > Import
    2. Browse for the XML file and click Next
    3. Check the corresponding review definition and click Next.
    4. Select Overwrite Always and import the file. 
User-added image

User-added image

  1. After importing the review definition, we will be able to see the filter criteria including the date type attribute.
User-added image