1 Reply Latest reply on May 1, 2018 8:09 PM by Neeraj Upadhyay

    Informatica cloud - Out of memory

    Jagadeesh Jayavelu New Member

      Hi,

       

      I am using informatica trial version and using the available “Informatica Cloud Hosted Agent” . I tried to connect to snowflake database and move data from one table to another (I.e. Source and target is snowflake database tables). The mapping tasks failed with out of memory exception. The table had only 42,000 records. Following the exception none of the mappings are working in the trail version. It says “Internal error. The DTM process terminated unexpectedly. Contact Informatica Global Customer Support.”

       

       

      Original out of memory error is given below:

       

      SEVERE: Exception:

      1. java.lang.OutOfMemoryError: Java heap space

      at net.snowflake.client.jdbc.SnowflakeResultChunk$BlockResultChunkData.allocateArrays(SnowflakeResultChunk.java:491)

      at net.snowflake.client.jdbc.SnowflakeResultChunk$BlockResultChunkData.add(SnowflakeResultChunk.java:358)

      at net.snowflake.client.jdbc.SnowflakeResultChunk.addRow(SnowflakeResultChunk.java:182)

      at net.snowflake.client.jdbc.SnowflakeChunkDownloader$2.parseJsonToChunk(SnowflakeChunkDownloader.java:742)

      at net.snowflake.client.jdbc.SnowflakeChunkDownloader$2.call(SnowflakeChunkDownloader.java:608)

      at net.snowflake.client.jdbc.SnowflakeChunkDownloader$2.call(SnowflakeChunkDownloader.java:491)

      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

      at java.lang.Thread.run(Thread.java:745)

       

      READER_1_1_1> CMN_1761 [2018-05-01 19:32:09.445] Timestamp Event: [Tue May 01 19:32:09 2018]

      READER_1_1_1> CCI_READER_1000 [2018-05-01 19:32:09.445] [ERROR] Failed to read data from the source because of the following error: [[SnowFlake_READER__FAILED_906] Failed to read data from the source because of the following error: [JDBC driver internal error: Java heap space.]]

      READER_1_1_1> CMN_1761 [2018-05-01 19:32:09.445] Timestamp Event: [Tue May 01 19:32:09 2018]

      READER_1_1_1> GENERIC_READ_18 [2018-05-01 19:32:09.445] [ERROR] Error occurred while reading data from the target native system.

      READER_1_1_1> CMN_1761 [2018-05-01 19:32:09.445] Timestamp Event: [Tue May 01 19:32:09 2018]

      READER_1_1_1> JAVA PLUGIN_1762 [2018-05-01 19:32:09.445] [ERROR] com.informatica.powercenter.sdk.SDKException: com.informatica.cloud.api.adapter.runtime.exception.ReadException: com.informatica.cci.runtime.internal.utils.impl.CExceptionImpl: Unable to get result data: Adapter read method has returned failure.

      at com.informatica.cloud.adapter.cci.runtime.CCIRead.read(CCIRead.java:264)

      at com.informatica.cloud.api.adapter.reader.runtime.GenericRdrPartitionDriver.run(Unknown Source)

      READER_1_1_1> CMN_1761 [2018-05-01 19:32:09.445] Timestamp Event: [Tue May 01 19:32:09 2018]

      READER_1_1_1> JAVA PLUGIN_1762 [2018-05-01 19:32:09.445] [ERROR]

      READER_1_1_1> CMN_1761 [2018-05-01 19:32:09.445] Timestamp Event: [Tue May 01 19:32:09 2018]

      READER_1_1_1> JAVA PLUGIN_1762 [2018-05-01 19:32:09.445] [ERROR]            at com.informatica.cloud.api.adapter.reader.runtime.GenericRdrPartitionDriver.run(Unknown Source)

      READER_1_1_1> CMN_1761 [2018-05-01 19:32:09.446] Timestamp Event: [Tue May 01 19:32:09 2018]

      READER_1_1_1> SDKS_38200 [2018-05-01 19:32:09.446] Partition-level [Source]: Plug-in #449900 failed in run().

       

      Thanks

      Jagadeesh