DESFORMAT=XML Fails With REP-271504897 With Long Column and Long Data (Doc ID 843678.1)

Last updated on JULY 26, 2016

Applies to:

Oracle Reports Developer - Version 10.1.2.0.2 to 11.1.1.7.0 [Release Oracle10g to 11g]
Information in this document applies to any platform.
***Checked for relevance on 01-Nov-2013***

Symptoms

Report fails with following errors :

REP-271504897: Unable to retrieve a string from the Report Builder message file.
REP-271504897:


when all of the followings are true :

1. desformat=XML
2. The query is based on a table which has a "LONG" column
3. The length of the data in LONG column is 8192 bytes or larger. (When NLS_LANG and the database characterset does not match exactly -for example one is UTF8 and the other is WE8ISO8859P1- it fails even sooner, that is after 2730 characters)

Engine trace shows following errors when tracing is enabled :

  (C Engine): 13:58:12  APP  (  Database Column          LONG_TEXT
  (C Engine): 13:58:12  APP  )  Database Column          LONG_TEXT
  (rwmuio:rwmuiogu_GetUnicodeString): Destination buffer is more than 8192 bytes
  (rwfdt:rwfdtprint): 13:58:12  ERR Error occurred sending Job output to cache
  (C Engine): 13:58:12  ERR REP-0002: Unable to retrieve a string from the Report Builder message file.
  (C Engine): 13:58:12  ERR REP-271504897:
  (rwfdt:rwfdtfl_FreeDistList): running
  (rwfdt:rwfdtfl_FreeDistList): quit
  (EngineImpl:run): CRunReport returns: 271504897
  (EngineImpl:run): Quit
  Exception 271504897 (): Unable to retrieve a string from the Report Builder message file.
  REP-271504897:


PS : In version 6.0.8.28 (generated only for Oracle EBusiness Suite Customers) the same problem occurs, but the errors are not visible, but instead the generated XML output file is broken at this column.

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