0 Replies Latest reply: Jun 18, 2009 7:19 AM by 569536 RSS

    Unable to connect Discoverer Server:IDL:DCCORBAException:1.0

    569536
      Hi all,
      I installed Discoverer 10 server on a machine called gnvmig.ote.gr and when I connect (from Discoverer Plus) to an Application EUL on the same machine I don't have any kind of problem. If I try to be connected to an Application EUL on another machine I have the following error:

      Unable to connect Discoverer Server:IDL:DCCORBAException:1.0

      I added inside the tnsnames.ora the connection string (to the other machine) and I enabled the trace....but inside the apps_trace.txt I don't any errors.

      The strange thing is that the connection on the remote machine worked perfectly since yesterday....and now....nothing !!


      The connection trace is the following:

      =================STARTUP TIME= =================
      PROCEDURE fnd.src.security.afscp.afscpinit: Begin(fndnam = APPS, gwyuid = APPLSYSPUB/PUB@uat01)
      STATEMENT fnd.src.security.afscp.afscpinit: $Header: afscp.lc 115.25 2002/08/26 18:33:29 sdstratt ship $
      PROCEDURE fnd.src.osd.afenv.usd_load_customfile: Begin(configname = nil)
      PROCEDURE fnd.src.osd.afenv.usd_load_customfile: End: No config file specified
      PROCEDURE fnd.src.security.afscp.afscpinit: End
      PROCEDURE fnd.src.security.afscp.afscpsup: Begin
      STATEMENT fnd.src.security.afscp.afscpsup: Username = ORACLE
      PROCEDURE fnd.src.security.afscp.afscpsup: End: Success
      PROCEDURE fnd.src.security.afscp.afscpcon: Begin
      STATEMENT fnd.src.security.afscp.afscpcon: Connecting to gwyuid = APPLSYSPUB/PUB@uat01
      STATEMENT fnd.src.security.afscp.afscpcon: New security pkg: Retrieving encrypted pwd
      STATEMENT fnd.src.security.afscp.afscpcon: New security pkg success
      STATEMENT fnd.src.security.afscp.afscpcon: Decrypting apps password
      STATEMENT fnd.src.security.afscp.afscpcon: Closing gwyuid connection
      STATEMENT fnd.src.security.afscp.afscpcon: Opening apps connection
      STATEMENT fnd.src.security.afscp.afscpcon: No resp requested
      PROCEDURE fnd.src.security.afscp.afscpcon: End: Success
      PROCEDURE fnd.src.security.afscp.afscpfree: Begin
      PROCEDURE fnd.src.security.afscp.afscpfree: End
      PROCEDURE fnd.src.security.afscp.afscpinit: Begin(fndnam = APPS, gwyuid = APPLSYSPUB/PUB@uat01)
      STATEMENT fnd.src.security.afscp.afscpinit: $Header: afscp.lc 115.25 2002/08/26 18:33:29 sdstratt ship $
      PROCEDURE fnd.src.osd.afenv.usd_load_customfile: Begin(configname = nil)
      PROCEDURE fnd.src.osd.afenv.usd_load_customfile: End: No config file specified
      PROCEDURE fnd.src.security.afscp.afscpinit: End
      PROCEDURE fnd.src.security.afscp.afscpsup: Begin
      STATEMENT fnd.src.security.afscp.afscpsup: Username = ORACLE
      PROCEDURE fnd.src.security.afscp.afscpsup: End: Success
      PROCEDURE fnd.src.security.afscp.afscprsp: Begin(respkey = #521/#52767)
      PROCEDURE fnd.src.security.afscp.afscprsp: End: Success
      PROCEDURE fnd.src.security.afscp.afscpcon: Begin
      STATEMENT fnd.src.security.afscp.afscpcon: Connecting to gwyuid = APPLSYSPUB/PUB@uat01
      STATEMENT fnd.src.security.afscp.afscpcon: New security pkg: Retrieving encrypted pwd
      STATEMENT fnd.src.security.afscp.afscpcon: New security pkg success
      STATEMENT fnd.src.security.afscp.afscpcon: Decrypting apps password
      STATEMENT fnd.src.security.afscp.afscpcon: Closing gwyuid connection
      STATEMENT fnd.src.security.afscp.afscpcon: Opening apps connection
      STATEMENT fnd.src.security.afscp.afscpcon: Get responsibility info
      STATEMENT fnd.src.security.afscp.afscpcon: user_id = 3078, resp_type = I, resp_key = #52767 resp_id = 52767
      STATEMENT fnd.src.security.afscp.afscpcon: appl_type = I, appsname = #521, appl_id = 521, secgrp =
      STATEMENT fnd.src.security.afscp.afscpcon: Decrypting new oracle pwd for resp
      STATEMENT fnd.src.security.afscp.afscpcon: Constructing connect string for resp
      PROCEDURE fnd.src.security.afscp.afscpcon: End: Success
      PROCEDURE fnd.src.security.afscp.afscpfree: Begin
      PROCEDURE fnd.src.security.afscp.afscpfree: End
      "apps_trace.txt" 407 lines, 28412 characters
      PROCEDURE fnd.src.osd.afenv.usd_load_customfile: End: No config file specified
      PROCEDURE fnd.src.security.afscp.afscpinit: End
      PROCEDURE fnd.src.security.afscp.afscpsup: Begin
      STATEMENT fnd.src.security.afscp.afscpsup: Username = ORACLE
      PROCEDURE fnd.src.security.afscp.afscpsup: End: Success
      PROCEDURE fnd.src.security.afscp.afscprsp: Begin(respkey = #521/#52767)
      PROCEDURE fnd.src.security.afscp.afscprsp: End: Success
      PROCEDURE fnd.src.security.afscp.afscpcon: Begin
      STATEMENT fnd.src.security.afscp.afscpcon: Connecting to gwyuid = APPLSYSPUB/PUB@uat01
      STATEMENT fnd.src.security.afscp.afscpcon: New security pkg: Retrieving encrypted pwd
      STATEMENT fnd.src.security.afscp.afscpcon: New security pkg success
      STATEMENT fnd.src.security.afscp.afscpcon: Decrypting apps password
      STATEMENT fnd.src.security.afscp.afscpcon: Closing gwyuid connection
      STATEMENT fnd.src.security.afscp.afscpcon: Opening apps connection
      STATEMENT fnd.src.security.afscp.afscpcon: Get responsibility info
      STATEMENT fnd.src.security.afscp.afscpcon: user_id = 3078, resp_type = I, resp_key = #52767 resp_id = 52767
      STATEMENT fnd.src.security.afscp.afscpcon: appl_type = I, appsname = #521, appl_id = 521, secgrp =
      STATEMENT fnd.src.security.afscp.afscpcon: Decrypting new oracle pwd for resp
      STATEMENT fnd.src.security.afscp.afscpcon: Constructing connect string for resp
      PROCEDURE fnd.src.security.afscp.afscpcon: End: Success
      PROCEDURE fnd.src.security.afscp.afscpfree: Begin
      PROCEDURE fnd.src.security.afscp.afscpfree: End

      I want to underline that I didn't create a secure directory under the .../disco10g/discoverer path
      Maybe should I create it and copy some .dbc files inside ?
      But if the answer is 'YES', how did it work until yesterday ??? I have the suyspect that something has changed on the Application envinronment....

      Any help will be appreciated

      Thanks in advance

      Alex