Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-6409

Error inserting null fields in Teradata (through JDBC)

    XMLWordPrintableJSON

    Details

      Description

      Hi,

      I'm trying to insert data in a Teradata database using PutDatabaseRecord processor. The process is fine until one record (input field) is null. Then the entire insertion batch get an error and do rollback of the transaction. 

      Error capture: 

      Attached the configuration info:

      -Processor: 

      -Pool: 

      Any idea about how can I resolve this error? 

       

      Thank you in advance,

      Guillermo Chico

       

       

       

       

        Attachments

        1. ErrorNull.png
          101 kB
          Guillermo Chico
        2. PutDatabaseRecord.PNG
          45 kB
          Guillermo Chico
        3. TeradataPool.jpg
          64 kB
          Guillermo Chico

          Issue Links

            Activity

              People

              • Assignee:
                mattyb149 Matt Burgess
                Reporter:
                gchicopl Guillermo Chico
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.5h
                  0.5h