Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OSB - Unable to retrieve files from freeSSHd (built-in SFTP server)

744924Jan 7 2010 — edited Jan 7 2010
the OSB version is 10gR3(10.3.1.0) with weblogic server 10gR3 and oracle workshop 10gR3 on Windows Vista Business Edition.

I have written a OSB proxy service that retrieve data using user authentication(username-password) from freeSSHd and I have configured SSH for freeSSHd and OSB correctly, but the proxy service never finds any files and there isn't any error/exception in server console.
I see following log of the sftp server:
01-07-2010 13:19:52 IP 127.0.0.1 SSH connection attempt.
01-07-2010 13:19:52 IP 127.0.0.1 SSH stars21ei successfully logged on using password.
01-07-2010 13:19:52 SFTP service granted to user stars21ei.
01-07-2010 13:19:52 IP 127.0.0.1 stars21ei is listing /preLodgmentValidationBatch/ (D:\sftproot\preLodgmentValidationBatch\)
01-07-2010 13:19:54 IP 127.0.0.1 SSH connection attempt.
01-07-2010 13:19:54 IP 127.0.0.1 SSH stars21ei successfully logged on using password.
01-07-2010 13:19:54 SFTP service granted to user stars21ei.
01-07-2010 13:19:54 IP 127.0.0.1 stars21ei is listing /preLodgmentValidationBatch/ (D:\sftproot\preLodgmentValidationBatch\)
01-07-2010 13:19:57 IP 127.0.0.1 SSH connection attempt.
01-07-2010 13:19:57 IP 127.0.0.1 SSH stars21ei successfully logged on using password.
01-07-2010 13:19:57 SFTP service granted to user stars21ei.
01-07-2010 13:19:57 IP 127.0.0.1 stars21ei is listing /preLodgmentValidationBatch/ (D:\sftproot\preLodgmentValidationBatch\)
01-07-2010 13:19:57 IP 127.0.0.1 stars21ei is listing /preLodgmentValidationBatch/ (D:\sftproot\preLodgmentValidationBatch\)
01-07-2010 13:19:57 IP 127.0.0.1 SSH stars21ei disconnected.

The files are in the "preLodgmentValidationBatch" directory for the user, so I am certain that it isn't a pathing issue. I'm just running out of ideas.

it seems that the proxy service can lists the directory on the sftp server, but can't finds any files (actully, there are several files in the directory) and then retry 3 times.

Some questions I have are:
1. has anyone experienced/resolved this issue before?
2. Is there any way to see osb logs?
3. Is it bug of OSB 10gR3(10.3.1.0)?

btw, I have also written a business service that put data to the same sftp server. it works rightly.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2010
Added on Jan 7 2010
2 comments
1,577 views