Oracle EBS: Report問題 REP-0069: Internal error

問題: 有個以XML publisher製作的報表, 原先就已經很多欄位, 再增加三個欄位後, 出現error:

MSG-00001: 
MSG-00000: 
MSG-00001:  AND 1=1
REP-0002: Unable to retrieve a string from the Report Builder message file.
REP-271504897:
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-271504897: MSG-00001: 
MSG-00000: 
MSG-00001:  AND 1=1
REP-0002: Unable to retrieve a string from the Report Builder message file.
REP-271504897:

REP-0069: Internal error
java.lang.OutOfMemoryError: unable to create new native thread

在Oracle找到的建議作法為:

a) Backup the file $ORACLE_HOME/bin/reports.sh .
b) Edit the file $ORACLE_HOME/bin/reports.sh and add the lines:
REPORTS_JVM_OPTIONS="-Xms256M -Xmx2048M"
export REPORTS_JVM_OPTIONS
c) Re-test the failing report(s).

但目前還是無解.


Ref:
1.Some Reports Fail With The Error : REP-0069: Internal error java.lang.OutOfMemoryError: unable to create new native thread (Doc ID 1415499.1)