XML / BI Publisher – Scalability Option

****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…***

This error happens intermittently.

To implement the solution, please execute the following steps::
1. Sysadmin: Concurrent: Program: Define,

2. Query for concurrent program with the short name =XXABC

In the ‘Options’ field change the value to -Xmx1024M. (or higher).  You can change the value to v             -Xmx2048M,  and possibly even -Xmx4096M.  Ultimately, you may exceed the heap size. Restart the concurrent manager so that changes take effect

Note: Enabling the scalability feature and changing the heap size to -Xmx1024M’ is not recommended to be on the global level ,let it only on concurrent program level

Similar Errors or Generic Error can be rectify by below steps as well

1. Log into the XML Publisher Administrator responsibility.
2. Navigate to Home – Administration – Configuration.
3. Under the General Properties select Temporary directory.
4. Select a temporary file location on your concurrent processing node. This should be at least 5Gb or 20 times larger than the largest XML data file you generate.

OR

1. Log into the XML Publisher Administrator responsibility.
2. Navigate to Home – Administration – Configuration.
3. Under the FO Processing Properties set:
a. Use XML Publisher’s XSLT processor to True.
b. Enable scalable feature of XSLT processor to False.
c. Enable XSLT runtime optimization to True.