"[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 JULY 26, 2024
Applies to:
Oracle Data Integrator - Version 12.2.1.3.0 and laterOracle 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! |