|Applies To||RSA Product Set: Identity Management and Governance|
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 6.9.1
|Issue||When running a collector, the following error message is seen:|
Error: Caused by java.sql.SQLException: java.lang.StringIndexOutOfBoundsException: String index out of range: -1
It is also possible to get this error when trying to insert null data into a string.
|Cause||This error is caused when a field requires string data, but there is none in the input field. It has also been seen when an input field does include string data, but a filter or query on the field returns null data. |
|Resolution||Fix the input data to not contain null data. If there is some kind of filter or query, verify that this will not return null data with the input data.|
|Notes||An example is when the field user.user_name should be an email address or UPN (such as email@example.com), but a query included a filter to collect/extract accounts, such as in the example below, where one of the input rows did not have an email address (specifically missing the @ character):|
The INSTR function is used to return the position of a substring in a string. The syntax of INSTR(user.user_name, '@')-1) does not find an @, so it returns null data.