NIFI PutDatabaseRecord question

[Fa...@aegon.hu]

Hi,

I'm struggling with a problem in building a simple flow, that is Nifi should read records form a postgreSQL(EnterpiseDB) table
and sholud put data into a Oracle table:
[cid:image001.png@01D5CAEC.1F7F32A0]
The table and field names are all the same in the source and the target DB .
The PutDatabaseRecord processor looks like this:
[cid:image002.png@01D5CAEC.55229500]
I get the following error message:
none of the fields in the records map to the columns defined by the target_table_ora

Would you please suggest a solution.

Best regards

Imre Fábián







Fontos!
Ezt az elektronikus levelet - beleértve az esetleges mellékleteit is - a levél feladója a címzettként megjelölt személynek szánta. Ha Ön nem címzettje a levélnek kérjük, haladéktalanul értesítse a feladót és a levelet törölje! Felhívjuk szíves figyelmét, hogy az üzenet tartalmának nyilvánosságra hozatala, másolása, terjesztése az Aegon Magyarország engedélye nélkül szigorúan tilos.
ATTENTION:
This email message (including any attachments) may be confidential and is intended solely for the use of the individual or entity to which it is addressed. If you have received it by mistake please notify the sender by return e-mail and delete this message (including any attachments) from your system. You are hereby notified that any disclosure, reproduction, distribution or use of this message without the authority of AEGON N.V. is strictly prohibited and that no rights can be derived from such distribution.

Re: NIFI PutDatabaseRecord question

[Endre Kovács <ek...@cloudera.com.INVALID>]

Hi Imre,

The images usually do not pass through the apache mailing lists.
Please upload the images and provide a link to them, or describe their content textually.

Best regards,
Endre Zoltan Kovacs


> On 14 Jan 2020, at 15:10, <Fa...@aegon.hu> <Fa...@aegon.hu> wrote:
> 
> Hi,
>  
> I’m struggling with a problem in building a simple flow, that is Nifi should read records form a postgreSQL(EnterpiseDB) table
> and sholud put data into a Oracle table:
> 
> The table and field names are all the same in the source and the target DB .
> The PutDatabaseRecord processor looks like this:
> 
> I get the following error message:
> none of the fields in the records map to the columns defined by the target_table_ora
>  
> Would you please suggest a solution.
>  
> Best regards
>  
> Imre Fábián
> 
>  
>  
>  
>  
>  
>  
> Fontos!  
> Ezt az elektronikus levelet - beleértve az esetleges mellékleteit is - a levél feladója a címzettként megjelölt személynek szánta. Ha Ön nem címzettje a levélnek kérjük, haladéktalanul értesítse a feladót és a levelet törölje! Felhívjuk szíves figyelmét, hogy az üzenet tartalmának nyilvánosságra hozatala, másolása, terjesztése az Aegon Magyarország engedélye nélkül szigorúan tilos.  
> ATTENTION:  
> This email message (including any attachments) may be confidential and is intended solely for the use of the individual or entity to which it is addressed. If you have received it by mistake please notify the sender by return e-mail and delete this message (including any attachments) from your system. You are hereby notified that any disclosure, reproduction, distribution or use of this message without the authority of AEGON N.V. is strictly prohibited and that no rights can be derived from such distribution.