Cleo Lexicom 3.0.12 Phantom Postings

[bfolan]

I am having an issue with orders posting to the application via
http://hostname/GC3/glog.integration.servlet.WMServlet
the XML was sent to post using Cleo. Cleo “received” a message of a successful post (200 confirmation) without a transmission number, yet OTM never saw any evidence of it arriving. OTM does not have a record in the i_transaction, i_transmission, or any other tables. Has anyone had an issue with transactions receiving a confirmation acknowledgement from OTM without a record within OTM or with Cleo?

I am able to post through a different method correctly but would like to transfer all the integration postings using the Cleo integration software.

[chrisplough]

Re: Cleo Lexicom 3.0.12 Phantom Postings

Unfortunately, I haven't seen this in the past and haven't used the Cleo integration software.

Just from a troubleshooting perspective, though, I'd recommend testing using some simple scripts and determining whether the transmission number is returned and whether the integration is posted to the tables you mentioned in OTM. Here's some posted earlier to the forums:

http://www.otmfaq.com/forums/f24/script-testing-integration-mw-otmpostwmservlet-pl-213/

Assuming they work, I'd believe the issue is either within the Cleo software, or an incompatibility between the two. The latter would be odd, however, as it's simply an HTTP post with an ack -- not much can go wrong there.

Now, playing devil's advocate and looking at this from the OTM side, the OTM web server is going to accept the integration, do some initial verification (just XML syntax), then pass it back to the OTM app server. The app server immediately persists it to the DB and then (when a thread is available) reads it back and processes it. If the web and app servers were out-of-sync, this may cause an issue similar to what you described. Have you restarted OTM since beginning testing? Just for normal sanity testing - are the OTM web and app tiers on the same platform and JDK? Are they also at the same patch level? I'm sure these last questions are all okay, but I have to ask anyways.

--Chris