Support Article

DB-NonexistentTable Exception with campaign using realtime event

SA-25315

Summary



At runtime several exceptions are appearing in the logs when campaigns received real-time events.

Error Messages



2016-07-04 02:34:10,644 [PegaWorkManager : 16] [ STANDARD] [ ] [ FPM:01.01] ( internal.access.DatabaseImpl) ERROR - There was a problem with the database when getting a list:
com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable <your schema name>.V_VIRTUALVIEW4 ExternalMKTData
From: (BAFBFFE0059FF549B63F75FD398C61F5D)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.figureOutSchema(TableInformationMapImpl.java:805)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:473)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:384)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:346)
at com.pega.pegarules.data.internal.access.ConditionListSpecificationImpl.generateSQL(ConditionListSpecificationImpl.java:408)
at com.pega.pegarules.data.internal.access.ConditionListSpecificationImpl.getQueryInserts(ConditionListSpecificationImpl.java:351)
at com.pega.pegarules.data.internal.access.PageListSpecificationImpl.getQueryInserts(PageListSpecificationImpl.java:143)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6093)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:5979)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:5942)
at com.pega.dsm.dnode.impl.core.PegaObjectBrowser.getResult(PegaObjectBrowser.java:61)
at com.pega.dsm.dnode.impl.core.PegaObjectBrowser.access$000(PegaObjectBrowser.java:25)
at com.pega.dsm.dnode.impl.core.PegaObjectBrowser$1.emit(PegaObjectBrowser.java:44)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.subscribe(DataObservableImpl.java:320)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl.subscribe(DataObservableImpl.java:52)
at com.pega.dsm.dnode.impl.dataset.database.DatabaseOperationsUtil.readBlob(DatabaseOperationsUtil.java:233)
at com.pega.dsm.dnode.impl.dataset.database.DatabaseBrowseByKeysOperation$2.executeBlobLogic(DatabaseBrowseByKeysOperation.java:87)
at com.pega.dsm.dnode.impl.dataset.database.DatabaseOperationsUtil$2.emit(DatabaseOperationsUtil.java:152)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.subscribe(DataObservableImpl.java:320)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl.subscribe(DataObservableImpl.java:52)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$2.emit(DataObservableImpl.java:147)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.subscribe(DataObservableImpl.java:320)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl.subscribe(DataObservableImpl.java:52)
at com.pega.dsm.dnode.impl.dataflow.CombineDataStageProcessor.onNext(CombineDataStageProcessor.java:59)
at com.pega.dsm.dnode.api.dataflow.DataFlowStageBatchProcessor.commitBatchInternal(DataFlowStageBatchProcessor.java:102)
at com.pega.dsm.dnode.api.dataflow.DataFlowStageBatchProcessor.onNext(DataFlowStageBatchProcessor.java:57)
at com.pega.dsm.dnode.api.dataflow.DataFlowStageBatchProcessor.onNext(DataFlowStageBatchProcessor.java:17)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageInputSubscriber.onNext(DataFlowStage.java:259)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageInputSubscriber.onNext(DataFlowStage.java:184)
at com.pega.dsm.dnode.api.dataflow.DataFlowExecutor$SynchronousDataFlowExecutor.doOnNext(DataFlowExecutor.java:333)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageOutputSubscriber.onNext(DataFlowStage.java:371)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageOutputSubscriber.onNext(DataFlowStage.java:341)
at com.pega.dsm.dnode.api.dataflow.DataFlowStageProcessor.yield(DataFlowStageProcessor.java:63)
at com.pegarules.generated.ddf.ra_action_eventdfp4_ba624c0cb4b0e2b3e836f438054da218$1$1.handlePair(ra_action_eventdfp4_ba624c0cb4b0e2b3e836f438054da218.java:97)
at com.pega.dsm.dnode.impl.dataflow.CombineDataStageProcessor$2.onCompleted(CombineDataStageProcessor.java:81)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.onCompleted(DataObservableImpl.java:304)
at com.pega.dsm.dnode.api.dataflow.DataFlowExecutor$SynchronousDataFlowExecutor.doOnCompleted(DataFlowExecutor.java:347)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageOutputSubscriber.onCompleted(DataFlowStage.java:414)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageInputSubscriber.onCompleted(DataFlowStage.java:302)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.onCompleted(DataObservableImpl.java:304)
at com.pega.dsm.dnode.impl.dataset.database.DatabaseOperationsUtil$2.emit(DatabaseOperationsUtil.java:159)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.subscribe(DataObservableImpl.java:320)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl.subscribe(DataObservableImpl.java:52)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$2.emit(DataObservableImpl.java:147)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.subscribe(DataObservableImpl.java:320)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl.subscribe(DataObservableImpl.java:52)
at com.pega.dsm.dnode.impl.dataflow.CombineDataStageProcessor.onNext(CombineDataStageProcessor.java:59)
at com.pega.dsm.dnode.api.dataflow.DataFlowStageBatchProcessor.commitBatchInternal(DataFlowStageBatchProcessor.java:102)
at com.pega.dsm.dnode.api.dataflow.DataFlowStageBatchProcessor.onNext(DataFlowStageBatchProcessor.java:57)
at com.pega.dsm.dnode.api.dataflow.DataFlowStageBatchProcessor.onNext(DataFlowStageBatchProcessor.java:17)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageInputSubscriber.onNext(DataFlowStage.java:259)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageInputSubscriber.onNext(DataFlowStage.java:184)
at com.pega.dsm.dnode.api.dataflow.DataFlowExecutor$SynchronousDataFlowExecutor.doOnNext(DataFlowExecutor.java:333)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageOutputSubscriber.onNext(DataFlowStage.java:371)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageOutputSubscriber.onNext(DataFlowStage.java:341)
at com.pega.dsm.dnode.api.dataflow.DataFlowStageProcessor.yield(DataFlowStageProcessor.java:63)
at com.pegarules.generated.ddf.ra_action_eventdfp4_ba624c0cb4b0e2b3e836f438054da218$3$1.handlePair(ra_action_eventdfp4_ba624c0cb4b0e2b3e836f438054da218.java:218)
at com.pega.dsm.dnode.impl.dataflow.CombineDataStageProcessor$2.onCompleted(CombineDataStageProcessor.java:81)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.onCompleted(DataObservableImpl.java:304)
at com.pega.dsm.dnode.api.dataflow.DataFlowExecutor$SynchronousDataFlowExecutor.doOnCompleted(DataFlowExecutor.java:347)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageOutputSubscriber.onCompleted(DataFlowStage.java:414)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageInputSubscriber.onCompleted(DataFlowStage.java:302)
at com.pega.dsm.dnode.api.dataflow.DataFlowExecutor$SynchronousDataFlowExecutor.doOnCompleted(DataFlowExecutor.java:347)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageOutputSubscriber.onCompleted(DataFlowStage.java:414)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageInputSubscriber.onCompleted(DataFlowStage.java:302)
at com.pega.dsm.dnode.api.dataflow.DataFlowExecutor$SynchronousDataFlowExecutor.doOnCompleted(DataFlowExecutor.java:347)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageOutputSubscriber.onCompleted(DataFlowStage.java:414)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageInputSubscriber.onCompleted(DataFlowStage.java:302)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.onCompleted(DataObservableImpl.java:304)
at com.pega.dsm.dnode.impl.dataset.database.DatabaseOperationsUtil$2.emit(DatabaseOperationsUtil.java:159)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.subscribe(DataObservableImpl.java:320)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl.subscribe(DataObservableImpl.java:52)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$2.emit(DataObservableImpl.java:147)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.subscribe(DataObservableImpl.java:320)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl.subscribe(DataObservableImpl.java:52)
at com.pega.dsm.dnode.impl.dataflow.CombineDataStageProcessor.onNext(CombineDataStageProcessor.java:59)
at com.pega.dsm.dnode.api.dataflow.DataFlowStageBatchProcessor.commitBatchInternal(DataFlowStageBatchProcessor.java:102)
at com.pega.dsm.dnode.api.dataflow.DataFlowStageBatchProcessor.onNext(DataFlowStageBatchProcessor.java:57)
at com.pega.dsm.dnode.api.dataflow.DataFlowStageBatchProcessor.onNext(DataFlowStageBatchProcessor.java:17)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageInputSubscriber.onNext(DataFlowStage.java:259)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageInputSubscriber.onNext(DataFlowStage.java:184)
at com.pega.dsm.dnode.api.dataflow.DataFlowExecutor$SynchronousDataFlowExecutor.doOnNext(DataFlowExecutor.java:333)
at com.pega.dsm.dnode.api.dataflow.DataFlowStage$StageOutputSubscriber.onNext(DataFlowStage.java:371)

Steps to Reproduce



Configure and run a multi-channel campaign with Real-time events and ensure that the following conditions are met:
  • The Strategy used by the campaign should contains segment filtering.
  • The segments used in the strategy should be a virtual segment.


Root Cause



The issue started to occur after a recent deployment to the system which also included the virtual Segments involved in the currently running realtime event Campaigns.

Resolution



1. Suspend the Realtime Event Campaign.
2. Checkout and Checkin the segment and run the virtual segment.
3. Reschedule the Realtime event Campaign.

Published July 6, 2016 - Updated August 23, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.