ODI Loading Data Via a Mapping Fails with Connection Closed Errors using MS SQL Server 2017
(Doc ID 2361670.1)
Last updated on OCTOBER 22, 2019
Applies to:Oracle Data Integrator - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
In ODI Studio 188.8.131.52.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:
- 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 184.108.40.206.
- 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document