DESFORMAT=XML Fails With REP-271504897 With Long Column and Long Data
Last updated on JULY 26, 2016
Applies to:Oracle Reports Developer - Version 10.1.2.0.2 to 188.8.131.52.0 [Release Oracle10g to 11g]
Information in this document applies to any platform.
***Checked for relevance on 01-Nov-2013***
Report fails with following errors :
when all of the followings are true :
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
(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:
(EngineImpl:run): CRunReport returns: 271504897
Exception 271504897 (): Unable to retrieve a string from the Report Builder message file.
PS : In version 184.108.40.206 (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.
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