otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
MavenWire


Integration and Data Mapping Integrating OTM / G-Log with external and legacy systems - including XML, WebServices, SOA, ESB, BPEL, EDI and Oracle's Fusion.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old January 15th, 2008, 18:08
Junior Member
 
Join Date: Dec 2007
Posts: 2
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
psantosb is on a distinguished road
Integration issues - httppost

Hello everyone,

I'm new at OTM and I am working in a project to implement OTM for a logistics department. I have read some documents and manuals but I'm afraid I need some help with OTM integration using httppost strategy.

What I'm trying to do, is implementing an interface that keeps OTM sincronized with an external system via httpost in "real-time" (sending xml messages based on GlogXMLSchema.xsd).

In order to achive that, I was planning to establish this two procedures:
A.Incomming data into OTM (from external system)
A.1- External system performs httppost and sends valid xml to OTM
A.2- OTM processes xml file
A.3- OTM sends Report back to external system
A.4- External systems gets the transmission report
A.5- If Report is succesfull external systems commits changes in its DB, otherwise it rolls back changes.

So far, I have managed to send and process xml files properly but I couldn't get any Report back to the external system. It seems OTM is "generating" the report, but the xml file is not reaching the external system. Any suggestions on how to catch that report? (step A.4).

B.Outbound data from OTM to external system
B.1- OTM sends a xml file to the external system: a "before persist Modification-event" placed on an OTM object triggers an agent that executes a "Send-integration" action.
B.2- External system receives the xml file and processes it.
B.3- External system sends back to OTM a Transmission status (success or error)
B.4- OTM commits or rolls back the modifications depending on the status received.

For this one, I'm having problems at step B.3: Send-integration action always seems to finish successfully (even though the external system returns an error status) so I can't manage to interrupt the agent and do rollback.
Besides I couldn't find a way to inform of an error through the GUI (in order to let the user know the operation was aborted).

I would really appreciate if anybody could advice me on this, not only on the particular issues but also on the overall interface strategy.

Thank you very much for your help!!!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old October 30th, 2009, 11:55
Junior Member
 
Join Date: Aug 2009
Posts: 21
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
kkchopra is on a distinguished road
Re: Integration issues - httppost

Hi,

I am also new to OTM...Could please share some technical details about your project here.
I would like to implement the same stuff but need some tips to really achieve this.

Thanks,
Kamleshwar
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old November 20th, 2009, 20:07
Junior Member
 
Join Date: Dec 2007
Posts: 2
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
psantosb is on a distinguished road
Re: Integration issues - httppost

Hello,
I'm sorry, I'm afraid I'm not into OTM any more.
I used the strategy described in my post but had to rearrange certain things in order to avoid the mentioned restrictions (totally asincronous interface and no way of posting messages through GUI to the user).
Try reading the OTM integration manual.
Good luck.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old November 24th, 2009, 22:27
Junior Member
 
Join Date: Nov 2009
Posts: 3
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
mahianipav is on a distinguished road
Re: Integration issues - httppost

Hi Guru,

We are doing EBS to OTM integration.
As a process we deployed all the seeded BPELs into new domain.
But, when seeded BPEL process trying to access OTM Integration servlet, we are getting the following issue.

The bpel is using the http post and it is trying to access the following URL
"http://afsmlnx04.rheem.com:8050/GC3/glog.integration.servlet.WMServlet"
and we are getting the following error
"<fault> - <bindingFault xmlns="http://schemas.oracle.com/bpel/extension"> - <part name="summary"> <summary> com.collaxa.cube.ws.wsif.providers.http.WSIFOperat ion_HTTP@19fe9e4 : Could not invoke 'process'; nested exception is:

java.net.ConnectException: Connection refused

</summary>


</part>
- <part name="detail"> <detail>java.net.ConnectException: Connection refused</detail>


</part>

</bindingFault>

</fault>


It seems the http servlet is rejecting the request.
Please guide me to resolve that issue.

Thanks in advance,
Mahesh G.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
TransmissionReport form Invoice insert via HTTPPOST darkside32 Integration and Data Mapping 2 July 13th, 2009 16:25
Issues with PC*MILER Max76 Integration and Data Mapping 6 August 8th, 2008 13:55
Favourite Issues With OTM ianlo Share Oracle Enchancements, Issues and Bugs 3 July 21st, 2008 03:08
FTI on sun solaris issues banerjeemnmims Hardware and Platforms 1 April 3rd, 2008 15:40
Issues with our OTM Env...PL HELP !!! mnlv00 Database Administration 3 March 25th, 2008 11:14



All times are GMT. The time now is 21:45.
Copyright © 2006-2009, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40