ODI Agent Startup Error ODI-1627: "Error getting instance properties" and "Loading domain config xml or JDBC resource xml error" (Doc ID 2672397.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

After installing/re-installing an Oracle Data Integrator (ODI) 12.2.1.4 standalone agent, the agent will not start. The following error is reported in the agent log:

ODI-1627: "Error getting instance properties"[[
org.apache.commons.cli.ParseException: ODI-1627: "Error getting instance properties"
  at oracle.odi.param.CliParameterReader.<init>(CliParameterReader.java:108)
  at oracle.odi.param.AgentWarClassPathFileReader.<init>(AgentWarClassPathFileReader.java:18)
  at oracle.odi.param.ParameterHelper.init(ParameterHelper.java:102)
  at oracle.odi.Agent.main(Agent.java:734)
Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
  at oracle.odi.cam.OdiProperties.getProperty(OdiProperties.java:249)
  at oracle.odi.cam.mbeans.OdiConfigMBeanSupport.getProperty(OdiConfigMBeanSupport.java:46)
  at oracle.odi.cam.mbeans.OdiAgent.getMasterDatasourceName(OdiAgent.java:114)
  at oracle.odi.cam.mbeans.OdiAgent.getRepository(OdiAgent.java:120)
  at oracle.odi.param.CliParameterReader.<init>(CliParameterReader.java:106)
  ... 3 more
Caused by: 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 oracle.odi.cam.OdiProperties.getProperty(OdiProperties.java:246)
  ... 7 more
Caused by: java.lang.RuntimeException: ODI-1456: getServerConfiguration() failed. domainDir=<FULL_PATH_TO_DOMAIN>, dirPath=<FULL_PATH_TO_DOMAIN>,/config, instanceName=OracleDIAgent, cause=com.oracle.cie.domain.CAMConfigException: ODIConfigurationFactory: Failed to create ODIConfiguration instance.
  at oracle.odi.cam.ServerConfigurationProxy.<init>(ServerConfigurationProxy.java:56)
  at oracle.odi.cam.ServerConfigurationProxy.getInstance(ServerConfigurationProxy.java:63)
  at oracle.odi.cam.OdiAgentProperties.getServerConfiguration(OdiAgentProperties.java:23)
  at oracle.odi.cam.OdiAgentProperties.getMasterDatasourceName(OdiAgentProperties.java:129)
  ... 12 more
Caused by: com.oracle.cie.domain.CAMConfigException: ODIConfigurationFactory: Failed to create ODIConfiguration instance.
  at com.oracle.cie.domain.odi.external.ODIConfigurationFactory.getODIConfiguration(ODIConfigurationFactory.java:345)
  at oracle.odi.cam.ServerConfigurationProxy.<init>(ServerConfigurationProxy.java:47)
  ... 15 more
Caused by: java.lang.reflect.InvocationTargetException
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  at com.oracle.cie.domain.odi.external.ODIConfigurationFactory.getODIConfiguration(ODIConfigurationFactory.java:341)
  ... 16 more
Caused by: com.oracle.cie.domain.CAMConfigException: Loading domain config xml or JDBC resource xml error.
  at com.oracle.cie.domain.odi.internal.impl.ODIConfigurationImpl.init(ODIConfigurationImpl.java:65)
  at com.oracle.cie.domain.odi.internal.impl.ODIConfigurationImpl.<init>(ODIConfigurationImpl.java:44)
  ... 21 more
Caused by: com.oracle.cie.domain.DomainConfigException: com.oracle.cie.domain.aspect.ConfigParsingException: Unable to set version
  at com.oracle.cie.domain.odi.internal.impl.ODIConfigurationImpl.getDomainConfigAspect(ODIConfigurationImpl.java:257)
  at com.oracle.cie.domain.odi.internal.impl.ODIConfigurationImpl.init(ODIConfigurationImpl.java:61)
  ... 22 more
Caused by: com.oracle.cie.domain.aspect.ConfigParsingException: Unable to set version
  at com.oracle.cie.domain.WLSTemplateBuilder.parseConfig(WLSTemplateBuilder.java:289)
  at com.oracle.cie.domain.odi.internal.impl.ODIConfigurationImpl.getDomainConfigAspect(ODIConfigurationImpl.java:253)
  ... 23 more
Caused by: com.oracle.cie.common.CommonException: Product Version not found.
Root Cause: com.oracle.cie.domain.env.EnvironmentServiceException: Failed to get inventory for <ORACLE_HOME>
  at com.oracle.cie.domain.DomainConfigHelper.setDefaultValues(DomainConfigHelper.java:490)
  at com.oracle.cie.domain.WLSTemplateBuilder.parseConfig(WLSTemplateBuilder.java:286)
  ... 24 more
]]

The operating system is Windows, using a non-administrator user. When started with a Windows administrator user, the agent starts up and successfully runs jobs as expected. 

The same or similar behavior is observed when executing the OPatch utility to retrieve the domain inventory.

Changes

The Windows operating system may have been recently upgraded or patched, or the security policies on the user/machine may have been changed.

Cause