Setting Property UseString to True on ORAREAD Causes ReTL to Abort

(Doc ID 2290962.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Retail Extract Tranform and Load - Version 13.2.5 and later
Information in this document applies to any platform.

Symptoms

Enabling useString property to true as per RETL programmer's Guide 13.2 (see section 6-4), in RFX.CONF causes RETL extracts to abort with the following error:

"FATAL - E100: This flow has produced an unexpected error. Please contact customer support.

Have your flow and environment information available.FATAL - E135: Exception in operator oraread:4

E108: null"

Steps to Reproduce:
1. Edit RFX.CONF.
2. Add the useString property to true on oraread.
3. Run a RETL job such as RMSE_RPAS_ITEM_MASTER.KSH and check the log for errors.

Changes

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