How to get the StatusText from XMII_JCOMESSAGES Table

[Former Member]

Hi all,

I need to show the Status as well as StatusText from XMII_JCOMESSAGES table for a particular message in a custom User Interface. I have checked through Read Message action block and Query Message action block. Read Message action block returns two XML structure like JCOMessage and MessageDocumentXML. JCOMessage xml does not contain the StatusText field. The structure of JCOMessage is like

<JCOMessage>

<MessageId/>

<JcoServerName/>

<MessageName/>

<Category/>

<MessageType/>

<Status/>

<DocNumber/>

<DocCount/>

<Function/>

<PacketID/>

<ProcessingTimeStamp/>

<ReceivedTime/>

</JCOMessage>

But I have checked the XMII_JCOMESSAGES table from NWA and the structure of XMII_JCOMESSAGES table is

MESSAGEID

RECEIVEDDATETIME

JCOSERVERID

MESSAGETYPE

MESSAGENAME

PROCESSINGDATETIME

DOCNUMBER

DOCXML

CATEGORY

PACKETID

STATUS

STATUSTEXT

SERVER

So, how can I fetch the STATUSTEXT field. Can anybody help me.

Thanks in advance

Chandan

[Former Member]

Set up af dataserver connection to the NW database and create a query to fetch the status text column?

[former_member206397]

Hi Jens,

Thanks for your reply. We can do by using dataserver connection to the NW database but is it the recomended way to interact with XMII_JCOMESSAGES table. I think using action block or using any Illuminator service is the recomended way and that's why SAP provided the Read Message, QueryMessage, Update Message, Delete message action blocks to interact with XMII_JCOMESSAGES table.

Thanks

Chandan

[jcgood25]

Aside from the Update Message block status text (integer values 1 - 4 coincide with the options in the drop down box on the configure dialog) that you can see in the link editor, you may need to use the Message Monitor status flag on the web page to determine what the number means in relation to friendly status text.

Probably worth logging a ticket for consideration to add this into the actions. I would assume this string might be translated into a local languague for the user but I'm not sure.

[Former Member]

FWIW I think the only time this text isn't the standard ( Running, Processed etc) is when you fail the mapped transaction with a terminate action.

[former_member4529]

Hi,

The StatusText of the JCoMessage table is the custom log text and not the status name (Processed, Failed, Categorized, etc). This text is user defined and can be added by the Update Status action block. You can see the status text in the Message Monitor by clicking on the status flag icon beside the message.

Thanks,

Dipankar