"[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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.