SCO discovery resources fails with error "String index out of range: -50"
Applies to
- SnapCenter Plug-in for Oracle Database (SCO) 4.8
- SnapCenter Plug-in for Oracle Database 4.9
- SnapCenter Plug-in for Oracle Database 5.0
- SnapCenter Plug-in for Oracle Database 6.0
Issue
- SCO job Discovery resorces for host '<HOSTNAME>' fails with error:
PL-SCO-20025: Discovery of database instances failed with error: String index out of range: -50.
- Selecting Database from View of Ocacle Database on Resources screen shows
There is no match for your search or data is not available.

spl_<JOB_ID>.logreports error:
2024-10-04T00:36:25.0000917Z DEBUG Execution Monitor Thread [sudo /opt/NetApp/snapcenter/spl/bin/sc_command_executor oracle '""'] c.n.c.e.ShellResult - EXE-00001: Shell result [0:00:00.077] (Exit Value: 1):
stty: 'standard input': Inappropriate ioctl for device
2024-10-04T00:36:25.0000917Z DEBUG qtp1132937504-40 c.n.o.c.c.NonRootConfiguration - Login Banner Output : stty: 'standard input': Inappropriate ioctl for device
2024-10-04T00:36:25.0000920Z DEBUG qtp1132937504-40 c.n.c.l.MessageBundle - Loading resource bundle from oracle-core for com.netapp.oracle.logging.MsgKey
2024-10-04T00:36:25.0000923Z DEBUG qtp1132937504-40 c.n.o.c.s.d.DiscoveryService - Entering method findAllDatabaseInstances with the parameters Empty input.
2024-10-04T00:36:25.0000923Z DEBUG qtp1132937504-40 c.n.o.c.s.d.DiscoveryService - Completed method findAllDatabaseInstances with the return parameters Empty output.
2024-10-04T00:36:25.0000925Z DEBUG qtp1132937504-40 c.n.o.c.s.d.DiscoveryService - failed to complete method findAllDatabaseInstances with JVM free memory 1.7 GB and used memory 350.7 MB.
2024-10-04T00:36:25.0000926Z ERROR qtp1132937504-40 c.n.o.c.s.d.DiscoveryService - An exception thrown during the execution of method findAllDatabaseInstances and the exception message is String index out of range: -50.
java.lang.StringIndexOutOfBoundsException: String index out of range: -50