You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "Shiv (Jira)" <ji...@apache.org> on 2022/10/17 12:00:00 UTC

[jira] [Created] (NIFI-10657) When multiple CLOB columns in a table are configured for processing in Oracle, NIFI is throwing Out of Memory exception.

Shiv created NIFI-10657:
---------------------------

             Summary: When multiple CLOB columns in a table are configured for processing in Oracle, NIFI is throwing Out of Memory exception.
                 Key: NIFI-10657
                 URL: https://issues.apache.org/jira/browse/NIFI-10657
             Project: Apache NiFi
          Issue Type: Bug
          Components: Core Framework
    Affects Versions: 1.17.0
         Environment: Docker container
            Reporter: Shiv


This issue is happening because Nifi Processor PutDatabaseRecord is not clearing CLOBs once the data is written to the databases.

The Nifi Processor code needs to be modified to clear CLOB before closing Resultsets.

Even though the issue is reproduced and tested for Oracle database, it could be a problem for other databases too. 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)