Rules and Behaviors "java.lang.StringIndexOutOfBoundsException: String index out of range: -1" Error Saving Custom SQL Expression
(Doc ID 2530881.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Communications MetaSolv Solution - Version 6.3.0 and later
Information in this document applies to any platform.
MetaSolv Solution version 126.96.36.1992
Attempting to change or update the Custom SQL Expression for a Rules and Behavior in the GUI throws a "java.lang.StringIndexOutOfBoundsException: String index out of range: -1" error on the Rules and Behaviors > Rule Summary > Expression page and there is no way to save the changes.
Image of Error in GUI
1. Application Setup
2. Work Management Setup
3. Rules and Behaviors
4. Click an existing Rules and Behaviors
5. . Click the Edit link for the Expression section
6. Select the Custom SQL check-box and enter the SQL string below
SELECT COUNT(*) FROM SERV_REQ WHERE DOCUMENT_NUMBER = ?
7. Click Save and Close and the StringIndexOutOfBoundsException is thrown
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document