Scalability Options for XML Publisher Reports - Data Template case

hi All,

The following post is actually a nice solution I found on the web for the issue we were having with several XML publisher reports: Data Template concurrent programs were failing with errors like even before the OPP run:

****Warning!!! Due to high volume of data, got out of memory exception…*** 
****Please retry with scalable option or modify the Data template to run in scalable mode…***

Any changes that were done to the scalability property of the Data Template:

<properties>
    <property name="scalable_mode" value="on"/>
</properties>

 had no effect what so ever...

I saw several solutions for this issue - the only one that did the trick on R12 is as follows:

From System Administrator/Application Developer navigate to Concurrent Program definitions and insert the following string into the Option field: -Xss2048k -Xmx512m

This command allocates additional memory to the Java heap used by Data Template Run.

Link to the original post

Previous solution works well even on 11i, but in both cases, you are restricted by an amount of physical memory you could spend and in case you are creating BIG XML file program still crashes.

Another neat trick that I came across (it was successfully implemented in 11i for VERY big XML) is adding a Scalable Flag as one of the concurrent programs' parameters.

Directions are as follows:

•  Locate relevant Data Template concurrent program. 

At System Administrator/Application Developer responsibility access to Concurrent>Program>Define

•  After the last parameter add a new one named P_SCALABLE_FLAG. 

Description: ScalableFlag  
Prompt: P_SCALABLE_FLAG
Value Set: XLA_SRS_NO_VALIDATION
Default Type: Constant
Default Value: Y

Token: ScalableFlag - do not change the name of the token.

If you have default PL/SQL package defined for Data Template, make sure to declare P_SCALABLE_FLAG as a global type in package specifications.

enjoy,

Felix