APAR status
Closed as program error.
Error description
If a table is defined to use a custom storage handler using the "STORED BY" argument of the create table syntax, for example: CREATE TABLE testtab ( <columns> ) STORED BY '<java url for a customer storage handler>'; and then a query is executed against that table, the query may fail with an error like this for example: SQL5105N The statement failed because a Big SQL component encountered an error. Component receiving the error: "SCHEDULER". Component returning the error: "STORAGE HANDLER". Log entry identifier: "[SCL-0-2d8ad6a8e]". SQLSTATE=58040 In the bigsql scheduler log (bigsql-sched.log) you may see an error like: 2017-03-16 12:52:07,260 ERROR com.ibm.biginsights.bigsql.scheduler.server.StorageHandlerScanSt ate [pool-1-thread-6] : [SCL-0-2d8ad675a] [createScanSt\ ate] Error while getting Storage Handler splits for: <custom storage handler java url> java.io.IOException: Query cannot proceed as no predicates are pushed down. proceed as no predicates are pushed down.
Local fix
Problem summary
See error description.
Problem conclusion
The problem is fixed in Version 4.3 and later fix packs.
Temporary fix
Comments
APAR Information
APAR number
PI79485
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-04-05
Closed date
2017-04-07
Last modified date
2017-04-07
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
R430 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