1 Reply Latest reply on Aug 30, 2021 6:02 AM by Srini Veeravalli

    Informatica CDI Java heap space error

    asd das New Member

      I have an informatica cloud process, which return an array of process objects. It returns 20K+ rows.

      Running a mapping, where I have this process as Source, the mapping fails every time with this error [ERROR] Error occurred when executing the operation : [Unable to get result data: Adapter Call method has returned failure. Java heap space]
      Log file in START LOAD SESSION:

      Load Start Time: Fri Aug 27 13:07:14 2021

       

       

      Target tables:

       

       

           symbollist_csv

       

       

       

       

      READER_1_1_1> CCI_1000 [2021-08-27 13:07:19.893] [INFO] Adapter Id of Runtime Adapter in CCI - com.infa.adapter.genericrest

      READER_1_1_1> CCI_1000 [2021-08-27 13:07:19.893] [INFO] Native Metadata Object Type of Runtime Adapter in CCI - genericrest

      READER_1_1_1> CCI_1000 [2021-08-27 13:07:19.893] [INFO] Operation Type of Runtime Adapter in CCI - GenericRestCall

      READER_1_1_1> CCI_1000 [2021-08-27 13:07:19.912] [INFO] Creating Connection for Runtime Data Adapter in CCI

      READER_1_1_1> CCI_1000 [2021-08-27 13:07:19.915] [INFO] Connection Successfully created for Runtime Data Adapter in CCI

      READER_1_1_1> CCI_1000 [2021-08-27 13:07:20.724] [INFO] Connection established successfully with the data source.

      READER_1_1_1> CCI_1000 [2021-08-27 13:07:20.731] [INFO] Creating Data Adapter in CCI

      READER_1_1_1> CCI_1000 [2021-08-27 13:07:20.741] [INFO] Data Adapter created Successfully in CCI

      READER_1_1_1> CCI_1000 [2021-08-27 13:07:20.742] [INFO] Initializing Data Adapter in CCI

      READER_1_1_1> CCI_1000 [2021-08-27 13:07:20.742] [INFO] Current Thread Name for CCI - Thread-1

      READER_1_1_1> CCI_1000 [2021-08-27 13:07:20.750] [INFO] Data Adapter successfully initialized in CCI

      READER_1_1_1> CCI_1000 [2021-08-27 13:07:20.751] [INFO] Initiating Call Data Session with the Data Adapter in CCI

      READER_1_1_1> CCI_10005 [2021-08-27 13:08:46.167] [INFO] The value for Paging Type is:NONE

      READER_1_1_1> CCI_10005 [2021-08-27 13:08:46.167] [INFO] The value for pattern to stop paging is:

      READER_1_1_1> CCI_10005 [2021-08-27 13:08:46.167] [INFO] Response Status: 200

      READER_1_1_1> CMN_1761 [2021-08-27 13:08:46.167] Timestamp Event: [Fri Aug 27 13:08:46 2021]

      READER_1_1_1> GENERIC_READ_32 [2021-08-27 13:08:46.167] [ERROR] Error occurred when executing the operation : [Unable to get result data: Adapter Call method has returned failure. Java heap space]

      READER_1_1_1> CMN_1761 [2021-08-27 13:08:46.168] Timestamp Event: [Fri Aug 27 13:08:46 2021]

      READER_1_1_1> JAVA PLUGIN_1762 [2021-08-27 13:08:46.168] [ERROR] com.informatica.powercenter.sdk.SDKException: Unable to get result data: Adapter Call method has returned failure. Java heap space

      READER_1_1_1> CMN_1761 [2021-08-27 13:08:46.168] Timestamp Event: [Fri Aug 27 13:08:46 2021]

      READER_1_1_1> JAVA PLUGIN_1762 [2021-08-27 13:08:46.168] [ERROR] at com.informatica.cloud.api.adapter.hierarchy.reader.runtime.HierarchyRdrPartitionDriver.run(Unknown Source)

      READER_1_1_1> CMN_1761 [2021-08-27 13:08:46.168] Timestamp Event: [Fri Aug 27 13:08:46 2021]

      READER_1_1_1> JAVA PLUGIN_1762 [2021-08-27 13:08:46.168] [ERROR] at com.informatica.cloud.api.adapter.reader.runtime.GenericRdrPartitionDriver.run(Unknown Source)

      READER_1_1_1> CMN_1761 [2021-08-27 13:08:46.168] Timestamp Event: [Fri Aug 27 13:08:46 2021]

      READER_1_1_1> SDKS_38200 [2021-08-27 13:08:46.168] Partition-level [Symbol_List]: Plug-in #449200 failed in run().

      WRITER_1_*_1> WRT_8333 [2021-08-27 13:08:46.168] Rolling back all the targets due to fatal session error.

      WRITER_1_*_1> WRT_8035 [2021-08-27 13:08:46.169] Load complete time: Fri Aug 27 13:08:45 2021


      I have tried adding a JVMOption similar to this one here. Support . This only resulted in mappings failure on start, with "Internal error. The DTM process terminated unexpectedly. ..."

      I have also tried to increase Cache Size for Web Service Response (KB) to 8192 and 81920. Didn`t help.

       

      Edit: I tried to pass a single entry into the mapping and worked fine

       

      Please, help. It`s been three days and I simply have no idea where to look for help.