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 number
PI75675
Reported component name
INFO BIGINSIGHT
Reported component ID
5725C0900
Reported release
420
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-01-30
Closed date
2017-04-11
Last modified date
2017-04-11
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"420","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 August 2020