Skip to content

ORA-00942: table or view does not exist #127

@hello-llc

Description

@hello-llc

2020-02-21 14:46:05,640 +1094 [main] (INFO) {MonitoringEventProducer} Reading source: _schema = |BMS_REPORT.|
2020-02-21 14:46:05,641 +1095 [main] (INFO) {MonitoringEventProducer} Monitoring Query: select scn from BMS_REPORT.sy$txlog where txn = ( select max(txn) from BMS_REPORT.sy$TESTPERSON )
2020-02-21 14:46:05,641 +1095 [main] (INFO) {DBStatistics} Registered DB statistics statistics mbean: com.linkedin.databus2:name=person,type=DBStatistics
2020-02-21 14:46:05,641 +1095 [main] (INFO) {SourceDBStatistics} Registered DB source statistics statistics mbean: com.linkedin.databus2:name=com.linkedin.events.example.person.Person,type=SourceDBStatistics
2020-02-21 14:46:05,641 +1095 [main] (INFO) {MonitoringEventProducer} Created dbMonitor.person:1 producer
2020-02-21 14:46:05,642 +1096 [main] (INFO) {DatabusRelayMain} done initializing producers
2020-02-21 14:46:05,662 +1116 [main] (INFO) {ServerContainer} Saving port number in /usr/local/databus/databus-master/build/databus2-example-relay-pkg/distributions/./containerPortNum_1526787823
2020-02-21 14:46:05,662 +1116 [main] (INFO) {ServerContainer} Serving container 1526787823 HTTP listener on port 11115
2020-02-21 14:46:05,663 +1117 [main] (INFO) {DatabusRelayMain} Starting. Producers are :{{"id":1,"name":"person"}=com.linkedin.databus2.producers.db.OracleEventProducer@702657cc}
2020-02-21 14:46:05,663 +1117 [main] (INFO) {DatabusRelayMain} starting db puller: person
2020-02-21 14:46:05,663 +1117 [main] (INFO) {OracleEventProducer_person} OracleEventProducer.start: sinceScn = -1restartScnOffset = 0
2020-02-21 14:46:05,663 +1117 [main] (INFO) {OracleEventProducer_person} attempting to read persistent event producer checkpoint
2020-02-21 14:46:05,663 +1117 [main] (INFO) {OracleEventProducer_person} Proposed sinceSCN = 0
2020-02-21 14:46:05,663 +1117 [main] (INFO) {OracleEventProducer_person} Starting EventProducerThread from SCN: 0
2020-02-21 14:46:05,666 +1120 [main] (INFO) {OracleEventProducer_person} person started.
2020-02-21 14:46:05,666 +1120 [main] (INFO) {DatabusRelayMain} db puller started: person
2020-02-21 14:46:05,667 +1121 [main] (INFO) {ServerContainer} Databus service started!
2020-02-21 14:46:05,667 +1121 [main] (INFO) {ServerContainer} waiting for shutdown request for container id: 1526787823
2020-02-21 14:46:06,151 +1605 [EventProducerThread_person] (INFO) {person} JDBC Version is: 11.2.0.1.0
2020-02-21 14:46:06,245 +1699 [EventProducerThread_person] (ERROR) {person} readEventsFromAllSources exception:ORA-00942: table or view does not exist

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

what's the matter?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions