When Big Data SQL is Installed on a 19c Database Queries Fail with "KUP-11504: error from external driver: java.lang.InternalError"
(Doc ID 2777377.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Big Data SQL - Version 4.0 and laterLinux x86-64
Symptoms
In the images, examples and document that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.
When BDSQL is installed in a 19c database environment queries fail as below:
1. The error returned to the Oracle client is:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-11504: error from external driver: java.lang.InternalError
ORA-29400: data cartridge error
KUP-11504: error from external driver: java.lang.InternalError
2. This error occurs in the Big Data SQL EXTPROC process running on the database server. The error stack in the bigdata-log4j_<PID>.log file will be as follows:
ERROR sql.JXADReader: Error in fechInit
java.lang.InternalError
at org.apache.hadoop.io.compress.zlib.ZlibDecompressor.init(Native Method)
at org.apache.hadoop.io.compress.zlib.ZlibDecompressor.<init>(ZlibDecompressor.java:115)
at org.apache.hadoop.io.compress.GzipCodec$GzipZlibDecompressor.<init>(GzipCodec.java:200)
at org.apache.hadoop.io.compress.GzipCodec.createDecompressor(GzipCodec.java:159)
at org.apache.hadoop.io.compress.CodecPool.getDecompressor(CodecPool.java:183)
at oracle.hadoop.parquet.core.ParquetCodecFactory$ParquetBytesDecompressor.<init> (ParquetCodecFactory.java:158)
at oracle.hadoop.parquet.core.ParquetCodecFactory.getDecompressor(ParquetCodecFactory.java:101)
at oracle.hadoop.parquet.core.ParquetCodecFactory.decompress(ParquetCodecFactory.java:127)
...
at oracle.hadoop.parquet.hive.MapredParquetInputFormat.getRecordReader(MapredParquetInputFormat.java:117)
at oracle.hadoop.sql.parquet.ParquetInputRecordIteratorFactory.newIterator(ParquetInputRecordIteratorFactory.java:523)
at oracle.hadoop.sql.JXADDPReader.fetchInit(JXADDPReader.java:411)
at oracle.hadoop.sql.JXADReader$1.run(JXADReader.java:717)
at oracle.hadoop.sql.JXADReader$1.run(JXADReader.java:714)
at oracle.hadoop.sql.JXADBase.doAs(JXADBase.java:360)
at oracle.hadoop.sql.JXADReader.fetchInit(JXADReader.java:713)
java.lang.InternalError
at org.apache.hadoop.io.compress.zlib.ZlibDecompressor.init(Native Method)
at org.apache.hadoop.io.compress.zlib.ZlibDecompressor.<init>(ZlibDecompressor.java:115)
at org.apache.hadoop.io.compress.GzipCodec$GzipZlibDecompressor.<init>(GzipCodec.java:200)
at org.apache.hadoop.io.compress.GzipCodec.createDecompressor(GzipCodec.java:159)
at org.apache.hadoop.io.compress.CodecPool.getDecompressor(CodecPool.java:183)
at oracle.hadoop.parquet.core.ParquetCodecFactory$ParquetBytesDecompressor.<init> (ParquetCodecFactory.java:158)
at oracle.hadoop.parquet.core.ParquetCodecFactory.getDecompressor(ParquetCodecFactory.java:101)
at oracle.hadoop.parquet.core.ParquetCodecFactory.decompress(ParquetCodecFactory.java:127)
...
at oracle.hadoop.parquet.hive.MapredParquetInputFormat.getRecordReader(MapredParquetInputFormat.java:117)
at oracle.hadoop.sql.parquet.ParquetInputRecordIteratorFactory.newIterator(ParquetInputRecordIteratorFactory.java:523)
at oracle.hadoop.sql.JXADDPReader.fetchInit(JXADDPReader.java:411)
at oracle.hadoop.sql.JXADReader$1.run(JXADReader.java:717)
at oracle.hadoop.sql.JXADReader$1.run(JXADReader.java:714)
at oracle.hadoop.sql.JXADBase.doAs(JXADBase.java:360)
at oracle.hadoop.sql.JXADReader.fetchInit(JXADReader.java:713)
Note: This can happen when BDSQL is installed in a 19c database after upgrade to 19c.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |