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

              mattyb149 Matt Burgess
              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