1 2 3 Previous Next 34 Replies Latest reply on Jun 5, 2009 9:43 PM by James Taylor-Oracle Go to original post
      • 15. Re: FTP Adapter Error time out
        Akei
        This is my oc4j-ra.xml

        <?xml version="1.0"?>

        <oc4j-connector-factories xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://www.oracle.com/technology/oracleas/schema/oc4j-connector-factories-10_0.xsd" schema-major-version="10" schema-minor-version="0">

        <imported-shared-libraries>
        <import-shared-library name="oracle.bpel.common"/>
        <import-shared-library name="oracle.xml"/>
        </imported-shared-libraries>

             <connector-factory location="eis/Ftp/FtpAdapter" connector-name="Ftp Adapter">
                  <config-property name="host" value="MyHost"/>
                  <config-property name="port" value="21"/>
                  <config-property name="username" value="myUser"/>
                  <config-property name="password" value="p@ss"/>
                  <config-property name="serverType" value="win"/>
                  <config-property name="ftpAbsolutePathBegin" value="\"/>
                  <config-property name="ftpPathSeparator" value="\"/>
             </connector-factory>
        </oc4j-connector-factories>

        thanks
        Akei
        • 16. Re: FTP Adapter Error time out
          James Taylor-Oracle
          your connectivity is fine as you can see in the log you have posted.

          there does seem to be a difference in the sync read and the poll, e.g. the synch read is pointing to Cashier, and the poll is pointing to c:\pub\cashier

          Please note that the directory is case sensitive, so change the poll to Cashier

          also can you tell me the home directory when you login via ftp manually.

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

            I Change directory to the Cashier and "/", now I can access the files but now I'm enviendo the following error:

            <2009-06-02 22:34:14,482> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Validating Input dir : Cashier
            <2009-06-02 22:34:14,482> <INFO> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Managed Connection Created
            <2009-06-02 22:34:14,482> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Adding Event Listener
            <2009-06-02 22:34:14,482> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Creating Connection
            <2009-06-02 22:34:14,482> <INFO> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Connection Created
            <2009-06-02 22:34:14,482> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Connection manager allocated connection :oracle.tip.adapter.ftp.FTPConnection@f9276e
            <2009-06-02 22:34:14,482> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host name is 'MyHost'.
            <2009-06-02 22:34:14,482> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Reading reply from MyHost
            <2009-06-02 22:34:14,482> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: USER MyUser
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: USER, reply:
            331 Password required for MyUser.

            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: PASS
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: PASS, reply:
            230 User MyUser logged in.

            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTPAgent::absoluteDirPath called with[Cashier], Absolute Path Begin=[]
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: PWD
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: PWD, reply:
            257 "/" is current directory.

            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTPAgent::absoluteDirPath with pwd=[]
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: PWD
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: PWD, reply:
            257 "/" is current directory.

            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTPAgent::validateInputDir will change dir to [Cashier]
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: CWD /Cashier
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: CWD, reply:
            250 CWD command successful.

            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: CWD /
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: CWD, reply:
            250 CWD command successful.

            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTPAgent::validateInputDir reverted back to []
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Sending event: 1 with: oracle.tip.adapter.ftp.FTPConnection@f9276e
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTPManagedConnection::destroy called, closing physical socket
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Clearing Event Listeners
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Validated Input dir : Cashier
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <AdapterFramework::Inbound> onAlert: sent alert <<

            Recovered after error: ORABPEL-11430
            Error in listing files in the remote directory.
            Unable to list file in remote directory.
            Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.
            . Resuming normal operation.
            to BPEL process.
            <2009-06-02 22:34:14,497> <INFO> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Managed Connection Created
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Adding Event Listener
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Creating Connection
            <2009-06-02 22:34:14,497> <INFO> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Connection Created
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Connection manager allocated connection :oracle.tip.adapter.ftp.FTPConnection@257f82
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host name is 'MyHost'.
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Reading reply from MyHost
            <2009-06-02 22:34:14,497> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: USER MyUser
            <2009-06-02 22:34:14,513> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: USER, reply:
            331 Password required for MyUser.

            <2009-06-02 22:34:14,513> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: PASS
            <2009-06-02 22:34:14,513> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: PASS, reply:
            230 User MyUser logged in.

            <2009-06-02 22:34:14,513> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: PWD
            <2009-06-02 22:34:14,513> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: PWD, reply:
            257 "/" is current directory.

            <2009-06-02 22:34:14,513> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> NLST received a relative path with pwd=[]
            <2009-06-02 22:34:14,513> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Absolute Dir from Relative Path=[Cashier]
            <2009-06-02 22:34:14,513> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: PASV
            <2009-06-02 22:34:14,513> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: PASV, reply:
            227 Entering Passive Mode (192,168,0,150,6,132).

            <2009-06-02 22:34:14,513> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Passive: ip = 192.192.0.192, port = 1668
            <2009-06-02 22:34:14,513> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Connecting to MyHost:1668
            <2009-06-02 22:34:14,513> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: NLST /Cashier
            <2009-06-02 22:34:14,529> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: NLST, reply:
            125 Data connection already open; Transfer starting.

            <2009-06-02 22:34:14,529> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Timestamp from fileInfo=[0]
            <2009-06-02 22:34:14,529> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host name is 'MyHost'.
            <2009-06-02 22:34:14,529> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Reading reply from MyHost
            <2009-06-02 22:34:14,529> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: USER MyUser
            <2009-06-02 22:34:14,529> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: USER, reply:
            331 Password required for MyUser.

            <2009-06-02 22:34:14,529> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: PASS
            <2009-06-02 22:34:16,263> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: PASS, reply:
            230 User MyUser logged in.

            <2009-06-02 22:34:16,263> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: PASV
            <2009-06-02 22:34:16,263> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: PASV, reply:
            227 Entering Passive Mode (192,168,0,150,6,133).

            <2009-06-02 22:34:16,263> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Passive: ip = 192.192.0.192, port = 1669
            <2009-06-02 22:34:16,263> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Connecting to MyHost:1669
            <2009-06-02 22:34:16,263> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Host MyHost FTP command: LIST /Cashier/CAJERO10-090508123233.txt
            <2009-06-02 22:34:16,263> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTP Command: LIST, reply:
            125 Data connection already open; Transfer starting.

            <2009-06-02 22:34:16,263> <WARN> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTPClient.getLIST(): unexpected 125 is encountered.
            <2009-06-02 22:34:16,263> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Control socket being read by [JCA-work-instance:FTP Adapter-6]
            <2009-06-02 22:34:16,372> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Control socket read failed by [JCA-work-instance:FTP Adapter-6] DATA=[TIMEDOUT] in [109 msecs]
            <2009-06-02 22:34:16,372> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Exception while logging out
            <2009-06-02 22:34:16,372> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound>
            java.net.SocketException: Socket is closed
                 at java.net.Socket.getInputStream(Socket.java:753)
                 at oracle.tip.adapter.ftp.FTP.sendCommand(FTP.java:585)
                 at oracle.tip.adapter.ftp.FTP.sendCommand(FTP.java:553)
                 at oracle.tip.adapter.ftp.FTP.quit(FTP.java:1065)
                 at oracle.tip.adapter.ftp.FTPClient.logout(FTPClient.java:1852)
                 at oracle.tip.adapter.ftp.inbound.FTPSource.getTimestamp(FTPSource.java:1004)
                 at oracle.tip.adapter.file.inbound.FileList.isMinimumAgePeriod(FileList.java:453)
                 at oracle.tip.adapter.file.inbound.FileList.ignoreFile(FileList.java:488)
                 at oracle.tip.adapter.ftp.FTPClient.listFiles(FTPClient.java:1060)
                 at oracle.tip.adapter.ftp.FTPAgent.getFileList(FTPAgent.java:348)
                 at oracle.tip.adapter.file.inbound.FileSource.getFileList(FileSource.java:215)
                 at oracle.tip.adapter.file.inbound.PollWork.pollFiles(PollWork.java:254)
                 at oracle.tip.adapter.file.inbound.PollWork.run(PollWork.java:144)
                 at oracle.tip.adapter.fw.jca.work.WorkerJob.go(WorkerJob.java:51)
                 at oracle.tip.adapter.fw.common.ThreadPool.run(ThreadPool.java:280)
                 at java.lang.Thread.run(Thread.java:595)

            <2009-06-02 22:34:16,372> <ERROR> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Could not get file modification time for : CAJERO10-090508123233.txt
            <2009-06-02 22:34:16,372> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Control socket being read by [JCA-work-instance:FTP Adapter-6]
            <2009-06-02 22:34:16,372> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Sending event: 1 with: oracle.tip.adapter.ftp.FTPConnection@257f82
            <2009-06-02 22:34:16,372> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> FTPManagedConnection::destroy called, closing physical socket
            <2009-06-02 22:34:16,372> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Clearing Event Listeners
            <2009-06-02 22:34:16,372> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Error retrieving polled files.
            <2009-06-02 22:34:16,372> <DEBUG> <default.collaxa.cube.activation> <FTP Adapter::Inbound>
            ORABPEL-11430
            Error in listing files in the remote directory.
            Unable to list file in remote directory.
            Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.

                 at oracle.tip.adapter.ftp.FTPAgent.getFileList(FTPAgent.java:356)
                 at oracle.tip.adapter.file.inbound.FileSource.getFileList(FileSource.java:215)
                 at oracle.tip.adapter.file.inbound.PollWork.pollFiles(PollWork.java:254)
                 at oracle.tip.adapter.file.inbound.PollWork.run(PollWork.java:144)
                 at oracle.tip.adapter.fw.jca.work.WorkerJob.go(WorkerJob.java:51)
                 at oracle.tip.adapter.fw.common.ThreadPool.run(ThreadPool.java:280)
                 at java.lang.Thread.run(Thread.java:595)
            Caused by: ORABPEL-11400
            Failed to get file modification time.
            Could not get file modification time for file :/Cashier/CAJERO10-090508123233.txt. Verify that the values for the "ModificationTimeFormat" activation parameter are correct.Ensure the time format pattern and filename begin index and end index are specified according to the specific FTP server.
            Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.

                 at oracle.tip.adapter.ftp.inbound.FTPSource.getTimestamp(FTPSource.java:1031)
                 at oracle.tip.adapter.file.inbound.FileList.isMinimumAgePeriod(FileList.java:453)
                 at oracle.tip.adapter.file.inbound.FileList.ignoreFile(FileList.java:488)
                 at oracle.tip.adapter.ftp.FTPClient.listFiles(FTPClient.java:1060)
                 at oracle.tip.adapter.ftp.FTPAgent.getFileList(FTPAgent.java:348)
                 ... 6 more

            <2009-06-02 22:34:16,372> <INFO> <default.collaxa.cube.activation> <FTP Adapter::Inbound> Poller raising Alert for exception : ORABPEL-11430
            Error in listing files in the remote directory.
            Unable to list file in remote directory.
            Check the error stack and fix the cause of the error. Contact oracle support if error is not fixable.

            is a little big but I hope is clear

            Tnks
            • 18. Re: FTP Adapter Error time out
              James Taylor-Oracle
              What do you mean by now I can access files. Does this mean that one file is loaded then starts to fail?

              Are you using the delete file option, if not it looks like you have specified a wrong data format to compare date time stamps.

              Also can you set the search criteria to *

              cheers
              James
              • 19. Re: FTP Adapter Error time out
                Akei
                I mean who is accessing the files are located on the FTP Server because CAJERO10-090508123233.txt inside the folder to which I am doing the polling. after seeking information when it fails.

                yes, I am currently using the

                DeleteFile="true"
                IncludeFile = ".* \. txt"

                and

                <service name="FTP_Polling">
                <port name="Get_pt" binding="tns:Get_binding">
                <jca:address location="eis/Ftp/FtpAdapter" UIincludeWildcard="*.txt" />
                </ port>
                </ service>

                and now the error is:

                Verify that the values for the "ModificationTimeFormat" activation parameter are correct.Ensure the time format pattern and filename begin index and end index are specified according to the specific FTP server

                How can I set the date time stamps?

                Tanks

                Edited by: Akei on 2/06/2009 07:44 PM
                • 20. Re: FTP Adapter Error time out
                  James Taylor-Oracle
                  You are losing me here. I don't understand your question.

                  The user accessing the file is the user defined in the eis/Ftp/FtpAdapter connection pool. Does that answer you question

                  can you please provide or do the following:

                  1) When you test this manually (not using BPEL) what is the directory when you login?
                  2) Set the search to *
                  3) What is the directory you are reading from?

                  cheers
                  James
                  • 21. Re: FTP Adapter Error time out
                    Akei
                    When I loggin on a server, I do in

                    ftp:\\192.192.0.192-Cashier

                    The search is in *.txt

                    And the I am reading the directory Cashier

                    Actually is taking the correct user defined in the EIS / ftp / FtpAdapter, I had no doubts about the data that the user is logged.

                    Tnks

                    Edited by: Akei on 2/06/2009 08:12 PM
                    • 22. Re: FTP Adapter Error time out
                      James Taylor-Oracle
                      unfortunately this doesn't answer any of my questions

                      1) Are you saying the directory when you login is 192.192.0.192-Cashier, I thought you were connecting to a windows FTP server, I was expecting something like c:\home. I need to know the exact case.
                      2) I can see that you have set it to *.txt, but I want you to try *
                      3) I was expecting a directory something like c:\home\Cashier, Cashier doesn't help me understand your environment. I need to know the exact case.

                      I agree 100% connectivity is not an issue, the issue is with the polling location. This is what I'm trying to help you with, but to do this I need to understand your environment.

                      cheers
                      James
                      • 23. Re: FTP Adapter Error time out
                        Akei
                        I am sorry

                        The directory is: C:\Inetpub\ftproot\cashier and the Logical Directory is Cashier. I connecting to a windows FTP server.
                        but when I do it manually logging the way:

                        ftp: \ \ 192.192.0.192-Cashier

                        The directory to which I want to do the polling is: Cashier

                        I hope that this will clearly understand my environment.

                        Tnks
                        • 24. Re: FTP Adapter Error time out
                          Akei
                          Hi JDT

                          I have solved my problem, sent you a cheklist the changes:
                          I add the FileModificationTime = "FileSystem" and ModificationTimeFormat = "4.18, YYYYMMDDH into the operation (when I add these two parameters worked)

                          <jca:operation FileType="ascii"
                          PhysicalDirectory="Cashier"
                          ActivationSpec="oracle.tip.adapter.ftp.inbound.FTPActivationSpec"
                          ExcludeFiles=".*corte.*\.txt"
                          DeleteFile="true"
                          PollingFrequency="100"
                          MinimumAge="0"
                          FileModificationTime="FileSystem"
                          ModificationTimeFormat="4,18,yyyyMMddHHmmSS"
                          OpaqueSchema="false"/>
                          <input>

                          I set property into activationAgent

                          <activationAgent className="oracle.tip.adapter.fw.agent.jca.JCAActivationAgent" partnerLink="FTPPolling">
                          <property name="portType">Get_ptt</property>
                          <property name="Cashier">Cashier</property>
                          </activationAgent>

                          and my oc4j-ra.xml is like:

                          <?xml version="1.0"?>

                          <oc4j-connector-factories xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://www.oracle.com/technology/oracleas/schema/oc4j-connector-factories-10_0.xsd" schema-major-version="10" schema-minor-version="0">

                          <imported-shared-libraries>
                          <import-shared-library name="oracle.bpel.common"/>
                          <import-shared-library name="oracle.xml"/>
                          </imported-shared-libraries>

                               <connector-factory location="eis/Ftp/FtpAdapter" connector-name="Ftp Adapter">
                                    <config-property name="host" value="MyHost"/>
                                    <config-property name="port" value="21"/>
                                    <config-property name="username" value="MyUser"/>
                                    <config-property name="password" value="P@ss"/>
                                    <config-property name="serverType" value="win"/>
                                    <config-property name="ftpAbsolutePathBegin" value="/"/>
                                    <config-property name="ftpPathSeparator" value="/"/>
                               </connector-factory>
                          </oc4j-connector-factories>


                               
                          Now, how can I put my time in SOA application server? that is currently ahead by 5 hours but I do not know where that can take hours because the server time is correct
                               
                          Many many thanks for your help
                          Greetings

                          Edited by: Akei on 3/06/2009 12:05 PM
                          • 25. Re: FTP Adapter Error time out
                            James Taylor-Oracle
                            I'm glad you got it working, generally you shouldn't need the ModificationTimeFormat and FileModificationTime when you are deleting the file, were you making these changes via the adapter wizard, or wsdl direct?

                            The SOA Suite gets it time form the system clock. There is an issue with daylight savings but this is only an hour.

                            Can you explain where you are seeing the 5 hour difference? e.g. when you create a BPEL process in the Console it it 5 hours out?

                            Also is the database on a different machine, if so what is the clock on that?

                            cheers
                            James
                            • 26. Re: FTP Adapter Error time out
                              Akei
                              I did the change directly in the wsdl.

                              The installation of the SOA database and application server are on the same machine, I checked the time of the database and system, and both are correct, I can see the difference when it creates an instance of a BPEL process and thus the logs, this is important because if my FTP server and the server are not synchronized in time I will create problems to the minimum period Avalide age of files.

                              greetings
                              • 27. Re: FTP Adapter Error time out
                                James Taylor-Oracle
                                what is the timezone of the OS and the db are they the same?

                                cheers
                                James
                                • 28. Re: FTP Adapter Error time out
                                  Akei
                                  the server:

                                  (GMT-06:00) Guadalajara, Mexico City, Monterrey - New

                                  and the DB I run the query:

                                  select DBTIMEZONE from dual


                                  DBTIMEZONE
                                  ----------
                                  +00:00


                                  select systimestamp from dual


                                  SYSTIMESTAMP
                                  -------------
                                  03/06/09 16:34:15.948000000 -05:00


                                  Tnks

                                  Edited by: Akei on 3/06/2009 05:36 PM
                                  • 29. Re: FTP Adapter Error time out
                                    James Taylor-Oracle
                                    Is that the right timezone for your location?

                                    what is the result of this select
                                    SELECT to_char(sysTIMESTAMP,'HH24:MI:SS.FF')
                                    ,to_char(LOCALTIMESTAMP,'HH24:MI:SS.FF')
                                    ,to_char(current_TIMESTAMP,'HH24:MI:SS.FF')
                                    FROM dual;
                                    cheers
                                    James