IBM Support

"java.lang.StringIndexOutOfBoundsException" when running dbverify

Technote (troubleshooting)


Problem(Abstract)

"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.

Cross reference information
Segment Product Component Platform Version Edition
Commerce Sterling Selling and Fulfillment Suite Adapters

Historical Number

NFX8901

Product Alias/Synonym

Function Area


DBVerify, Extensions

Severity


Normal

Document information

More support for: Sterling Selling and Fulfillment Suite
Extensions

Software version: All

Operating system(s): Platform Independent

Reference #: 1556310

Modified date: 07 October 2011


Translate this page: