1 2 3 Previous Next 34 Replies Latest reply on Jun 5, 2009 9:43 PM by James Taylor-Oracle

    FTP Adapter Error time out

    Akei
      Hi

      I have read that a polling files from an FTP server windows but I had some problems because the polling ejecutarce to mark the following error log

      <2009-06-01 20:44:52,822> <INFO> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Managed Connection Created
      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Adding Event Listener
      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Creating Connection
      <2009-06-01 20:44:52,822> <INFO> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Connection Created
      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Connection manager allocated connection :oracle.tip.adapter.ftp.FTPConnection@1e2d982
      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host name is 'MyHost'.
      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Reading reply from MyHost
      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: USER cajero
      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: USER, reply:
      331 Password required for cajero.

      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHostFTP command: PASS
      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: PASS, reply:
      230 User cajerologged in.

      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: PASV
      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: PASV, reply:
      227 Entering Passive Mode (192,168,0,150,15,190).

      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Passive: ip = 192.192.0.192, port = 4030
      <2009-06-01 20:44:52,822> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Connecting to MyHost:4030
      <2009-06-01 20:44:52,838> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: NLST C:\pub\cashier
      <2009-06-01 20:44:52,838> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: NLST, reply:
      125 Data connection already open; Transfer starting.

      <2009-06-01 20:44:52,838> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Control socket being read by [JCA-work-instance:FTP Adapter-4]
      <2009-06-01 20:44:52,931> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Control socket read failed by [JCA-work-instance:FTP Adapter-4] DATA=[TIMEDOUT] in [93 msecs]
      <2009-06-01 20:44:52,931> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Sending event: 1 with: oracle.tip.adapter.ftp.FTPConnection@1e2d982
      <2009-06-01 20:44:52,931> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTPManagedConnection::destroy called, closing physical socket
      <2009-06-01 20:44:52,931> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Clearing Event Listeners
      <2009-06-01 20:44:53,088> <DEBUG> <default.collaxa.cube.activation> <AdapterFramework::Inbound> afterDelivery() is invoked
      <2009-06-01 20:44:53,088> <DEBUG> <default.collaxa.cube.activation> <AdapterFramework::Inbound> Committing JTA transaction com.evermind.server.ApplicationServerTransactionManager@1961a07


      I have already changed the timeout of transactions in the following files:

      SOA_HOME\j2ee\oc4j_soa\config\transaction-manager.xml

      greater thanorion-ejb-jar.xml

      SOA_HOME\j2ee\oc4j_soa\application-deployments\orabpel\ejb_ob_engine\orion-ejb-jar.xml

      less than transaction-manager.xml


      SOA_HOME\bpel\domains\domain_name\config\domain.xml

      less than orion-ejb-jar.xml



      but the error continues. I need your help pls be grateful

      Greetings
        • 1. Re: FTP Adapter Error time out
          James Taylor-Oracle
          How big is the file you are trying to read?

          Are you able to transfer the file manually using FTP?

          Is it happening every time you try to transfer a file?

          Did a file exist in the directory you are trying to read?

          93 milli seconds is very short, so it may be something to do with the connectivity.

          cheers
          James
          • 2. Re: FTP Adapter Error time out
            Akei
            Hi JDT

            my file is very short ony 38 bytes

            i want to read the file I get a method in another interface which can access a file using a method SynchRead and works perfectly the problem I have when I want to implement a polling with a method get

            the file already exist in my server i upload every 5 minutes.

            tnks.
            • 3. Re: FTP Adapter Error time out
              617958
              Hi
              Please refer to http://otndnld.oracle.co.jp/document/products/as10g/101310/doc_cd/integrate.1013/b28994/adptr_file.htm for increaing the timeout. Do restart the SOA suite after making the change.

              Regards
              Sahil
              • 4. Re: FTP Adapter Error time out
                James Taylor-Oracle
                Do you delete the message every time? or are you basing off a time stamp?

                Does it work once, e.g. after a bounce it picks up then doesn't work?

                cheers
                James
                • 5. Re: FTP Adapter Error time out
                  Akei
                  Sahil

                       
                  I already did the change in documen transaction-manager.xml located in ORACLE_HOME \ j2ee \ home \ config. I have restarted the SOA but the log continues sending the same message.



                  <?xml version="1.0" encoding="UTF-8"?>

                  <transaction-manager
                  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                  xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/transaction-manager-10_0.xsd"
                  transaction-timeout="420"
                  max-concurrent-transactions="-1"
                  >

                  </transaction-manager>


                  Thanks for your prompt help
                  Regards
                  • 6. Re: FTP Adapter Error time out
                    Akei
                    JDT

                         
                    The file is deleted and reloaded in to the server manually to recognize it, because in the operation, DeleteFile="false"

                    <jca:operation FileType="ascii"
                    PhysicalDirectory="C:\Inetpub\ftproot\Cashier"
                    ActivationSpec="oracle.tip.adapter.ftp.inbound.FTPActivationSpec"
                    IncludeFiles=".*\.txt"
                    DeleteFile="false"
                    PollingFrequency="100"
                    MinimumAge="40"
                    OpaqueSchema="false"/>
                    <input>

                    And the polling I have never worked just another interface that I made using the method invoking SynchRead

                         
                    I have a question the SO by the FTP server is Windows and dividers that sent in the PhysicalDirectory="C:\pub\cashier" is: "\". In the configuration of MS FTPAdapter Cluster Topology> Application Server: SOA.myServer.desarrollo.net> OC4J: oc4j_soa> Application: default> Resource Adapter: FTP Adapter> I have the following:

                    ftpAbsolutePathBegin "\"
                    ftpPathSeparator "\"

                    is that correct?

                    Tnks
                    • 7. Re: FTP Adapter Error time out
                      James Taylor-Oracle
                      That timeout is very small, its not even a second, you have specified it to be 0.420 of a second

                      set it to 30000 which = 5 minutes.

                      cheers
                      James
                      • 8. Re: FTP Adapter Error time out
                        James Taylor-Oracle
                        You may also be hitting some issue with timestamp. Why don't you set delete to true?

                        ftpAbsolutePathBegin is the directory where you login, therefore \ is ok.
                        ftpPathSeparator \ should also be OK with the physical path you specified.

                        I notice that the path you specified here is different to the error, c:\pub\cashier, have you changed something. What is this directory specified in the error?

                        cheers
                        James
                        • 9. Re: FTP Adapter Error time out
                          Akei
                          JDT

                          I change the value by

                          <?xml version="1.0" encoding="UTF-8"?>

                          <transaction-manager
                          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                          xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/transaction-manager-10_0.xsd"
                          transaction-timeout="30000"
                          max-concurrent-transactions="-1"
                          >

                          but the error continues

                          <2009-06-01 23:41:49,602> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: NLST, reply:
                          125 Data connection already open; Transfer starting.

                          <2009-06-01 23:41:49,602> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Control socket being read by [JCA-work-instance:FTP Adapter-4]
                          <2009-06-01 23:41:49,712> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Control socket read failed by [JCA-work-instance:FTP Adapter-4] DATA=[TIMEDOUT] in [110 msecs]
                          <2009-06-01 23:41:49,712> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Sending event: 1 with: oracle.tip.adapter.ftp.FTPConnection@1020391
                          <2009-06-01 23:41:49,712> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTPManagedConnection::destroy called, closing physical socket
                          <2009-06-01 23:41:49,712> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Clearing Event Listeners

                          Regards
                          • 10. Re: FTP Adapter Error time out
                            Akei
                            Hi JDT

                            Actually change some data for the publication but in reality the directory that has to go to the polling is correct and is the same that appears in the error log.

                            I have already changed the DeleteFile="true" and I also uploaded the files to the server but the error continues I do not know what else can be

                            Thank you
                            • 11. Re: FTP Adapter Error time out
                              Akei
                              JDT

                              In making the execution of an interface that executes the method SynchRead and review the log. I realized that the same brand message timeout single interface that works well.

                              <2009-06-02 13:37:50,177> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> ResourceAdapterMetaData Connection Created
                              <2009-06-02 13:37:50,177> <INFO> <default.collaxa.cube.ws> <AdapterFramework::Outbound> file:/F:/product/10.1.3.1/OracleAS_1/bpel/domains/default/tmp/.bpel_BPEL_REGISTRO_COB_1.0_e24ce5bd36c213c5eba6a75bc9f44618.tmp/FTPArchivosICOMS.wsdl [ SynchRead_ptt::SynchRead(Empty,Pagos) ] - Using JCA Connection Pool - max size = <unbounded>
                              <2009-06-02 13:37:50,193> <INFO> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Managed Connection Created
                              <2009-06-02 13:37:50,193> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Adding Event Listener
                              <2009-06-02 13:37:50,193> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Creating Connection
                              <2009-06-02 13:37:50,193> <INFO> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Connection Created
                              <2009-06-02 13:37:50,193> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Connection manager allocated connection :oracle.tip.adapter.ftp.FTPConnection@1f8aab0
                              <2009-06-02 13:37:50,193> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Creating FTPInteraction
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Creating an FTPSender
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Sender created
                              <2009-06-02 13:37:50,224> <INFO> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTPInteraction Created
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP outbound adapter interaction invoked : oracle.tip.adapter.ftp.outbound.FTPReadInteractionSpec@13a6c6f
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FileInteraction::PROPS ====>{}
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Considering header for filename, output filename from header: PGLINEAS1-090508133556.txt
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Considering header for directoryName, directoryName from header: Cashier
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Agent Determined
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTPSource::Local Temp Directory is F:\product\10.1.3.1\OracleAS_1\j2ee\home\fileftp\temp_ftp\localhost_default_BPEL_REGISTRO_COB~1.0_\outbound
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Host: myHost
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Post: 21
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Username: myuser
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Keep Connections: true
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP outbound adapter read file interaction invoked.
                              <2009-06-02 13:37:50,224> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Outbound File Adapter received request to read file with parameters: { Directory=Cashier, FileName=PGLINEAS1-090508133556.txt, DeleteFile=false}, headers=[_directory=[Cashier], _filename=[PGLINEAS1-090508133556.txt], _props=[{}]]
                              <2009-06-02 13:37:50,240> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Creating Temp File mDGwM+l2LhBE8Qq9VFaD1Q== Local Path: F:\product\10.1.3.1\OracleAS_1\j2ee\home\fileftp\temp_ftp\localhost_default_BPEL_REGISTRO_COB~1.0_\outbound Remote Dir: Cashier
                              <2009-06-02 13:37:50,240> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Calling getContentsAsStream() on FTPAgent: myHost: type = FTP, host = myHost:21, username = myuser
                              directory = null, mode = STREAM, fileType = ASCII, maxRetries = 0 Localfile: PGLINEAS1-090508133556.txt Path: F:\product\10.1.3.1\OracleAS_1\j2ee\home\fileftp\temp_ftp\localhost_default_BPEL_REGISTRO_COB~1.0_\outbound\mDGwM+l2LhBE8Qq9VFaD1Q== Remote Dir: Cashier
                              <2009-06-02 13:37:50,240> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host name is 'myHost'.
                              <2009-06-02 13:37:50,240> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Reading reply from myHost
                              <2009-06-02 13:37:50,255> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host myHost FTP command: USER myuser
                              <2009-06-02 13:37:50,255> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: USER, reply:
                              331 Password required for myuser.

                              <2009-06-02 13:37:50,255> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host myHost FTP command: PASS
                              <2009-06-02 13:37:50,255> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: PASS, reply:
                              230 User myuser logged in.

                              <2009-06-02 13:37:50,255> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTPAgent::absoluteFilePath called with[Cashier], file=[PGLINEAS1-090508133556.txt]
                              <2009-06-02 13:37:50,255> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host myHost FTP command: PASV
                              <2009-06-02 13:37:50,255> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: PASV, reply:
                              227 Entering Passive Mode (192,168,0,150,4,46).

                              <2009-06-02 13:37:50,255> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Passive: ip = 192.192.0.192, port = 1070
                              <2009-06-02 13:37:50,255> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Connecting to myHost:1070
                              <2009-06-02 13:37:50,255> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host myHost FTP command: TYPE I
                              <2009-06-02 13:37:50,255> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: TYPE, reply:
                              200 Type set to I.

                              <2009-06-02 13:37:50,271> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host myHost FTP command: RETR Cashier\PGLINEAS1-090508133556.txt
                              <2009-06-02 13:37:50,271> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: RETR, reply:
                              125 Data connection already open; Transfer starting.

                              <2009-06-02 13:37:50,287> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Control socket being read by [AJPRequestHandler-HTTPThreadGroup-64]
                              <2009-06-02 13:37:50,380> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Control socket read failed by [AJPRequestHandler-HTTPThreadGroup-64] DATA=[TIMEDOUT] in [93 msecs]
                              <2009-06-02 13:37:50,380> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Returning local file: mDGwM+l2LhBE8Qq9VFaD1Q== Path: F:\product\10.1.3.1\OracleAS_1\j2ee\home\fileftp\temp_ftp\localhost_default_BPEL_REGISTRO_COB~1.0_\outbound\mDGwM+l2LhBE8Qq9VFaD1Q==
                              <2009-06-02 13:37:50,427> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Created translator : oracle.tip.pc.services.translation.xlators.nxsd.NXSDTranslatorImpl@112ff56
                              <2009-06-02 13:37:50,459> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Completed translation for : Cashier\PGLINEAS1-090508133556.txt

                              Thank you...

                              Edited by: user10655677 on Jun 2, 2009 9:57 AM
                              • 12. Re: FTP Adapter Error time out
                                Akei
                                Please I need your help I am new to this and want to make this project possible as soon as I have already searched the documentation and forums but I can not find anything to tell me what the problem is ?: |
                                • 13. Re: FTP Adapter Error time out
                                  James Taylor-Oracle
                                  it looks to be an issue with the directory. I believe it is not finding anything to pick up.

                                  When you set delete file to true, does the file get deleted?

                                  Your sync read is reading a completely different directory, can you use this one for testing?

                                  changing directories in windows can have troubles. e.g. if you login to c:\home and you cd to d:\home, the result is you stay in c:\home.

                                  So when you ftp to the remote machine (manually) what is that directory? is it the same drive as the source directory?

                                  can you specify the physical directory to / and use that home directory as the polling directory just to test polling works, then we can work on changing directories.

                                  cheers
                                  James
                                  • 14. Re: FTP Adapter Error time out
                                    Akei
                                    Hi

                                    The files for these exercises are the same therefore are under the same directory, the only difference is that the method to sync read, the directory I send as a parameter and by the Get the directory is from the LogicalDirectory.

                                    When I change to Delete = true apparently does not recognize the files in the directory because it's not erasing.

                                    I have full access to the FTP server in the path C:\pub\cashier so it can be tested

                                    FTP files whenever a post in the same path C:\pub\cashier.

                                    The route is not established with the a / because the SO by the server FTP is Windows then I think it must be \


                                    Tnks

                                    Edited by: user10655677 on 2/06/2009 04:48 PM
                                    1 2 3 Previous Next