AF/IE retrieve Message Status

[Former Member]

We´ve developed a own Adapter for PI.

When wie send the Message to IntegrationEngine we have to check the Message Status on Integration Engine and send ack back to caller if status was ok or send error back if status was nok.

Is it posible to retrieve a mapping or message status information from Integrationengine in adapter?

[Former Member · Accepted solution]

Hi

SXMSPMAST table gives you the MSGSTATE, check if you can access this to get the required info.

However you can type SXMS* & press F4 in SE16 / SE11 to see various tables which are suitable to be used for your scenario

Regards

Vishnu

[Former Member]

ok thx was helpfull.

But how it looks like with Acknowledgement-Messages?

http://help.sap.com/saphelp_nwpi71/helpdata/de/29/345d3b7c32a527e10000000a114084/frameset.htm

How can i request a Acknowledge in my Adapter?

This could also solve my Problem and it is a PI integrated szenario.

[Former Member]

ok, this could be one solution, but in this case i am need a connection maybe via jdbc to database get the message via messageid an check the status, right?

But does PI Proviedes a API for those cases?

Or is there a other recommended solution?

[aashish_sinha]

Hi,

>> ok, this could be one solution, but in this case i am need a connection maybe via jdbc to database get the message via messageid an check the status, right?

No. You need to write one RFC which will fetch data from these tables and send response back to your XI/PI systems. Provide the proper input to that RFC and response also.

For connection, create an RFC destination and import your RFC to Integration Builder and use it for your purpose.

Regards

Aashish Sinha

[Former Member]

Hi

Not by JDBC but You need to explore the possibilities of Sap JCo

check these links for information & APIs

http://help.sap.com/saphelp_nw04/helpdata/en/09/a4a9e1d51d11d6b2c200508b5d5c51/frameset.htm

/people/alessandro.guarneri/blog/2008/09/15/xipi-message-payload-from-java

http://help.sap.com/saphelp_nw04/helpdata/en/e2/e13fcd80fe47768df001a558ed10b6/frameset.htm

Regards

Vishnu

[Former Member]

no idea?

[aashish_sinha]

Hi,

have a look into these tables and structure in Se16 and SE11.

SMPPMAP3 Mapping Runtime: Mapping

SMPPREL3 Mapping Runtime: Mapping Relation

SMPPSPLIT XI Mapping: Merge and Split

You can retrieve data for a particular mapping from these tables.Lets check if it is useful for you.

Regards

Aashish Sinha