IBM Support

"java.lang.StringIndexOutOfBoundsException" when running dbverify

Troubleshooting


Problem

"java.lang.StringIndexOutOfBoundsException" when running dbverify

Symptom

"java.lang.StringIndexOutOfBoundsException"
Error Message
<Errors>
<Error ErrorCode="java.lang.StringIndexOutOfBoundsException"

<Attribute Name="ErrorCode" Value="java.lang.StringIndexOutOfBoundsException"/>
<Attribute Name="ErrorDescription" Value="java.lang.StringIndexOutOfBoundsException"/>
<Error ErrorCode="java.lang.StringIndexOutOfBoundsException"

<Stack>java.lang.StringIndexOutOfBoundsException: String index out of range: 1
at java.lang.StringBuffer.charAt(StringBuffer.java:283)
at com.yantra.tools.util.GenUtils.getVarName(GenUtils.java:51)
at com.yantra.tools.dbverify.DbVerifyCommandLine.handleColumns(DbVerifyCommandLine. java:432)
at com.yantra.tools.dbverify.DbVerifyCommandLine.getEntityDocument(DbVerifyCommandL ine.java:211)
at com.yantra.tools.dbverify.DbVerifyCommandLine.generateScripts(DbVerifyCommandLin e.java:88)
at com.yantra.tools.dbverify.DbVerifyCommandLine.processEntityRepository(DbVerifyCo mmandLine.java:73)
at com.yantra.tools.dbverify.DbVerifyCommandLine.main(DbVerifyCommandLine.java:52)< br /> </Stack>
</Error>
<Stack>com.yantra.yfc.util.YFCException
at com.yantra.tools.dbverify.DbVerifyCommandLine.generateScripts(DbVerifyCommandLin e.java:140)
at com.yantra.tools.dbverify.DbVerifyCommandLine.processEntityRepository(DbVerifyCo mmandLine.java:73)
at com.yantra.tools.dbverify.DbVerifyCommandLine.main(DbVerifyCommandLine.java:52)< br /> </Stack>
</Error>
</Errors>

Resolving The Problem

One sees this error, when the database contains extended columns whose name is less than 3 characters.
Check the database for all the extended columns whose name is less than 3 characters and drop all of them. Please note that all the extended columns should start with "EXTN_".
Sterling Extensibility/Customization Guides clearly talks about the naming convention for extended columns.

[{"Product":{"code":"SS6QYM","label":"Sterling Selling and Fulfillment Suite"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Extensions","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6QYM","label":"Sterling Selling and Fulfillment Suite"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Adapters","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

NFX8901

Product Synonym

[<p><b>]Function Area[</b><p>];DBVerify, Extensions;[<p><b>]Severity[</b><p>];Normal

Document Information

Modified date:
16 June 2018

UID

swg21556310