"Error Occurred: java.lang.IndexOutOfBoundsException: start 0, end 8192" while querying data from HDFS environment

"Error Occurred: java.lang.IndexOutOfBoundsException: start 0, end 8192" while querying data from HDFS environment

book

Article ID: KB0076235

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Big Data 6.3.0

Description

Below error might be encountered while querying data from HDFS environment 
Error Stack:
============
<CausedBy> TIBCO-BW-CORE-500051: Activity [HiveQueryNameNode2] fault.  
   <CausedBy> com.tibco.bw.palette.hadoop.runtime.exception.HadoopException: Error Occurred: java.lang.IndexOutOfBoundsException: start 0, end 8192, s.length() 8191
                at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:512)
============
The issue is more likely caused by the Hive returned result set containing the unicode character that occupies 1 to 4 bytes which resulted in the error to store the bytes to the buffer array. 
 

Issue/Introduction

For this error, Under Debug Configuration>Arguments>VM Arguments: Please append "-Dfile.encoding= ISO-8859-1" at the end of the existing value.

Environment

Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Big Data Version: 6.3.0 OS: All Supported Operating Systems

Resolution

The error can be resolved by forcing the character encoding of the Java runtime environment as ISO-8859-1. For this we can make changes at the following path. 

Run-->Debug Configuration-->Arguments-->VM Arguments: We appended "-Dfile.encoding= ISO-8859-1" at the end of the existing value.

An alternate way is to insert the property "-Dfile.encoding= ISO-8859-1" in appnode.tra and then restarting the appnode.