My Oracle Support Banner

"[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 MAY 03, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information 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:

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.

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!

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