ORA-00942: table or view does not exist
- Dominant language
- Java
- Stars
- 3.7k
- Forks
- 736
- PR merge metrics
- No merged PRs in 30d
Description
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?
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with the OracleEventProducer startup log and its Monitoring Query, especially the BMS_REPORT.sy$txlog and BMS_REPORT.sy$TESTPERSON references. Check the configured schema, table or view names, and database permissions; done means the producer starts without ORA-00942 and can read events. No source file or test is named in the issue.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100