My Oracle Support Banner

"ODI-40730: Standalone schema type is not compatible with external database storage" when Using JDBC External Database Properties in XML Dataserver (Doc ID 2667323.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Symptoms

From Oracle Data Integrator (ODI) Studio topology > Physical Architecture > Technologies > XML

The error below occurs when clicking the 'Test Connection' button after trying to configure the JDBC properties of a XML dataserver:

Observe the error happens regardless of the type of agent (Standalone, J2EE or Local) selected when testing the connection

Changes

The note below was followed to configure the database external properties prior to the occurrence of the issue, note the 'standalone' property is not mentioned there:

Document 1263187.1 - How to Set Up the XML Driver External Database Features Properties File with ODI

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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