E1: XMLP: Report Definitions Intermittently Fails with 'FT' Job Status and Error "SQL0303 - Variable &2 not compatible or value too long" is Found in the Logs (Doc ID 2117316.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
IBM i on POWER Systems

Symptoms

BI Publisher Report Definition jobs are failing intermittently with 'FT' (Templ/Transf unavailable) job status.

An SQL0303 error can be seen in the The following errors are seen in XMLPUBLISHER KERNEL log.

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