Oracle Reports (MOSC)

MOSC Banner

Oracle reports engine hang on select and reports server get restarted by ompn

edited Jan 29, 2014 11:49PM in Oracle Reports (MOSC) 7 commentsAnswered
Hi,I'm using this configuration (oracle reports/forms 10.1.2.3 on AIX 6.1 TL07/power 7 64) and my problem is this : One of my reports enfine gets hang on a select query which take too long time (more then 10 min), then the reports server is restarted automatically by opmn. after the restart is complet some jobs can't be subbmited from oralce forms ( the windows become blanc).
I want to knew why opmn consider reports  in hang sutuation while the engine is just waiting the database to complet the execution query?
Why the engine which executing jobs with the long query not killed by reports server knowing that i have sit the engineResponseTimeOut to 10?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center