Concurrent Requests Completing with Error Status in EBS R12

[Rabia]

Hi Ermaan, I hope you are doin well. I am facing an issue . KIndly guide me

In the Oracle E-Business Suite Production environment, multiple concurrent requests are completing with the status "Completed – Error".


Long-running concurrent requests are completing with errors due to large output data volume.



A custom XML Publisher report is failing with below error while handling large output data.

REP-0300: ORACLE error occurred.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: ORACLE error occurred.

The same report is completing normally when the data volume is less.

[ErmanArslansOracleBlog]

is the bottom of the error stack is REP-30000 or REP-300 ?

REP-3000: Internal error

so I guess you sent a wrong information here.
If so , I will tell you a story of mine;

One customer was encountering Rep-3000 errors, in some E-Business Suite concurrent programs --Oracle Reports..
Rep-3000 error was a common error for EBS systems in Linux/Unix, and the solution was disabling the access control for X sessions using xhost + command.. The command should be run from the Server itself, from a local connection.. But before running the xhost + command, DISPLAY environment variable should be set to the DISPLAY used in EBS concurrent managers..
So the display used in EBS concurrent managers of the customer's EBS system was hostname:0.0..
The problem was, after setting display variable to hostname:0.0 , xhost + command encountered errors.

The comand was;

export DISPLAY=exatest:0.0
xhost +

The error was;

xhost: unable to open display "exatest:0.0"


So, after some analysis, I found that a X server was actually listening on port :0, but its authorization was be sourced before the xhost + command .
I found the authorization of the relevant X server process, using proc filesystem.. and sourced it before running the xhost + command.. And the issue is fixed..

The solution was;

root@exatest ~]# export XAUTHORITY=/var/gdm/:0.Xauth
[root@exatest ~]# export DISPLAY=exatest:0.0
[root@exatest ~]# xhost +
access control disabled, clients can connect from any host