Collection aborts with 'java.lang.StringIndexOutOfBoundsException: String index out of range: -1' error in RSA Identity Governance & Lifecycle
Originally Published: 2015-11-10
Article Number
Applies To
RSA Version/Condition: 6.9.1, 7.0.x, 7.1.x, 7.2.x
Issue
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
Cause
EXAMPLE:
In the query below, the email address is manipulated by the SQL query used to collect its value as follows:
select FIRST_NAME, LAST_NAME, (SUBSTR(EMAIL,1,INSTR(EMAIL,'@')-1)) as SHORT_EMAIL from USERS
The INSTR function is used to return the position of a substring (SUBSTR) in a string. This query takes an email address and truncates everything after the '@' sign. For example, cblossom@mailinator.com would become cblossom. If there is a value in the email field that does not have the '@', the error will occur and the collection will fail. For example, an email address of cblossommailinator.com. would cause this failure.
Resolution
