PH02154: JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION: ARRAY INDEX OUT OF RANGE: 255 RUNNING SELECT STATEMENT FROM BIGSQL 503

APAR status

• Closed as program error.

Error description

• Data type CHAR(255) generates an error in Bigsql 5.0.3
  The problem does not happen in 5.0.2
  db2 "select * from test_char255"
  SQL5115N  The command or statement was not executed because the
  following
  functionality is not supported in the current environment: "SQL
  statements
  only allowed on head node".  SQLSTATE=56038
  in the bigsql.log you see
  2018-08-24 11:10:35,615 ERROR
  com.ibm.biginsights.bigsql.dfsrw.reader.DfsBaseReader
  [Master-2-S:17.1001.1.0.0.23232] : [BSL-2-56d217bde] Exception
  raised by Reader at node: 2 Scan ID: S:17.1001.1.0.0.23232
  Table: bigsql.test_char255 Spark: false VORC: false VPQ: true
  VAVRO: false VTEXT: false VRCFILE: false VANALYZE: false
  Exception Label:
  UNMAPPED(java.lang.ArrayIndexOutOfBoundsException: Array index
  out of range: 255)
  java.lang.ArrayIndexOutOfBoundsException: Array index out of
  range: 255
          at java.util.Arrays.rangeCheck(Arrays.java:444)
          at java.util.Arrays.fill(Arrays.java:3352)
          at
  com.ibm.biginsights.bigsql.dfsrw.reader.parquet.DfsParquetRowBuf
  ferSerializer.serializeBatch(DfsParquetRowBufferSerializer.java:
  310)
          at
  com.ibm.biginsights.bigsql.dfsrw.reader.parquet.DfsParquetRowBuf
  ferSerializer.batch2Buffer(DfsParquetRowBufferSerializer.java:13
  2)
          at
  com.ibm.biginsights.bigsql.dfsrw.jaro.DfsBatchManager$BatchRunna
  ble.run(DfsBatchManager.java:65)
          at
  java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec
  utor.java:1160)
          at
  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
  cutor.java:635)
          at java.lang.Thread.run(Thread.java:785)
          at
  com.ibm.biginsights.bigsql.dfsrw.jaro.DfsBatch2BufferThread.run(
  DfsBatch2BufferThread.java:59)
  

Local fix

Problem summary

• See error description
  

Problem conclusion

• The problem is fixed in Version 5.0.4 and later fix packs.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• Unknown
  

Fix information

• Fixed component name

  IBM BIG SQL

• Fixed component ID

  5737E7400

Applicable component levels