Troubleshooting
Problem
The pipeline is failing with following NullPointerException when attempting to access an Oracle table with a ROWID column type in the JDBC Multi-table consumer origin.
2024-01-09T02:01:11:234 [user:*test] [pipeline:jdbc_test] [stage:] ERROR ProductionPipelineRunnable - An exception occurred while running the pipeline, java.lang.NullPointerException
java.lang.NullPointerException: null
at com.streamsets.pipeline.lib.jdbc.JdbcUtil.resultToField(JdbcUtil.java:755) ~[?:?]
at com.streamsets.pipeline.lib.jdbc.JdbcUtil.resultSetToFields(JdbcUtil.java:909) ~[?:?]
at com.streamsets.pipeline.lib.jdbc.JdbcUtil.resultSetToFields(JdbcUtil.java:877) ~[?:?]
at com.streamsets.pipeline.stage.origin.jdbc.JdbcSource.processRow(JdbcSource.java:552) ~[?:?]
at com.streamsets.pipeline.stage.origin.jdbc.JdbcSource.produce(JdbcSource.java:389) ~[?:?]
at com.streamsets.pipeline.api.base.configurablestage.DSource.produce(DSource.java:38) ~[streamsets-datacollector-api-5.0.0.jar:?]
at com.streamsets.datacollector.runner.StageRuntime.lambda$execute$2(StageRuntime.java:284) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.pipeline.api.impl.CreateByRef.call(CreateByRef.java:40) ~[streamsets-datacollector-api-5.0.0.jar:?]
at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:232) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:299) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.datacollector.runner.StagePipe.process(StagePipe.java:209) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.processPipe(ProductionPipelineRunner.java:859) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.runPollSource(ProductionPipelineRunner.java:587) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.run(ProductionPipelineRunner.java:388) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.datacollector.runner.Pipeline.run(Pipeline.java:525) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.datacollector.execution.runner.common.ProductionPipeline.run(ProductionPipeline.java:100) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunnable.run(ProductionPipelineRunnable.java:63) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.startInternal(StandaloneRunner.java:746) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.start(StandaloneRunner.java:739) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.datacollector.execution.runner.common.AsyncRunner.lambda$start$3(AsyncRunner.java:150) ~[streamsets-datacollector-container-5.0.0.jar:?]
at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:214) ~[streamsets-datacollector-stagesupport-5.0.0.jar:?]
at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:44) ~[streamsets-datacollector-stagesupport-5.0.0.jar:?]
at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:25) ~[streamsets-datacollector-stagesupport-5.0.0.jar:?]
at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:210) ~[streamsets-datacollector-stagesupport-5.0.0.jar:?]
at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:214) ~[streamsets-datacollector-stagesupport-5.0.0.jar:?]
at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:44) ~[streamsets-datacollector-stagesupport-5.0.0.jar:?]
at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:25) ~[streamsets-datacollector-stagesupport-5.0.0.jar:?]
at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:210) ~[streamsets-datacollector-stagesupport-5.0.0.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_402]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_402]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_402]
at com.streamsets.datacollector.metrics.MetricSafeScheduledExecutorService$MetricsTask.run(MetricSafeScheduledExecutorService.java:88) ~[streamsets-datacollector-container-5.0.0.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_402]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_402]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_402]
Resolving The Problem
This is a known issue that has been resolved in version StreamSets Data Collector v5.4. The internal reference in JIRA is #COLLECTOR-2124.
Attaching the pipeline preview screenshots from fix version.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSM7CU","label":"IBM StreamSets Data Collector"},"ARM Category":[{"code":"","label":""}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
15 March 2025
UID
ibm17186191