ODI 12.2.1.3 Loading Data Via a Mapping Fails with Connection Closed Errors Using MS SQL Server 2017
(Doc ID 2361670.1)
Last updated on NOVEMBER 03, 2023
Applies to:
Oracle Data Integrator - Version 12.2.1.3.0 to 12.2.1.3.221018 [Release 12c]Oracle Data Integrator on Marketplace - Version 1.0.2 to 2.0.2
Information in this document applies to any platform.
Symptoms
In Oracle Data Integrator (ODI) Studio 12.2.1.3.0, a one-to-one mapping was created to move data from the Oracle database to Microsoft SQL Server 2017. This mapping always fails to execute with several different errors as follows:
Errors Received
- Connection closed to Microsoft SQL Server
- Error informing the user that the Microsoft SQL Server does not support the numeric precision for conversion.
Error stacks could be like:
Steps to Reproduce Issue
The issue can be reproduced at will with the following steps:
- Create a mapping in ODI 12.2.1.3.
- Add an Oracle Database source model to the mapping.
- Add a Microsoft SQL Server 2017 model to the mapping.
- Ensure that no conversion is done via the mapping - simply data movement
Changes
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! |