Forum Stats

  • 3,851,383 Users
  • 2,263,969 Discussions
  • 7,904,691 Comments

Discussions

Contact with the Discoverer server has been lost. To continue your work, please restart Discoverer P

Tim K.
Tim K. Member Posts: 7 Red Ribbon
edited Dec 23, 2015 11:50AM in Discoverer

Hi,

We are seeing an error with our Discoverer Plus users

"Contact with the Discoverer server has been lost. To continue your work, please restart Discoverer Plus. If this problem persists, please contact your Oracle Application Server administrator. "

We have set the timeout value in $ORACLE_INSTANCE/config/PreferenceServer/Discoverer_asinst_1/pref.txt to 3600 seconds.  However, if we attempt to refresh the workbook after 45 minutes we see the error.  If we leave the session idle, we get a message telling us we have been idle.  We choose to continue, and then when we refresh the worksheet we get the error.

So, it appears to me that the setting in the pref.txt file has been picked up, but there is another timeout set somewhere, that is over-riding this value and disconnecting our sessions.  I'm at a loss to find out where this might be, and would love some pointers as to where I can investigate further.

We're running WebLogic Server 10.3.6.0, with the Discoverer version 11.1.1.6.  Our OS is AIX 7.1


Regards,

Tim.


Answers

  • Tim K.
    Tim K. Member Posts: 7 Red Ribbon
    edited Dec 23, 2015 11:46AM

    One further piece of information:

    no -o tcp_keepidle

    tcp_keepidle = 14400

    So, that's 7200 seconds (2 hours). 

  • Tim K.
    Tim K. Member Posts: 7 Red Ribbon
    edited Dec 23, 2015 11:50AM

    Also,

    The Java Console Log contains the following:

    WARNING: BI Bean condition report from ModelErrorHandler - invalid column range

    23-Dec-2015 16:13:35 oracle.disco.model.log.Log writeln

    WARNING: BI Bean condition report from ModelErrorHandler - invalid column range

    23-Dec-2015 16:13:35 oracle.disco.model.log.Log writeln

    WARNING: BI Bean condition report from ModelErrorHandler - invalid row range

    23-Dec-2015 16:13:35 oracle.disco.model.log.Log writeln

    WARNING: BI Bean condition report from ModelErrorHandler - invalid column range

    23-Dec-2015 16:13:35 oracle.disco.model.log.Log writeln

    WARNING: BI Bean condition report from ModelErrorHandler - invalid row range

    23-Dec-2015 16:49:53 oracle.disco.model.log.Log writeln

    INFO: ExecuteEngine: execute of [email protected]f4c7a

    23-Dec-2015 16:49:53 oracle.disco.model.log.Log writeln

    SEVERE: DiscoApplet[0]: Error received by GlobalStatusListener.workerFailed() in SessionUI.java

    23-Dec-2015 16:49:53 oracle.disco.model.log.Log writeln

    SEVERE: java.lang.IllegalStateException: Non-transactional command attempted in transaction

    23-Dec-2015 16:49:53 oracle.disco.model.log.Log writeln

    SEVERE: java.lang.IllegalStateException: Non-transactional command attempted in transaction

      at oracle.disco.model.corbaserver.ServerAPIState.outsideTransaction(Unknown Source)

      at oracle.disco.model.corbaserver.serverrequest.DsrGeneralCorbaXML.outsideTransaction(Unknown Source)

      at oracle.disco.model.corbaserver.serverrequest.DsrCloseWorkbook.xmlUpdateServer(Unknown Source)

      at oracle.disco.model.corbaserver.serverrequest.DsrCorbaXML.corbaUpdateServer(Unknown Source)

      at oracle.disco.model.corbaserver.serverrequest.DsrGeneralCorbaXML.updateServer(Unknown Source)

      at oracle.disco.model.corbaserver.execengine.ExecuteEngineImpl._nonReentrantExecute(Unknown Source)

      at oracle.disco.model.corbaserver.execengine.ExecuteEngineImpl.execute(Unknown Source)

      at oracle.disco.model.corbaserver.execengine.SessionControllerImpl.execute(Unknown Source)

      at oracle.disco.model.corbaserver.execengine.SessionControllerImpl.execute(Unknown Source)

      at oracle.disco.model.corbaserver.Discoverer.closeActiveWorkbook(Unknown Source)

      at oracle.disco.model.corbaserver.SessionImpl.closeActiveWorkbook(Unknown Source)

      at oracle.disco.model.corbaserver.WorkbookImpl.closeWorkbook(Unknown Source)

      at oracle.disco.worker.MiscellaneousWorker$1.runDiscoWorker(Unknown Source)

      at oracle.disco.worker.DiscoWorker.runWorker(Unknown Source)

      at oracle.bali.ewt.worker.AbstractWorker.run(Unknown Source)

      at oracle.bali.ewt.worker.AbstractWorkerQueue._runWorker(Unknown Source)

      at oracle.bali.ewt.worker.AbstractWorkerQueue.access$100(Unknown Source)

      at oracle.bali.ewt.worker.AbstractWorkerQueue$WorkerContext._run(Unknown Source)

      at oracle.bali.ewt.worker.AbstractWorkerQueue$WorkerContext._runMaybeBlocked(Unknown Source)

      at oracle.bali.ewt.worker.AbstractWorkerQueue$WorkerContext.run(Unknown Source)

      at oracle.bali.ewt.worker.ThreadWorkerQueue$TaskAdapter.runTask(Unknown Source)

      at oracle.bali.share.thread.TaskScheduler.runTask(Unknown Source)

      at oracle.bali.share.thread.TaskScheduler.processTask(Unknown Source)

      at oracle.bali.share.thread.TaskScheduler$TaskQueue.run(Unknown Source)

      at oracle.bali.share.thread.Timer.doRun(Unknown Source)

      at oracle.bali.share.thread.Timer.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

    Error: java.lang.IllegalStateException: Non-transactional command attempted in transaction

    java.lang.IllegalStateException: Non-transactional command attempted in transaction

      at oracle.disco.model.corbaserver.ServerAPIState.outsideTransaction(Unknown Source)

      at oracle.disco.model.corbaserver.serverrequest.DsrGeneralCorbaXML.outsideTransaction(Unknown Source)

      at oracle.disco.model.corbaserver.serverrequest.DsrCloseWorkbook.xmlUpdateServer(Unknown Source)

      at oracle.disco.model.corbaserver.serverrequest.DsrCorbaXML.corbaUpdateServer(Unknown Source)

      at oracle.disco.model.corbaserver.serverrequest.DsrGeneralCorbaXML.updateServer(Unknown Source)

      at oracle.disco.model.corbaserver.execengine.ExecuteEngineImpl._nonReentrantExecute(Unknown Source)

      at oracle.disco.model.corbaserver.execengine.ExecuteEngineImpl.execute(Unknown Source)

      at oracle.disco.model.corbaserver.execengine.SessionControllerImpl.execute(Unknown Source)

      at oracle.disco.model.corbaserver.execengine.SessionControllerImpl.execute(Unknown Source)

      at oracle.disco.model.corbaserver.Discoverer.closeActiveWorkbook(Unknown Source)

      at oracle.disco.model.corbaserver.SessionImpl.closeActiveWorkbook(Unknown Source)

      at oracle.disco.model.corbaserver.WorkbookImpl.closeWorkbook(Unknown Source)

      at oracle.disco.worker.MiscellaneousWorker$1.runDiscoWorker(Unknown Source)

      at oracle.disco.worker.DiscoWorker.runWorker(Unknown Source)

      at oracle.bali.ewt.worker.AbstractWorker.run(Unknown Source)

      at oracle.bali.ewt.worker.AbstractWorkerQueue._runWorker(Unknown Source)

      at oracle.bali.ewt.worker.AbstractWorkerQueue.access$100(Unknown Source)

      at oracle.bali.ewt.worker.AbstractWorkerQueue$WorkerContext._run(Unknown Source)

      at oracle.bali.ewt.worker.AbstractWorkerQueue$WorkerContext._runMaybeBlocked(Unknown Source)

      at oracle.bali.ewt.worker.AbstractWorkerQueue$WorkerContext.run(Unknown Source)

      at oracle.bali.ewt.worker.ThreadWorkerQueue$TaskAdapter.runTask(Unknown Source)

      at oracle.bali.share.thread.TaskScheduler.runTask(Unknown Source)

      at oracle.bali.share.thread.TaskScheduler.processTask(Unknown Source)

      at oracle.bali.share.thread.TaskScheduler$TaskQueue.run(Unknown Source)

      at oracle.bali.share.thread.Timer.doRun(Unknown Source)

      at oracle.bali.share.thread.Timer.run(Unknown Source)

      at java.lang.Thread.run(Unknown Source)

This discussion has been closed.