4 Replies Latest reply on Aug 12, 2006 12:54 PM by Denis Segard-Oracle

    REP-501: Unable to connect to the specified database

    483833
      Hi, the following error occurs when running a paper report from forms:[

      2006/8/10 9:38:19:493] State 56016 (JobManager:updateJobStatus): Job 22 status is: Terminated with error:
      REP-501: Unable to connect to the specified database.
      [2006/8/10 9:38:19:494] Debug 50103 (JobManager:notifyWaitingJobs): Master job 22 notify its duplicated jobs.
      [2006/8/10 9:38:19:496] Debug 50103 (JobManager:updateJobStatus): Finished updating job: 22
      [2006/8/10 9:38:19:500] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Ready
      [2006/8/10 9:38:19:530] Exception 501 (): Unable to connect to the specified database.
      exception oracle.reports.RWException {
      oracle.reports.RWError[] errorChain={struct oracle.reports.RWError {
      int errorCode=501,
      java.lang.String errorString="Unable to connect to the specified database.",
      java.lang.String moduleName="REP"
      }}
      }
           at oracle.reports.RWExceptionHelper.read(RWExceptionHelper.java:28)
           at oracle.reports.engine._EngineClassStub.run(_EngineClassStub.java:159)
           at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:784)
           at oracle.reports.server.JobManager.runJobLocal(JobManager.java:1557)
           at oracle.reports.server.JobManager.dispatch(JobManager.java:896)
           at oracle.reports.server.ConnectionImpl.runJob(ConnectionImpl.java:1166)
           at oracle.reports.server.ConnectionPOATie.runJob(ConnectionPOATie.java:296)
           at oracle.reports.server.ConnectionPOA._invoke(ConnectionPOA.java:419)
           at oracle.reports.server.ConnectionPOA._invoke(ConnectionPOA.java:85)
           at com.inprise.vbroker.poa.POAImpl.invoke(POAImpl.java:2355)
           at com.inprise.vbroker.poa.ActivationRecord.invoke(ActivationRecord.java:104)
           at com.inprise.vbroker.GIOP.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.java:492)
           at com.inprise.vbroker.IIOP.ServerProtocolAdapter.doRequest(ServerProtocolAdapter.java:64)
           at com.inprise.vbroker.GIOP.GiopProtocolAdapter.dispatchMessage(GiopProtocolAdapter.java:653)
           at com.inprise.vbroker.orb.TPDispatcherImpl$TPDispatcher.run(TPDispatcherImpl.java:99)
           at com.inprise.vbroker.orb.ThreadPool$PoolWorker.run(ThreadPool.java:76)


      I've included the connection in tnsnames.ora, connecting from forms and sqlplus works fine, only reports generate the error above. Any ideas ?
        • 1. Re: REP-501: Unable to connect to the specified database
          Denis Segard-Oracle
          Hello,

          Check the engine trace file , you may get more details about the error ...

          Regards
          • 2. Re: REP-501: Unable to connect to the specified database
            483833
            In the engine tracefile i found this:

            [2006/8/10 10:48:54:64] Exception 50125 (org.omg.CORBA.TRANSIENT: vmcid: 0x0 minor code: 0 completed: No
                 at com.inprise.vbroker.orb.DelegateImpl.verifyConnection(DelegateImpl.java:336)
                 at com.inprise.vbroker.orb.DelegateImpl.is_local(DelegateImpl.java:496)
                 at org.omg.CORBA.portable.ObjectImpl._is_local(ObjectImpl.java:354)
                 at oracle.reports.server._EngineCommStub.ping(_EngineCommStub.java:91)
                 at oracle.reports.engine.RWEngine.init(RWEngine.java:268)
                 at oracle.reports.engine.RWEngine.main(RWEngine.java:55)
            ): Interner Fehler org.omg.CORBA.TRANSIENT: vmcid: 0x0 minor code: 0 completed: No
            [2006/8/10 10:48:55:79] Exception 50125 (org.omg.CORBA.OBJECT_NOT_EXIST: vmcid: 0x0 minor code: 0 completed: No
                 at com.inprise.vbroker.ProtocolEngine.PortfolioImpl.getConnector(PortfolioImpl.java:79)
                 at com.inprise.vbroker.ProtocolEngine.ManagerImpl.getConnector(ManagerImpl.java:147)
                 at com.inprise.vbroker.orb.DelegateImpl._bind(DelegateImpl.java:196)
                 at com.inprise.vbroker.orb.DelegateImpl.verifyConnection(DelegateImpl.java:365)
                 at com.inprise.vbroker.orb.DelegateImpl.is_local(DelegateImpl.java:496)
                 at org.omg.CORBA.portable.ObjectImpl._is_local(ObjectImpl.java:354)
                 at oracle.reports.server._EngineCommStub.ping(_EngineCommStub.java:91)
                 at oracle.reports.engine.RWEngine.init(RWEngine.java:268)
                 at oracle.reports.engine.RWEngine.main(RWEngine.java:55)
            ): Interner Fehler org.omg.CORBA.OBJECT_NOT_EXIST: vmcid: 0x0 minor code: 0 completed: No


            Any ideas ? Didn't find anything useful in the web
            • 3. Re: REP-501: Unable to connect to the specified database
              Vpandura-Oracle
              Hi,

              Which version of Reports you are using ?
              Did you try running any other simple Report without trying to run from Forms ?
              Could you ever able to run it successfully connecting to db ? I mean was this intermittent or consistent.
              Can you please check whether you have sqlnet.ora in $ORACLE_HOME/network/admin folder. If so what is the content of it. Do you have names.default_domain entry in it. If so what is the value set.

              Thanks,
              Vinod
              Reports DDR.
              • 4. Re: REP-501: Unable to connect to the specified database
                Denis Segard-Oracle
                Hello,

                The trace files do not match in time :
                Server
                [2006/8/10 9:38:19:530] Exception 501 (): Unable to connect to the specified database.

                Engine
                [2006/8/10 10:48:54:64] Exception 50125 (org.omg.CORBA.TRANSIENT: vmcid: 0x0 minor code: 0 completed: No

                --> check the engine trace file corresponding to the time of the error 501.
                (You may set traceMode="trace_append" in the reports server configuration file)

                Regards