My Oracle Support Banner

E-INST: Migrating From DB2 To MSSQL - Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0]String data right truncation (SQLSTATE 22001) (Doc ID 2712286.1)

Last updated on SEPTEMBER 21, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.48 and later
Information in this document applies to any platform.

Symptoms



When trying to migrate Campus Solutions 9.2/PeopleTools 8.57 DEMO Database from DB2 to MSSQL Server using Data Mover, hitting the following error in the middle of the import.






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!


In this Document
Symptoms
Changes
Cause
Solution
References


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