My Oracle Support Banner

UNABLE TO VIEW OUTPUT WHEN PUBLISHING REPORT SET WITH CONTENT SET (Doc ID 827461.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Report Manager - Version 11.5.10.0 to 12.1.2 [Release 11.5 to 12.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Issue appears to be the same as that noted in note:
<Note.758046.1> Publish and Presentation Fails Could Not Identify Expansion Value finding that when using Report Sets with content sets that they will fail and not generate output. The log file shows:

PUBLISH_PRESENT_WRAPPER module: Publish and Presentation Program:
Param size? 31 Is In set? truein set - , NVT name = PUBLISH_SET_ID, val = 18641 END PARAM
Publishing with FO Generation started
content set id is not empty and it is an fsg submission
Failed to get the expanded values: Start of root element expected.
Published doc Id: -1Publishing did not complete successfully, unable to insert data into database
Submission-Publishing Wrapper Finished at Tue May 05 16:25:37 EDT 2009

As per this note and reference bug:
<Bug 7589088> - FSG WITH CONTENT SET:CONTENT SET ID IS NOT EMPTY

The solution is:
Please ask the customer to apply <Patch 7375915> and <Patch 7350414> This should resolve the issues.

These patches have been applied and issue remains:
1.) $Header: FRMStringUtils.java 115.5 2008/09/08 08:30:14
2.) select bug_id, bug_number from ad_bugs
where bug_number in ('7375915','7350414')

--Returns 2 rows; one for each bug/patch


Report Sets without content sets complete without this error... data is visible.
Individual Reports with content set complete with success when not in a report set.


WORKAROUNDS
-----------
1 - don't use content sets or
2 - if using content sets don't use the FSG in a report set.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.