Applications Interconnect: FTP adapter does not receive files.

From: Tvda <tvda1_at_strandassociates.com>
Date: Fri, 01 Aug 2003 09:07:10 GMT
Message-ID: <25qWa.43985$F92.4492@afrodite.telenet-ops.be>

Hi,

I have an interconnect project that ties together an Oracle DB and an FTP server.
In the project I have created 2 events, 1 that signals a change in the database and 1 that signals a change in the app behind the FTP server. both events are published by the relevant applications and subscribed to by their counterparts.
Everything works as expected when going from the database to the FTP server. The reverse, however, does not work at all. The FTP adapter insists that the message queue is empty despite the fact that there are files present. the adapter is correctly configured in that it can access the incoming and outgoing folders and is able to create files in the incoming folder.

I've run out of things to try and it still doesn't work, hence this post.

Can anyone shed some light on this and suggest a solution? Or a reference where some good documentation can be found about these topics?

Thanks a lot in advance.

Thierry

FTP trace:
220 set Microsoft FTP Service (Version 5.0). USER anonymous
331 Anonymous access allowed, send identity (e-mail name) as password. PASS *****
230 Anonymous user logged in.
PASV
227 Entering Passive Mode (192,168,0,3,12,193). NLST /outgoing
125 Data connection already open; Transfer starting. 226 Transfer complete.

response data is:
/outgoing/FTPAPP\r\n/outgoing/FTPAPP123.xml\r\n/outgoing/test.xml\r\n

the contents of the directory outgoing are: outgoing (dir)
FTPADD (dir)
  FTPAPP001.xml
  new msg.xml
  FTPAPPnull-0102340
FTPAPP123.xml
test.xml

adapter ini settings are:
// *************
// ** Adapter **
// *************

application=FTPAPP
bridge_class=oracle.oai.agent.adapter.technology.TechBridge ota.type=XML

//------------------------------------------
// FTP Adapter Endpoint information
//-------------------------------------------

ota.send.endpoint=ftp://set/incoming
ota.receive.endpoint=ftp://set/outgoing
file.sender.user=anonymous
encrypted_file.sender.password= ****

file.sender.type=ascii
file.receiver.user=anonymous
file.receiver.password=****
file.receiver.type=ascii
file.receiver.polling_interval=60000
file.receiver.max_msgs_retrieved=30

ota.d3ls=

// *************
// ** Agent ***
// *************

agent_log_level=2
agent_subscriber_name=FTPAPP
agent_message_selector=recipient_list like '%,FTPAPP,%'
agent_tracking_enabled=true
agent_throughput_measurement_enabled=true
agent_use_custom_hub_dtd=false
agent_metadata_caching=demand
agent_dvm_table_caching=demand
agent_lookup_table_caching=demand
agent_delete_file_cache_at_startup=false
agent_max_ao_cache_size=200
agent_max_co_cache_size=100
agent_max_message_metadata_cache_size=200
agent_max_dvm_table_cache_size=200
agent_max_lookup_table_cache_size=200
agent_max_queue_size=1000
agent_Persistence_queue_size=1000
agent_persistence_cleanup_interval=60000
agent_persistence_retry_interval=60000



// *************

// ** Service **
// *************

service_path=D:\oracle\oraDBadapter\jdk\jre\bin;D:\oracle\oraDBadapter\jdk\j re\bin\hotspot;D:\oracle\oraDBadapter\bin

service_classpath=;D:\oracle\oraDBadapter\oai\9.0.2\lib\oai.jar;D:\oracle\or aDBadapter\jdk\jre\lib\i18n.jar;D:\oracle\oraDBadapter\jdbc\lib\classes12.ja r;D:\oracle\oraDBadapter\jdbc\lib\nls_charset12.jar;D:\oracle\oraDBadapter\r dbms\jlib\aqapi.jar;D:\oracle\oraDBadapter\rdbms\jlib\jmscommon.jar;D:\oracl

e\oraDBadapter\lib\xmlparserv2.jar;D:\oracle\oraDBadapter\lib\vbjorb.jar;D:\
oracle\oraDBadapter\lib\vbjapp.jar;D:\oracle\oraDBadapter\oai\9.0.2\lib\User
DefinedTransforms.jar;D:\oracle\oraDBadapter\jlib\repository.jar;D:\oracle\o

raDBadapter\jlib\javax-ssl-1_2.jar

service_class=oracle/oai/agent/service/AgentService

service_max_heap_size=536870912

service_num_vm_args=1
service_jdk_version=jdk1.3.1
service_jdk_dll=jvm.dll
service_vm_arg1=ORBdisableLocator=true

Received on Fri Aug 01 2003 - 04:07:10 CDT