"query execution failed" when Runnning ODI Integration Interfaces / Mappings on Database Whose Name Includes Blank (Spacebar) Characters
(Doc ID 454085.1)
Last updated on DECEMBER 20, 2023
Applies to:
Oracle Data Integrator - Version 10.1.3.3.0 and laterOracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.
Symptoms
In Oracle Data Integrator (ODI), a database has been created on a Microsoft SQLServer instance with the name : "Test- 1" (contains a blank (spacebar) character).
Then, after :
- Creating the Data Server form Topology Manager.
- Creating the Physical Schema and associated Logical Schema for a specific Context
- Creating the Model in the ODI Designer Tool
- Attempting to consult the data in the Datastore with a right click > Data, an error message is displayed showing :
As a result it is impossible to run Integration Interfaces on such databases.
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! |