ORA-00942: table or view does not exist
hello-llc opened this issue · 0 comments
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?