java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist 09:14:03,773 INFO [stdout] (http-localhost/127.0.0.1:8080-1) 09:14:03,774 INFO [stdout] (http-localhost/127.0.0.1:8080-1) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) 09:14:03,774 INFO [stdout] (http-localhost/127.0.0.1:8080-1) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) 09:14:03,774 INFO [stdout] (http-localhost/127.0.0.1:8080-1) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) 09:14:03,774 INFO [stdout] (http-localhost/127.0.0.1:8080-1) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)

Terracotta | navatha | 4 years ago
  1. 0

    Error while initalizing the scheduler factory

    Terracotta | 4 years ago | navatha
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist 09:14:03,773 INFO [stdout] (http-localhost/127.0.0.1:8080-1) 09:14:03,774 INFO [stdout] (http-localhost/127.0.0.1:8080-1) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) 09:14:03,774 INFO [stdout] (http-localhost/127.0.0.1:8080-1) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) 09:14:03,774 INFO [stdout] (http-localhost/127.0.0.1:8080-1) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) 09:14:03,774 INFO [stdout] (http-localhost/127.0.0.1:8080-1) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
  2. 0

    databus relay log error -

    Stack Overflow | 1 year ago | Anushke Hewawaitharana
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist full log as below = =============== [root@HOSTA distributions]# cat /data/gradle/databus-master/build/databus2-example-relay-pkg/distributions/logs/relay.log 2015-08-30 11:25:47,873 +0 [main] (INFO) {ServerContainer} Using custom logging settings from file ./bin/../conf/relay_log4j.properties 2015-08-30 11:25:47,874 +1 [main] (INFO) {ServerContainer} Loading container config from properties file ./bin/../conf/relay_person.properties 2015-08-30 11:25:47,969 +96 [main] (INFO) {DbusEventBuffer} Setting allocation policy to DIRECT_MEMORY 2015-08-30 11:25:47,969 +96 [main] (INFO) {DbusEventBuffer} setting scn index size to 10240000 2015-08-30 11:25:47,973 +100 [main] (WARN) {DbusEventBuffer} Unable to set readBufferSize to 10240 as this has been deprecated! Use averageEventSize instead! 2015-08-30 11:25:47,989 +116 [main] (INFO) {HttpRelay} loading physical sources configs from: [sources-person.json] 2015-08-30 11:25:48,195 +322 [main] (INFO) {PhysicalSourceConfigBuilder} Generated Physical source config: name= 1 2015-08-30 11:25:48,198 +325 [main] (INFO) {DbusEventBuffer} Event buffer max size: 1024000000 2015-08-30 11:25:48,198 +325 [main] (WARN) {DbusEventBuffer} Ignoring staging event buffer size because it is deprecated: req size= 1048576 is larger than 20480 2015-08-30 11:25:48,198 +325 [main] (INFO) {DbusEventBuffer} Staging event buffer size: 20480 2015-08-30 11:25:48,198 +325 [main] (INFO) {DbusEventBuffer} Event buffer scn index size: 10240000 2015-08-30 11:25:48,198 +325 [main] (INFO) {DbusEventBuffer} Event buffer allocation policy: DIRECT_MEMORY 2015-08-30 11:25:48,198 +325 [main] (INFO) {DbusEventBuffer} Using queue policy: OVERWRITE_ON_WRITE 2015-08-30 11:25:48,198 +325 [main] (INFO) {DbusEventBuffer} Initial staging event buffer size: 20480 2015-08-30 11:25:48,199 +326 [main] (INFO) {RelayEventTraceOption} Relay event trace option: none 2015-08-30 11:25:48,199 +326 [main] (INFO) {RelayEventTraceOption} Relay event trace filename: databus_relay_event_trace 2015-08-30 11:25:48,199 +326 [main] (INFO) {RelayEventTraceOption} Relay event trace file append only: false 2015-08-30 11:25:48,199 +326 [main] (INFO) {RelayEventTraceOption} Relay event trace need file suffix: false 2015-08-30 11:25:48,216 +343 [main] (INFO) {ServerContainer} Using container id: 2146720857(from defaultId = 1407574493;hash=739146364) 2015-08-30 11:25:48,216 +343 [main] (INFO) {ServerContainer} Using http port:11115 2015-08-30 11:25:48,216 +343 [main] (INFO) {ServerContainer} Using containerBasedir: . 2015-08-30 11:25:48,216 +343 [main] (INFO) {ServerContainer} Using healthcheck path: admin 2015-08-30 11:25:48,216 +343 [main] (INFO) {JmxStaticConfigBuilder} Using JMX service: localhost:9999 2015-08-30 11:25:48,216 +343 [main] (INFO) {JmxStaticConfigBuilder} Using RMI registry: rmi://localhost:1099 2015-08-30 11:25:48,243 +370 [main] (INFO) {ServerContainer} TCP command interface configuration:{"enabled":false,"port":8180} 2015-08-30 11:25:48,249 +376 [main] (INFO) {EventLogWriter} Event Log Writer enabled: false 2015-08-30 11:25:48,249 +376 [main] (INFO) {EventLogWriter} Event Log Writer writeDir: /data/gradle/databus-master/build/databus2-example-relay-pkg/distributions/eventLog 2015-08-30 11:25:48,249 +376 [main] (INFO) {EventLogWriter} Event Log Writer writeSessionDir: /data/gradle/databus-master/build/databus2-example-relay-pkg/distributions/eventLog/session_1440914148249 2015-08-30 11:25:48,249 +376 [main] (INFO) {EventLogWriter} Event Log Writer encoding: BINARY 2015-08-30 11:25:48,249 +376 [main] (INFO) {EventLogWriter} Event Log Writer writeBatchSizeInBytes: 65536 2015-08-30 11:25:48,249 +376 [main] (INFO) {EventLogWriter} Event Log Writer blockOnWrite: false 2015-08-30 11:25:48,249 +376 [main] (INFO) {EventLogWriter} Event Log Writer individualFileMaxBytes: 512000000 2015-08-30 11:25:48,249 +376 [main] (INFO) {EventLogWriter} Event Log Writer maxFiles: 5 2015-08-30 11:25:48,249 +376 [main] (INFO) {EventLogWriter} Event Log Writer maxPendingWrites: 20 2015-08-30 11:25:48,250 +377 [main] (INFO) {EventLogWriter} Event Log Writer fsyncIntervalInMillis: 10000 2015-08-30 11:25:48,250 +377 [main] (INFO) {EventLogReader} Event Log Reader enabled : false 2015-08-30 11:25:48,251 +378 [main] (INFO) {HttpRelay} processing file: conf/sources-person.json 2015-08-30 11:25:48,270 +397 [main] (INFO) {HttpRelay} loading physical sources configs from: [sources-person.json] 2015-08-30 11:25:48,288 +415 [main] (INFO) {PhysicalSourceConfigBuilder} Generated Physical source config: name= 1 2015-08-30 11:25:48,289 +416 [main] (INFO) {DbusEventBuffer} Event buffer max size: 1024000000 2015-08-30 11:25:48,289 +416 [main] (INFO) {DbusEventBuffer} Staging event buffer size: 20480 2015-08-30 11:25:48,289 +416 [main] (INFO) {DbusEventBuffer} Event buffer scn index size: 10240000 2015-08-30 11:25:48,289 +416 [main] (INFO) {DbusEventBuffer} Event buffer allocation policy: DIRECT_MEMORY 2015-08-30 11:25:48,289 +416 [main] (INFO) {DbusEventBuffer} Using queue policy: OVERWRITE_ON_WRITE 2015-08-30 11:25:48,289 +416 [main] (INFO) {DbusEventBuffer} Initial staging event buffer size: 20480 2015-08-30 11:25:48,289 +416 [main] (INFO) {RelayEventTraceOption} Relay event trace option: none 2015-08-30 11:25:48,289 +416 [main] (INFO) {RelayEventTraceOption} Relay event trace filename: databus_relay_event_trace 2015-08-30 11:25:48,289 +416 [main] (INFO) {RelayEventTraceOption} Relay event trace file append only: false 2015-08-30 11:25:48,289 +416 [main] (INFO) {RelayEventTraceOption} Relay event trace need file suffix: false 2015-08-30 11:25:48,289 +416 [main] (INFO) {ServerContainer} Using http port:11115 2015-08-30 11:25:48,289 +416 [main] (INFO) {ServerContainer} Using containerBasedir: . 2015-08-30 11:25:48,289 +416 [main] (INFO) {ServerContainer} Using healthcheck path: admin 2015-08-30 11:25:48,290 +417 [main] (INFO) {JmxStaticConfigBuilder} Using JMX service: localhost:9999 2015-08-30 11:25:48,290 +417 [main] (INFO) {JmxStaticConfigBuilder} Using RMI registry: rmi://localhost:1099 2015-08-30 11:25:48,290 +417 [main] (INFO) {ServerContainer} TCP command interface configuration:{"enabled":false,"port":8180} 2015-08-30 11:25:48,291 +418 [main] (INFO) {EventLogWriter} Event Log Writer enabled: false 2015-08-30 11:25:48,291 +418 [main] (INFO) {EventLogWriter} Event Log Writer writeDir: /data/gradle/databus-master/build/databus2-example-relay-pkg/distributions/eventLog 2015-08-30 11:25:48,291 +418 [main] (INFO) {EventLogWriter} Event Log Writer writeSessionDir: /data/gradle/databus-master/build/databus2-example-relay-pkg/distributions/eventLog/session_1440914148249 2015-08-30 11:25:48,291 +418 [main] (INFO) {EventLogWriter} Event Log Writer encoding: BINARY 2015-08-30 11:25:48,291 +418 [main] (INFO) {EventLogWriter} Event Log Writer writeBatchSizeInBytes: 65536 2015-08-30 11:25:48,291 +418 [main] (INFO) {EventLogWriter} Event Log Writer blockOnWrite: false 2015-08-30 11:25:48,291 +418 [main] (INFO) {EventLogWriter} Event Log Writer individualFileMaxBytes: 512000000 2015-08-30 11:25:48,291 +418 [main] (INFO) {EventLogWriter} Event Log Writer maxFiles: 5 2015-08-30 11:25:48,291 +418 [main] (INFO) {EventLogWriter} Event Log Writer maxPendingWrites: 20 2015-08-30 11:25:48,291 +418 [main] (INFO) {EventLogWriter} Event Log Writer fsyncIntervalInMillis: 10000 2015-08-30 11:25:48,291 +418 [main] (INFO) {EventLogReader} Event Log Reader enabled : false 2015-08-30 11:25:48,299 +426 [main] (INFO) {FileSystemSchemaRegistryService} initializing schema registry 2015-08-30 11:25:48,299 +426 [main] (INFO) {FileSystemSchemaRegistryService} refreshing schema registry 2015-08-30 11:25:48,300 +427 [main] (INFO) {FileSystemVersionedSchemaSetProvider} Loading schema com.linkedin.events.example.person.Person:1 from file: schemas_registry/com.linkedin.events.example.person.Person.1.avsc 2015-08-30 11:25:48,338 +465 [main] (INFO) {VersionedSchemaSet} Registering md5 863447b394a7ad178861bd40a82e6459 --> name=com.linkedin.events.example.person.Person version=1 2015-08-30 11:25:48,339 +466 [main] (INFO) {FileSystemVersionedSchemaSetProvider} Loading schema com.linkedin.events.example.or_test.Person:1 from file: schemas_registry/com.linkedin.events.example.or_test.Person.1.avsc 2015-08-30 11:25:48,341 +468 [main] (INFO) {VersionedSchemaSet} Registering md5 62e07f98ad1ad290d05fff85cdaf9927 --> name=com.linkedin.events.example.or_test.Person version=1 2015-08-30 11:25:48,341 +468 [main] (INFO) {FileSystemSchemaRegistryService} schema registry refreshed 2015-08-30 11:25:48,341 +468 [main] (INFO) {FileSystemSchemaRegistryService} Starting schema refresh thread 2015-08-30 11:25:48,461 +588 [main] (INFO) {ServerContainer} Changing container config 2015-08-30 11:25:48,484 +611 [main] (INFO) {ServerContainer} healthcheck command root: admin 2015-08-30 11:25:48,486 +613 [main] (INFO) {DbusEventBufferMult} Creating new DbusEventBufferMult for 1 physical configurations 2015-08-30 11:25:48,487 +614 [main] (INFO) {DbusEventBuffer} DbusEventBuffer starting up with eventBufferSize = 1024000000, maxIndividualBufferSize = 512000000, maxIndexSize = 10240000, initReadBufferSize = 20480, maxEventSize=511999999, allocationPolicy = DIRECT_MEMORY, mmapDirectory = /data/gradle/databus-master/build/databus2-example-relay-pkg/distributions/mmappedBuffer,queuePolicy = OVERWRITE_ON_WRITE, eventTraceOption = none, needFileSuffix = false, assertLevel=NONE, bufRemovalWaitPeriod=86400, restoreBuffers=false 2015-08-30 11:25:49,058 +1185 [main] (INFO) {DbusEventBuffer} Allocated a total of 1024000000 bytes into 2 buffers 2015-08-30 11:25:49,059 +1186 [main] (INFO) {BufferPositionParser} Individual Buffer Size: 1e848000 2015-08-30 11:25:49,060 +1187 [main] (INFO) {BufferPositionParser} Num Buffers: 2 2015-08-30 11:25:49,060 +1187 [main] (INFO) {BufferPositionParser} Offset Length: 29 2015-08-30 11:25:49,060 +1187 [main] (INFO) {BufferPositionParser} buffer position for the EventBuffer: BufferPositionParser [_offsetMask=536870911, _indexMask=536870912, _genIdMask=9223372035781033984, _offsetShift=0, _indexShift=29, _genIdShift=30, _totalBufferSize=1024000000] 2015-08-30 11:25:49,068 +1195 [main] (INFO) {ScnIndex} ScnIndex configured with: maxElements = 640000 2015-08-30 11:25:49,069 +1196 [main] (INFO) {DbusEventBuffer} Trace Relay Option : none physicalPartition:person pSourceName:{"id":1,"name":"person"} 2015-08-30 11:25:49,074 +1201 [main] (INFO) {DbusEventBufferMult} Using- global event buffer config, the buffer size allocated is: 1024000000 2015-08-30 11:25:49,075 +1202 [main] (INFO) {DbusEventBufferMult} addBuffer for phSrc=name=person;part={"id":1,"name":"person"};uri=jdbc:oracle:thin:/@127.0.0.1:1521:databus;role=MASTER;rsKey=;#src=1; buf=1989184704 2015-08-30 11:25:49,076 +1203 [main] (INFO) {DbusEventBufferMult} logical source {"id":101,"name":"com.linkedin.events.example.person.Person"}{"id":0} mapped to physical source {"physicalPartition":{"id":1,"name":"person"}} 2015-08-30 11:25:49,077 +1204 [main] (INFO) {StatsCollectors-AggregatedDbusEventsStatisticsCollector} adding stats collector: person:1 -> DbusEventsStatisticsCollector [_totalStats=AbstractMonitoringMBean [_event={"ownerId": 2146720857, "timestampLastResetMs": 1440914149077, "timeSinceLastResetMs": 0, "dimension": "person_1.inbound.total", "numDataEvents": 0, "sizeDataEvents": 0, "sizeDataEventsPayload": 0, "numSysEvents": 0, "sizeSysEvents": 0, "numDataEventsFiltered": 0, "sizeDataEventsFiltered": 0, "sizeDataEventsPayloadFiltered": 0, "numPeers": 0, "minSeenWinScn": -1, "maxSeenWinScn": -1, "maxFilteredWinScn": 0, "numInvalidEvents": 0, "numErrHeader": 0, "numErrPayload": 0, "timestampCreated": 1440914149077, "timestampAccessed": -1, "timestampMinScnEvent": -1, "timestampMaxScnEvent": -1, "latencyEvent": 0, "minWinScn": 9223372036854775807, "maxWinScn": 0, "sinceWinScn": 9223372036854775807, "numFreeBytes": 0, "maxTimestampAccessed": -1, "minTimestampAccessed": -1, "maxTimeSpan": -1, "minTimeSpan": -1, "maxTimestampMaxScnEvent": -1, "minTimestampMaxScnEvent": -1, "timeLag": 0, "maxTimeLag": -1, "minTimeLag": -1}], _id=2146720857, _name=person:1.inbound, _sanitizedName=person_1.inbound, _enabled=true] 2015-08-30 11:25:49,078 +1205 [main] (INFO) {StatsCollectors-AggregatedDbusEventsStatisticsCollector} adding stats collector: person:1.inbound -> DbusEventsStatisticsCollector [_totalStats=AbstractMonitoringMBean [_event={"ownerId": 2146720857, "timestampLastResetMs": 1440914149077, "timeSinceLastResetMs": 0, "dimension": "person_1.inbound.total", "numDataEvents": 0, "sizeDataEvents": 0, "sizeDataEventsPayload": 0, "numSysEvents": 0, "sizeSysEvents": 0, "numDataEventsFiltered": 0, "sizeDataEventsFiltered": 0, "sizeDataEventsPayloadFiltered": 0, "numPeers": 0, "minSeenWinScn": -1, "maxSeenWinScn": -1, "maxFilteredWinScn": 0, "numInvalidEvents": 0, "numErrHeader": 0, "numErrPayload": 0, "timestampCreated": 1440914149077, "timestampAccessed": -1, "timestampMinScnEvent": -1, "timestampMaxScnEvent": -1, "latencyEvent": 0, "minWinScn": 9223372036854775807, "maxWinScn": 0, "sinceWinScn": 9223372036854775807, "numFreeBytes": 0, "maxTimestampAccessed": -1, "minTimestampAccessed": -1, "maxTimeSpan": -1, "minTimeSpan": -1, "maxTimestampMaxScnEvent": -1, "minTimestampMaxScnEvent": -1, "timeLag": 0, "maxTimeLag": -1, "minTimeLag": -1}], _id=2146720857, _name=person:1.inbound, _sanitizedName=person_1.inbound, _enabled=true] 2015-08-30 11:25:49,079 +1206 [main] (INFO) {StatsCollectors-AggregatedDbusEventsStatisticsCollector} adding stats collector: person:1 -> DbusEventsStatisticsCollector [_totalStats=AbstractMonitoringMBean [_event={"ownerId": 2146720857, "timestampLastResetMs": 1440914149078, "timeSinceLastResetMs": 0, "dimension": "person_1.outbound.total", "numDataEvents": 0, "sizeDataEvents": 0, "sizeDataEventsPayload": 0, "numSysEvents": 0, "sizeSysEvents": 0, "numDataEventsFiltered": 0, "sizeDataEventsFiltered": 0, "sizeDataEventsPayloadFiltered": 0, "numPeers": 0, "minSeenWinScn": -1, "maxSeenWinScn": -1, "maxFilteredWinScn": 0, "numInvalidEvents": 0, "numErrHeader": 0, "numErrPayload": 0, "timestampCreated": 1440914149078, "timestampAccessed": -1, "timestampMinScnEvent": -1, "timestampMaxScnEvent": -1, "latencyEvent": 0, "minWinScn": 9223372036854775807, "maxWinScn": 0, "sinceWinScn": 9223372036854775807, "numFreeBytes": 0, "maxTimestampAccessed": -1, "minTimestampAccessed": -1, "maxTimeSpan": -1, "minTimeSpan": -1, "maxTimestampMaxScnEvent": -1, "minTimestampMaxScnEvent": -1, "timeLag": 0, "maxTimeLag": -1, "minTimeLag": -1}], _id=2146720857, _name=person:1.outbound, _sanitizedName=person_1.outbound, _enabled=true] 2015-08-30 11:25:49,079 +1206 [main] (INFO) {StatsCollectors-AggregatedDbusEventsStatisticsCollector} adding stats collector: person:1.outbound -> DbusEventsStatisticsCollector [_totalStats=AbstractMonitoringMBean [_event={"ownerId": 2146720857, "timestampLastResetMs": 1440914149078, "timeSinceLastResetMs": 0, "dimension": "person_1.outbound.total", "numDataEvents": 0, "sizeDataEvents": 0, "sizeDataEventsPayload": 0, "numSysEvents": 0, "sizeSysEvents": 0, "numDataEventsFiltered": 0, "sizeDataEventsFiltered": 0, "sizeDataEventsPayloadFiltered": 0, "numPeers": 0, "minSeenWinScn": -1, "maxSeenWinScn": -1, "maxFilteredWinScn": 0, "numInvalidEvents": 0, "numErrHeader": 0, "numErrPayload": 0, "timestampCreated": 1440914149078, "timestampAccessed": -1, "timestampMinScnEvent": -1, "timestampMaxScnEvent": -1, "latencyEvent": 0, "minWinScn": 9223372036854775807, "maxWinScn": 0, "sinceWinScn": 9223372036854775807, "numFreeBytes": 0, "maxTimestampAccessed": -1, "minTimestampAccessed": -1, "maxTimeSpan": -1, "minTimeSpan": -1, "maxTimestampMaxScnEvent": -1, "minTimestampMaxScnEvent": -1, "timeLag": 0, "maxTimeLag": -1, "minTimeLag": -1}], _id=2146720857, _name=person:1.outbound, _sanitizedName=person_1.outbound, _enabled=true] 2015-08-30 11:25:49,086 +1213 [main] (INFO) {ServerContainer} Changing container config 2015-08-30 11:25:49,096 +1223 [main] (INFO) {RelayEventProducersRegistry} registering relay event producer for scheme mock: com.linkedin.databus2.producers.MockEventProducerServiceProvider@50a638b5 2015-08-30 11:25:49,097 +1224 [main] (INFO) {RelayEventProducersRegistry} registering relay event producer for scheme or: com.linkedin.databus2.producers.OpenReplicatorEventProducerServiceProvider@4f209819 2015-08-30 11:25:49,099 +1226 [main] (INFO) {DatabusRelayMain} initializing producers 2015-08-30 11:25:49,099 +1226 [main] (INFO) {MultiServerSequenceNumberHandler} creating sequence number handler for server name:{"id":1,"name":"person"} 2015-08-30 11:25:49,100 +1227 [main] (INFO) {FileMaxSCNHandler} creating file:/data/gradle/databus-master/build/databus2-example-relay-pkg/distributions/./maxScn/MaxSCN_person 2015-08-30 11:25:49,100 +1227 [main] (INFO) {FileMaxSCNHandler} Trying to read initial SCN from file: /data/gradle/databus-master/build/databus2-example-relay-pkg/distributions/./maxScn/MaxSCN_person 2015-08-30 11:25:49,100 +1227 [main] (INFO) {FileMaxSCNHandler} Starting from MAX SCN:0 2015-08-30 11:25:49,100 +1227 [main] (INFO) {DatabusRelayMain} Starting server container with maxScnReaderWriter:/data/gradle/databus-master/build/databus2-example-relay-pkg/distributions/./maxScn/MaxSCN_person:0 2015-08-30 11:25:49,102 +1229 [main] (INFO) {OracleEventProducerFactory} Loading schema for source id 101: {"type":"record","name":"Person_V1","namespace":"com.linkedin.events.example.person","fields":[{"name":"txn","type":["long","null"],"meta":"dbFieldName=TXN;dbFieldPosition=0;"},{"name":"key","type":["long","null"],"meta":"dbFieldName=KEY;dbFieldPosition=1;"},{"name":"firstName","type":["string","null"],"meta":"dbFieldName=FIRST_NAME;dbFieldPosition=2;"},{"name":"lastName","type":["string","null"],"meta":"dbFieldName=LAST_NAME;dbFieldPosition=3;"},{"name":"birthDate","type":["long","null"],"meta":"dbFieldName=BIRTH_DATE;dbFieldPosition=4;"},{"name":"deleted","type":["string","null"],"meta":"dbFieldName=DELETED;dbFieldPosition=5;"}],"meta":"dbFieldName=sy$person;pk=key;"} 2015-08-30 11:25:49,107 +1234 [main] (INFO) {OracleAvroGenericEventFactory} com.linkedin.events.example.person.Person_V1: using primary key override:key 2015-08-30 11:25:49,173 +1300 [main] (INFO) {OracleEventProducer_person} Registered source statistics mbean: com.linkedin.databus2:name=com.linkedin.events.example.person.Person,type=SourceStatistics 2015-08-30 11:25:49,175 +1302 [main] (INFO) {person} EventQuery=select /*+ first_rows LEADING(tx) / person.sync_core.getScn(tx.scn, tx.ora_rowscn) scn, tx.ts event_timestamp, src. from person.sy$person src, person.sy$txlog tx where src.txn=tx.txn and tx.scn > ? and tx.ora_rowscn > ? 2015-08-30 11:25:49,175 +1302 [main] (INFO) {person} Generated events query. source: com.linkedin.events.example.person.Person (id=101) ; eventQuery: select /*+ first_rows LEADING(tx) / person.sync_core.getScn(tx.scn, tx.ora_rowscn) scn, tx.ts event_timestamp, src. from person.sy$person src, person.sy$txlog tx where src.txn=tx.txn and tx.scn > ? and tx.ora_rowscn > ? 2015-08-30 11:25:49,175 +1302 [main] (INFO) {person} Generated Chunked Txn events query. source: com.linkedin.events.example.person.Person (id=101) ; chunkTxnEventQuery: SELECT scn, event_timestamp, src.* FROM person.sy$person src, ( SELECT /*+ first_rows LEADING(tx) cardinality(tx,1) / person.sync_core.getScn(tx.scn, tx.ora_rowscn) scn, tx.ts event_timestamp, tx.txn, row_number() OVER (ORDER BY TX.SCN) r FROM person.sy$txlog tx WHERE tx.scn > ? AND tx.ora_rowscn > ? AND tx.scn < 9999999999999999999999999999) t WHERE src.txn = t.txn AND r<= ? ORDER BY r 2015-08-30 11:25:49,175 +1302 [main] (INFO) {person} Generated Chunked Scn events query. source: com.linkedin.events.example.person.Person (id=101) ; chunkScnEventQuery: SELECT /+ first_rows LEADING(tx) / sync_core.getScn(tx.scn, tx.ora_rowscn) scn, tx.ts event_timestamp, src. FROM sy$person src, sy$txlog tx WHERE src.txn=tx.txn AND tx.scn > ? AND tx.ora_rowscn > ? AND tx.ora_rowscn <= ? 2015-08-30 11:25:49,176 +1303 [main] (INFO) {OracleEventProducerFactory} Created OracleEventProducer for config: name=person;part={"id":1,"name":"person"};uri=jdbc:oracle:thin:/@127.0.0.1:1521:databus;role=MASTER;rsKey=;#src=1 with slowSourceQueryThreshold = 2000 2015-08-30 11:25:49,178 +1305 [main] (INFO) {MonitoringEventProducer} Reading source: _schema = |person.| 2015-08-30 11:25:49,179 +1306 [main] (INFO) {MonitoringEventProducer} Monitoring Query: select scn from person.sy$txlog where txn = ( select max(txn) from person.sy$person ) 2015-08-30 11:25:49,179 +1306 [main] (INFO) {DBStatistics} Registered DB statistics statistics mbean: com.linkedin.databus2:name=person,type=DBStatistics 2015-08-30 11:25:49,180 +1307 [main] (INFO) {SourceDBStatistics} Registered DB source statistics statistics mbean: com.linkedin.databus2:name=com.linkedin.events.example.person.Person,type=SourceDBStatistics 2015-08-30 11:25:49,180 +1307 [main] (INFO) {MonitoringEventProducer} Created dbMonitor.person:1 producer 2015-08-30 11:25:49,181 +1308 [main] (INFO) {DatabusRelayMain} done initializing producers 2015-08-30 11:25:49,207 +1334 [main] (INFO) {ServerContainer} Saving port number in /data/gradle/databus-master/build/databus2-example-relay-pkg/distributions/./containerPortNum_2146720857 2015-08-30 11:25:49,207 +1334 [main] (INFO) {ServerContainer} Serving container 2146720857 HTTP listener on port 11115 2015-08-30 11:25:49,207 +1334 [main] (INFO) {DatabusRelayMain} Starting. Producers are :{{"id":1,"name":"person"}=com.linkedin.databus2.producers.db.OracleEventProducer@c730b35} 2015-08-30 11:25:49,207 +1334 [main] (INFO) {DatabusRelayMain} starting db puller: person 2015-08-30 11:25:49,207 +1334 [main] (INFO) {OracleEventProducer_person} OracleEventProducer.start: sinceScn = -1restartScnOffset = 0 2015-08-30 11:25:49,207 +1334 [main] (INFO) {OracleEventProducer_person} attempting to read persistent event producer checkpoint 2015-08-30 11:25:49,208 +1335 [main] (INFO) {OracleEventProducer_person} Proposed sinceSCN = 0 2015-08-30 11:25:49,208 +1335 [main] (INFO) {OracleEventProducer_person} Starting EventProducerThread from SCN: 0 2015-08-30 11:25:49,212 +1339 [main] (INFO) {OracleEventProducer_person} person started. 2015-08-30 11:25:49,212 +1339 [main] (INFO) {DatabusRelayMain} db puller started: person 2015-08-30 11:25:49,212 +1339 [main] (INFO) {ServerContainer} Databus service started! 2015-08-30 11:25:49,212 +1339 [main] (INFO) {ServerContainer} waiting for shutdown request for container id: 2146720857 2015-08-30 11:25:49,434 +1561 [EventProducerThread_person] (INFO) {person} JDBC Version is: 11.2.0.4.0 2015-08-30 11:25:49,534 +1661 [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 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
  3. 0

    databus relay log error -

    Stack Overflow | 1 year ago | Anushke Hewawaitharana
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist com.linkedin.databus2.core.DatabusException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at com.linkedin.databus2.producers.db.OracleTxlogEventReader.readEventsFromAllSources(OracleTxlogEventReader.java:418)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Fw: [sqoop-user] sqoop import shows ORA-00933: SQL command not properlyended error

    incubator-sqoop-user | 5 years ago | Arvind Prabhakar
    java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly > ended > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java: > 440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java: > 396)
  6. 0

    Script don't stop if I have an error

    Google Groups | 12 months ago | Enrico Briozzi
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression at > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      ORA-00942: table or view does not exist 09:14:03,773 INFO [stdout] (http-localhost/127.0.0.1:8080-1) 09:14:03,774 INFO [stdout] (http-localhost/127.0.0.1:8080-1) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) 09:14:03,774 INFO [stdout] (http-localhost/127.0.0.1:8080-1) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) 09:14:03,774 INFO [stdout] (http-localhost/127.0.0.1:8080-1) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) 09:14:03,774 INFO [stdout] (http-localhost/127.0.0.1:8080-1) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)

      at oracle.jdbc.driver.T4CTTIfun.doRPC()
    2. Oracle jdbc
      OracleStatement.executeMaybeDescribe
      1. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
      2. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
      3. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
      4. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
      5. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
      5 frames