E1: DB: Error "ODB0000092 - SQLExtendedFetch Failed" and "String data, right truncation" in SQL Server Database (Doc ID 1520724.1)

Last updated on AUGUST 21, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

User runs UBE R42565 (Invoice Print) in EnterpriseOne 9.1 Tools Release 9.1.2.1 with SQL Server 2008 R2 SP2.  The invoice print R42565 UBE does not print some sales order lines.
The SQL generated from R42565 picks up more sales order records.  However these order lines do not appear on the R42565 PDF. 

Regardless of order number, it fails with the following in the UBE log for R42565: 

 

 

Cause

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 hundreds of Community platforms