"[FMWGEN][Cassandra JDBC Driver][Cassandra]syntax error or access rule violation: base table or view not found" Error Received when Executing ODI 12c Mapping to Load to Apache Cassandra Database
(Doc ID 2500491.1)
Last updated on OCTOBER 04, 2022
Applies to:
Oracle Data Integrator - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
Within Oracle Data Integrator (ODI) 12c, a mapping has been configured to load data from Oracle (source) to Apache Cassandra (target).
When the mapping is executed, the following error is received:
oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLSyntaxErrorException: [FMWGEN][Cassandra JDBC Driver][Cassandra]syntax error or access rule violation: base table or view not found: <TABLE_NAME>
at oracle.odi.runtime.agent.execution.sql.SQLCommand.doInitializeStatement(SQLCommand.java:118)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.getStatement(SQLCommand.java:147)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.getBatchCommand(SQLCommand.java:389)
...
Caused by: java.sql.SQLSyntaxErrorException: [FMWGEN][Cassandra JDBC Driver][Cassandra]syntax error or access rule violation: base table or view not found: <TABLE_NAME>
at weblogic.jdbc.cassandrabase.ddcl.b(Unknown Source)
at weblogic.jdbc.cassandrabase.ddcl.a(Unknown Source)
at weblogic.jdbc.cassandrabase.ddck.b(Unknown Source)
...
... 27 more
Caused by: weblogic.cassandracloud.sql.ddai: syntax error or access rule violation: base table or view not found: <TABLE_NAME>
at weblogic.cassandracloud.sql.error.dda.a(Unknown Source)
at weblogic.cassandracloud.sql.ddbm.a(Unknown Source)
... 47 more
The issue can be reproduced at will with the following steps:
1. Create a Cassandra Data Server in the ODI Topology and test the connection > successful.
2. Create an Oracle Data Server in the ODI Topology and test the connection > successful.
3. Create the Cassandra Model and use the Reverse Engineering function to detect and filter the Cassandra data.
4. Create the Oracle Model and use the Reverse Engineering function to detect and filter the Cassandra data.
5. Create a mapping to load data from Oracle to Cassandra.
6. Try to load data from Oracle to Cassandra (by executing the mapping) and observe the above error.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |