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 August 23, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.