6 Replies Latest reply: Nov 24, 2011 5:58 AM by 900295 RSS

    Error Message Displayed while executing FNDLOAD Command in windows machine

    900295
      Hi,

      I am getting the following error message while executing the FNDLOAD Command in Windows Machine. Can any one give some clarifications to solve this issue.

      FNDLOAD Command Used:*

      +./FNDLOAD apps/apps@16.89.26.52:1521:OA10 0 Y DOWNLOAD D:\oracle\oa10appl\xdo\11.5.0/patch/115/import/xdotmpl.lct xdotmpl.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=PO

      Error message Displayed for above command:_
      APP-FND-01564: ORACLE error 6401 in AFPCOA
      Cause:  AFPCOA failed due to ORA-06401: NETCMN: invalid driver designator

      Let me know the solution this issue

      Regards
      Arif Mohammed
        • 1. Re: Error Message Displayed while executing FNDLOAD Command in windows machine
          Hussein Sawwan-Oracle
          Please see these docs.

          How To Use XDOLoader to Manage, Download and Upload Files? [ID 469585.1]
          Running XDOLOAD to Download XML Data Definitions Fails with ORA-6401 [ID 374195.1]

          Thanks,
          Hussein
          • 2. Re: Error Message Displayed while executing FNDLOAD Command in windows machine
            900295
            Hi Hussein,

            Thanks for your response, Let me explain in detail that the error I am facing while running FNDLOAD Command.

            I have executed the below command in CYGWIN which results in error while calling FNDLOAD.

            *$ java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION 16.89.26.52:1521:OA10 -LOB_TYPE TEMPLATE -APPS_SHORT_NAME PO -LCT_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LANGUAGE en -TERRITORY US -LOG_FILE SHW.log;*

            I got the below error message while executed the above command (Highlighted in BOLD):

            $ cat SHW.log
            XDOLoader started: Tue Nov 15 20:27:18 PST 2011


            Parameters passed to XDOLoader...
            [TERRITORY] [US]
            [DB_USERNAME] [apps]
            [LCT_FILE] [C:\oracle\vis10appl\xdo\11.5.0/patch/115/import/xdotmpl.lct]
            [DOWNLOAD] [DOWNLOAD]
            [JDBC_CONNECTION] [16.89.26.52:1521:OA10]
            [LANGUAGE] [en]
            [DB_PASSWORD] [apps]
            [LOB_TYPE] [TEMPLATE]
            [LOG_FILE] [SHW.log]
            [APPS_SHORT_NAME] [PO]

            Start downloading...
            Downloading files from XDO_LOBS: SELECT FILE_DATA, LOB_CODE, LOB_TYPE, APPLICATI
            ON_SHORT_NAME, FILE_NAME, LANGUAGE, TERRITORY, XDO_FILE_TYPE FROM XDO_LOBS WHERE
            APPLICATION_SHORT_NAME = :APPS_SHORT_NAME AND LOB_TYPE in (:TEMPLATE, :TEMPLAT
            E_SOURCE) AND LANGUAGE = :LANGUAGE AND TERRITORY = :TERRITORY
            Downloading files from XDO_LOBS: SELECT L.FILE_DATA FILE_DATA, B.TEMPLATE_CODE L
            OB_CODE, L.LOB_TYPE LOB_TYPE, L.FILE_NAME FILE_NAME, L.LANGUAGE LANGUAGE, L.TERR
            ITORY TERRITORY, L.XDO_FILE_TYPE XDO_FILE_TYPE, L.APPLICATION_SHORT_NAME APPLICA
            TION_SHORT_NAME FROM XDO_TEMPLATES_B B, XDO_LOBS L WHERE B.APPLICATION_SHORT_NAM
            E = :APPS_SHORT_NAME AND B.TEMPLATE_CODE = L.LOB_CODE
            Generating LDT file: xdotmpl.ldt

            Calling FNDLOAD: FNDLOAD apps/apps@16.89.26.52:1521:OA10 0 Y DOWNLOAD C:\oracle\
            vis10appl\xdo\11.5.0/patch/115/import/xdotmpl.lct xdotmpl.ldt XDO_DS_DEFINITIONS
            APPLICATION_SHORT_NAME=PO

            APP-FND-01564: ORACLE error 6401 in AFPCOA

            Cause:  AFPCOA failed due to ORA-06401: NETCMN: invalid driver designator.

            The SQL statement being executed at the time of the error was: and was executed
            from the file .

            Generating DRVX file: xdotmpl.drvx


            XDOLoader done successfully: Tue Nov 15 20:27:30 PST 2011
            $

            So i decided to run the FNDLOAD Command alone in CYGWIN which is highlighted and still im facing the same issue but if i run the below command it works fine and getting download.

            *./FNDLOAD apps/apps@16.89.26.52:1521:OA10 0 Y DOWNLOAD D:\oracle\oa10appl\xdo\11.5.0/patch/115/import/xdotmpl.lct xdotmpl.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=PO*

            Hope you understand the problem which im facing. Let me know some solutions from your side to solve this issue.

            Regards,
            Arif Mohammed
            • 3. Re: Error Message Displayed while executing FNDLOAD Command in windows machine
              Hussein Sawwan-Oracle
              Arif,

              Are "16.89.26.52:1521:OA10" the correct "Database IP Address:Database Port Number:SID"?

              Thanks,
              Hussein
              • 4. Re: Error Message Displayed while executing FNDLOAD Command in windows machine
                900295
                Hi Hussein,

                DB IP Address, Port no and SID are correct bcoz as i mentioned in previous comment the below command is working fine.

                *./FNDLOAD apps/apps@16.89.26.52:1521:OA10 0 Y DOWNLOAD D:\oracle\oa10appl\xdo\11.5.0/patch/115/import/xdotmpl.lct xdotmpl.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=PO*

                But the FNDLOAD command is not working while calling from XDOLOADER.

                Regards,
                Arif Mohammed.

                Edited by: 897292 on Nov 16, 2011 5:20 PM
                • 5. Re: Error Message Displayed while executing FNDLOAD Command in windows machine
                  Hussein Sawwan-Oracle
                  Please try this format for the JDBC_CONNECTION and see if you get the same error -- '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<HOST_NAME>)(PORT=<PORT>))(CONNECT_DATA=(SERVICE_NAME=<SID>)))'

                  If you still have the same issue, then please log a SR.

                  Thanks,
                  Hussein
                  • 6. Re: Error Message Displayed while executing FNDLOAD Command in windows machine
                    900295
                    Hi Hussein,

                    Thanks for your valuable reply...

                    Nw it works fine..

                    Regards
                    Arif Mohammed