- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
PutDatabaseRecord TableNotFoundException exception
- Labels:
-
Apache NiFi
Created 02-21-2024 03:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am trying to copy table rows from one oracle database to another oracle table. PutDatabaseRecord cannot find the second table. I checked many times that table exists. But it is still giving error. Does anybody know how to solve it?
PutDatabaseRecord[id=cb461cc1-018d-1000-21fe-ec8db1afeca1] Failed to put Records to database for FlowFile[filename=040d505a-1d6c-4f36-8a2b-38bcf577a059]. Routing to failure.: org.apache.nifi.processors.standard.db.TableNotFoundException: Table fsc_bank_dim_zz not found, ensure the Catalog, Schema, and/or Table Names match those in the database exactly
Created 04-03-2024 12:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the reply. I have found the answer myself. The table name must be all in capital letters. No need to add schema or catalog name.
Created 02-21-2024 06:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ,
Can you post screenshot for the PutDatabaseRecord configuration and the associated Database Connection Pooling Service configuration to help us troubleshoot what is going on? Are both tables located under the same DB?
Created 02-21-2024 11:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@zukhriddin, when using PutDatabaseRecord, you have to set the Schema Name and the Table Name :). The Catalog Name is not quite necessary as is it not used for Oracle databases. Next, on the Database Type, make sure that you have selected the correct version for your Oracle DB... and of course the Statement Type should be INSERT (at least while you are testing)
PS: make sure that the user you have configured in your Database Connection Pooling Service has all the necessary grants to see and modify your table.
Created 02-26-2024 07:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@zukhriddin Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks.
Regards,
Diana Torres,Community Moderator
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:
Created 04-03-2024 12:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the reply. I have found the answer myself. The table name must be all in capital letters. No need to add schema or catalog name.
