Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

In-place upgrade of Informatica domain fails with no error in the upgrade log
Problem Description
In-place upgrade or Informatica domain from 10.2.x to 10.4 fails with no error message in logs.

Following is the last lines in the upgrade log:

Database type: : oracle 
Database user ID: : INFBDM_DOM 
Database user password: : ***** 
JDBC connect string : jdbc:informatica:oracle://infadbhost:1521;ServiceName=ORCL;MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true 

Modifying odbc.ini file

Modifying odbcinst.ini file

Cause
Upon running the upgrade again with environment variable LAX_DEBUG=true, found that it was due to heap size (Xmx) of node (in 10.2.x) set incorrectly.
It was set as 4g in infaservice.sh script.

java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.informatica.installer.mjtactions.MJTAction.execute(MJTAction.java:21)
        at com.informatica.installer.mjtactions.ConditionsCheck.update(ConditionsCheck.java:69)
        at com.informatica.installer.listeners.WizardController.nextClick(WizardController.java:360)
        at com.informatica.installer.listeners.WizardController.startConsoleListener(WizardController.java:180)
        at com.informatica.installer.listeners.WizardController.continueInstall(WizardController.java:765)
        at com.informatica.installer.listeners.WizardController.run(WizardController.java:857)
Caused by: java.lang.NumberFormatException: For input string: "4g"
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:580)
        at java.lang.Integer.parseInt(Integer.java:615)
        at com.informatica.installer.action.InfaServiceFileModifier.execute(InfaServiceFileModifier.java:77)
        at com.informatica.installer.action.ExecuteUpgradeCommand.execute(ExecuteUpgradeCommand.java:47)
        at com.informatica.installer.action.ExecuteUpgradeCommand90.runCommand(ExecuteUpgradeCommand90.java:19)
        at com.informatica.installer.action.ExecuteUpgradeCommand90.execute(ExecuteUpgradeCommand90.java:47)
        ... 10 more

Solution
Update -Xmx value in the INFA_JAVA_OPTS environment variable in infaservice.sh script (of 10.2.x) from 4g to 4096m and rerun the upgrade.

For example, change it from,

INFA_JAVA_OPTS="-Xmx4g ${INFA_JAVA_OPTS} -XX:MaxMetaspaceSize=256m"

to

INFA_JAVA_OPTS="-Xmx4096m ${INFA_JAVA_OPTS} -XX:MaxMetaspaceSize=256m"

More Information
Applies To
Product: PowerCenter; Data Quality
Problem Type: Installation
User Type: Administrator
Project Phase: Configure
Product Version: PowerCenter; Data Quality
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:8/11/2020 11:07 PMID:620812
People who viewed this also viewed

Feedback

Did this KB document help you?



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