Re: XML report completing with error and not opening

Posted by karthikmca.bhc on Dec 25, 2018; 2:15pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/XML-report-completing-with-error-and-not-opening-tp7019p7024.html

Thanks Emman for giving me test workaround and quick support. I enabled the trace and found some abnormal entries related to the hostname. When I check /etc/hosts file its not updated properly. I updated it and bounced the concurrent managers then it got fixed. 

Thanks a lot for your advise and it’s much helpful to me for troubleshooting and fixing this issue. 

Thanks,

Karthik

On Tue, Dec 25, 2018 at 2:39 PM ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:

1) Please provide me the details of your environment? (version?, RAC or single not?)
2) Did you check the SQL query of this failing request? Probably, the query is failing in the backend and that's why you are seeing the exhausted result set error..
3) Please enable trace for this concurrent program and re-run it. Send me the db trace of the concurrent program after the execution, so I can check the queries as well.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/XML-report-completing-with-error-and-not-opening-tp7019p7023.html

To unsubscribe from XML report completing with error and not opening, click here.
NAML

--