Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Print Bookmark Alert me when this article is updated


ERROR: "Failed to process data: ExcelToDataXml: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)" when running an UDT in PowerCenter
Problem Description
Session using UDT transformation fails with the below error when processing huge files (greater than 1 GB):

[ERROR] Failed to process data: ExcelToDataXml: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at itemfield.main.ExcelToXmlDataOnly.process(
Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded
at itemfield.excel2007.main.Excel2007ToDataXml_imp.unZipFile(
at itemfield.excel2007.main.Excel2007ToDataXml_imp.process(

The same session runs fine when the input is below 500 MB.

The issue was caused due to insufficient Java heap space. The Integration Service process was not able to allocate enough heap space to process the huge file.
Following changes need to be made to resolve the issue:
  • ​​Add the following custom properties to the Integration Service. Recycle the Integration service after making this change:
Name : JVMMaxMemory    Value : 8192M
Name : JVMMinMemory     Value : 1024M
Name : JVMOption1          Value : -XX:+UseConcMarkSweepGC
  • Make the below change to the CMConfig.xml file:

More Information

The heap space values depend on the environment as well as the amount of incoming data.
In case there are other java related sessions (web consumer/java transformation etc) running at the same time as this, then heap space needs to be calculated accordingly.

Applies To
Product: PowerCenter
Problem Type: Performance
User Type: Developer; Administrator
Project Phase: Implement; Configure
Product Version:
Operating System:
Other Software:

Last Modified Date:8/8/2020 12:48 AMID:625994
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)