"Servicetable/Shadowtable datasource not available" Error Received when Updating ODI Domain (Doc ID 2369330.1)

Last updated on MAY 27, 2020

Applies to:

Symptoms

When attempting to update the Oracle Data Integrator (ODI) collocated agent domain using the Configuration Wizard (Config.sh for Linux), the following error occurs:

2018-02-16 17:41:13,360 SEVERE [53] com.oracle.cie.domain.ConfigMappingHelper - Connection not available.
java.lang.IllegalStateException: Servicetable/Shadowtable datasource not available.
at com.oracle.cie.domain.ConfigHelper.getLocalServiceTableDSName(ConfigHelper.java:424)
at com.oracle.cie.domain.ConfigHelper.getLocalDataSourceConnection(ConfigHelper.java:439)
at com.oracle.cie.domain.ConfigMappingHelper.getLocalDataSourceConnection(ConfigMappingHelper.java:1237)
at com.oracle.cie.domain.ConfigMappingHelper.retrieveConnection(ConfigMappingHelper.java:111)
at com.oracle.cie.domain.ConfigMappingHelper.processMappings(ConfigMappingHelper.java:513)
at com.oracle.cie.domain.WLSConfigMappingHelper.processUpdate(WLSConfigMappingHelper.java:61)
at com.oracle.cie.domain.progress.template.importer.ImporterGenerationPhase.execute(ImporterGenerationPhase.java:118)
at com.oracle.cie.domain.progress.AbstractProgressGenerator.run(AbstractProgressGenerator.java:94)
at java.lang.Thread.run(Thread.java:745)
2018-02-16 17:41:13,362 SEVERE [53] com.oracle.cie.domain.progress.AbstractProgressGenerator - Error occurred in phase {Artifacts Generation} execution.
java.lang.IllegalStateException: Servicetable connection not available.
isSampleDB=false

isLocalDb()=false

at com.oracle.cie.domain.ConfigMappingHelper.processMappings(ConfigMappingHelper.java:518)
at com.oracle.cie.domain.WLSConfigMappingHelper.processUpdate(WLSConfigMappingHelper.java:61)
at com.oracle.cie.domain.progress.template.importer.ImporterGenerationPhase.execute(ImporterGenerationPhase.java:118)
at com.oracle.cie.domain.progress.AbstractProgressGenerator.run(AbstractProgressGenerator.java:94)
at java.lang.Thread.run(Thread.java:745)
2018-02-16 17:41:13,418 SEVERE [53] com.oracle.cie.domain.progress.template.importer.ImporterExceptionHandlingPhase - Domain Extension Application Failed!

Domain Location: /user_projects/domains/<Domain_Name>

Reason: Servicetable connection not available.
isSampleDB=false

isLocalDb()=false


Exception:

Servicetable connection not available.
isSampleDB=false

isLocalDb()=false


java.lang.IllegalStateException: Servicetable connection not available.
isSampleDB=false

isLocalDb()=false

at com.oracle.cie.domain.ConfigMappingHelper.processMappings(ConfigMappingHelper.java:518)
at com.oracle.cie.domain.WLSConfigMappingHelper.processUpdate(WLSConfigMappingHelper.java:61)
at com.oracle.cie.domain.progress.template.importer.ImporterGenerationPhase.execute(ImporterGenerationPhase.java:118)
at com.oracle.cie.domain.progress.AbstractProgressGenerator.run(AbstractProgressGenerator.java:94)
at java.lang.Thread.run(Thread.java:745)

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.