linkedin / linkedin/databus

ORA-00942: table or view does not exist

Open
#127 0 comments 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.