Details

    • Type: Bug
    • Status: Resolved
    • Priority: P3 (Limited Impact)
    • Resolution: Fixed
    • Affects Version/s: 3.4.0
    • Fix Version/s: 3.5.0
    • Component/s: None
    • Labels:
    • Target Version/s:
    • Sprint:
      Trumbo's World
    • Doc Impact:
      No
    • Testing Status:
      Testing Completed
    • Testing Required Description:
      STF test if possible
    • Stage:
      Salesforce origin

      Description

      Reported via Ask StreamSets: NullPointerException with sub-query in Salesforce Origin

      NPE in Salesforce Origin with query:

      select Id, Name, (select NSB_Account__r.Pseudo_Natural_Key__c from Account_Roles__r) from Account where Name = 'NA'
      

      Stack trace:

      com.streamsets.datacollector.util.PipelineException: PREVIEW_0003 - Encountered error while previewing : java.lang.NullPointerException
      at com.streamsets.datacollector.execution.preview.sync.SyncPreviewer.start(SyncPreviewer.java:249)
      at com.streamsets.datacollector.execution.preview.async.AsyncPreviewer.lambda$start$0(AsyncPreviewer.java:95)
      at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:226)
      at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:33)
      at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:222)
      at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:226)
      at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:33)
      at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:222)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
      at com.streamsets.datacollector.metrics.MetricSafeScheduledExecutorService$MetricsTask.run(MetricSafeScheduledExecutorService.java:100)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      at java.lang.Thread.run(Thread.java:745)
      Caused by: java.lang.NullPointerException
      at com.streamsets.pipeline.lib.salesforce.SobjectRecordCreator.getAllReferences(SobjectRecordCreator.java:301)
      at com.streamsets.pipeline.lib.salesforce.SobjectRecordCreator.getReferencesFromFieldList(SobjectRecordCreator.java:203)
      at com.streamsets.pipeline.lib.salesforce.SobjectRecordCreator.getReferencesFromFieldList(SobjectRecordCreator.java:189)
      at com.streamsets.pipeline.lib.salesforce.SobjectRecordCreator.buildMetadataCacheFromQuery(SobjectRecordCreator.java:173)
      at com.streamsets.pipeline.stage.origin.salesforce.ForceSource.prepareQuery(ForceSource.java:401)
      at com.streamsets.pipeline.stage.origin.salesforce.ForceSource.soapProduce(ForceSource.java:656)
      at com.streamsets.pipeline.stage.origin.salesforce.ForceSource.produce(ForceSource.java:448)
      at com.streamsets.pipeline.api.base.configurablestage.DSource.produce(DSource.java:38)
      at com.streamsets.datacollector.runner.StageRuntime.lambda$execute$2(StageRuntime.java:283)
      at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:235)
      at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:298)
      at com.streamsets.datacollector.runner.StagePipe.process(StagePipe.java:244)
      at com.streamsets.datacollector.runner.preview.PreviewPipelineRunner.runPollSource(PreviewPipelineRunner.java:314)
      at com.streamsets.datacollector.runner.preview.PreviewPipelineRunner.run(PreviewPipelineRunner.java:217)
      at com.streamsets.datacollector.runner.Pipeline.run(Pipeline.java:538)
      at com.streamsets.datacollector.runner.preview.PreviewPipeline.run(PreviewPipeline.java:51)
      at com.streamsets.datacollector.execution.preview.sync.SyncPreviewer.start(SyncPreviewer.java:218)
      ... 14 more
      

        Attachments

          Activity

            People

            • Assignee:
              pat Pat Patterson
              Reporter:
              pat Pat Patterson
            • Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: