question Re: PutDatabaseRecord TableNotFoundException exception in Support Questions

PutDatabaseRecord TableNotFoundException exception

zukhriddin — Wed, 21 Feb 2024 11:11:54 GMT

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

Re: PutDatabaseRecord TableNotFoundException exception

SAMSAL — Wed, 21 Feb 2024 14:56:57 GMT

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?

Re: PutDatabaseRecord TableNotFoundException exception

cotopaul — Thu, 22 Feb 2024 07:50:44 GMT

@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.

Re: PutDatabaseRecord TableNotFoundException exception

DianaTorres — Tue, 27 Feb 2024 03:17:43 GMT

@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.

Re: PutDatabaseRecord TableNotFoundException exception

zukhriddin — Wed, 03 Apr 2024 07:11:00 GMT

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.