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
Originally Published: 2017-06-13
Article Number
Applies To
RSA Version/Condition: 7.0+
Issue
ORA-01840: input value not long enough for date format
To reproduce,
- Click on Reviews and pick any review of type User Access and click Edit Definition.
- Navigate to the User Selection tab and click Include users with the following attributes.
- Select any attribute of type date and select between in the drop down.
- Enter any value for the days and press OK.
- The ORA-01840 error occurs:
Cause
Resolution
Workaround
- 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
- Export the review in an XML format and open it any text editor.
- Navigate to Admin > Import/Export > Export.
- Click Review Definition and pick the corresponding review definition.
- Find the following line in the file:
<rev:userSpec>users.DELETION_DATE is not null</rev:userSpec>
- 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>
- Save the exported xml file and import it back to the system by selecting the Object Overwrite option.
- Click on Admin > Import/Export > Import.
- Browse for the XML file and click Next
- Check the corresponding review definition and click Next.
- Select Overwrite Always and import the file.
- After importing the review definition, we will be able to see the filter criteria including the date type attribute.
