PI75675: ANALYZE IN BIGINSIGHTS 4.2 FAILS TO COMPLETE.

APAR status

• Closed as program error.

Error description

• Error message in the bigsql.log will be similar to:
  Caused by: java.lang.NumberFormatException: -8684192312299235117
      at
  com.google.common.primitives.UnsignedLongs.parseUnsignedLong(Uns
  ignedLongs.java:270)
      at
  com.google.common.primitives.UnsignedLong.valueOf(UnsignedLong.j
  ava:101)
      at
  com.google.common.primitives.UnsignedLong.valueOf(UnsignedLong.j
  ava:89)
      at
  com.ibm.biginsights.bigsql.stats.PartitionReader.read(PartitionR
  eader.java:115)
  The issue is due to the meta data created by previous analyze
  in V1 (successful or not) is not properly interpreted by a
  subsequent v2 analyze.
  

Local fix

• There is a fix in the latest 4.2 update, but in the meantime,
  there are two workarounds:
  (1) Delete the ._biginsights_stats directory for the table
  (or)
  (2) Run a full analyze on the table (need to specify the
  keyword FULL - default is incremental), which will remove the
  previous statistics and replace them.
  

Problem summary

• See error description.
  

Problem conclusion

• Fixed as a patch in the current 4.2 BigInsights Version.
  

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

• n/a
  

Fix information

• Fixed component name

  INFO BIGINSIGHT

• Fixed component ID

  5725C0900

Applicable component levels

• R420 PSY

     UP