PI Monitoring based on customized serach criteria

[former_member617132]

Hi ,

Can we customize PI monitoring tool in SAP PI 7.3(dual stack) based on line item data which is present in the payload.

Eg.

SOAP-PI-PROXY(Synchronous).

Sample Payload.

<DocNum>1234</DocNum>

<Item>1234</Item>

<Dummy>1234</Dummy>

. If in some payload we receive DocNum. Can we enable a search criteria in Moni to search for these type of requirement.

[former_member186851 · Accepted solution]

Hello Ayush,

Yes , it is possible.

You can configure user-defined search to search for the particular message based on the message content.In your case it will be Doc num.

Below link contains step by step procedcure to configure the same.

[former_member617132 · Accepted solution]

Hi Raghu

Thanks a lot .

but i am getting alert like.. "No filter found".

Pls help.

[former_member186851 · Accepted solution]

Hello Ayush,

Make sure you configure the filters correct,If you can post the screenshot can you help you out.

And if your searching for messages triggered before configuring the filter ensure your doing indexing(steps mentioned in the link).

[former_member182412 · Accepted solution]

Hi Ayush,

It might be problem with your xpath expression.can you show your xpath expression?

Regards,

Praveen.

[former_member617132 · Accepted solution]

Hi Praveen,

the Xpath is as

/ns0:MT_MaterialRequisitions/row/ClinicCode

[former_member186851 · Accepted solution]

Ayush,

Add one more backslash(/_ and check)

and did you maintain namsepace prefix and also check for the indexing point.

[former_member182412 · Accepted solution]

Hi Ayush,

Try xpath as //ClinicCode

Regards,

Praveen.

[former_member617132 · Accepted solution]

Hi Raghu,

I changed the Xpath as :

/ns0:MT_MaterialRequisitions/row/ClinicCode/_  and

//ClinicCode also.

Also namsepace prefix as : ns0  

I am not getting the point of indexing you mentioned. throw some light pls.

[former_member182412 · Accepted solution]

Hi Ayush,

I tested with your initial payload.

<?xml version="1.0" encoding="UTF-8"?>
<Root>
  <DocNum>1234</DocNum>
<Item>1234</Item>
<Dummy>1234</Dummy>
</Root>

Regards,

Praveen.

[former_member186851 · Accepted solution]

Praveen I guess / is the problem.

[former_member186851 · Accepted solution]

Ayush,

At the beginning you should // ,Refer the blog (Cleary stated).

[former_member617132 · Accepted solution]

Hi Raghu and Praveen,

the screen shots are below.

Filter.

Extractor

NameSpace prefix

Payload.

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_MaterialRequisitions xmlns:ns0="urn://*******/PurchaseRequisition">

<CCodeCount>212</CCodeCount>

- <row>

<UniqueID>8</UniqueID>

<CompanyCode>1000</CompanyCode>

<ClinicCode>MNA</ClinicCode>

<SAP_Material_Code>7000000003</SAP_Material_Code>

<SAP_Material_Description>PATIENT REGI.FORM</SAP_Material_Description>

<SAP_Material_Group>100001</SAP_Material_Group>

<Units>NOS</Units>

<Approved_Required_Quantity>2</Approved_Required_Quantity>

<Delivery_Date>2015-12-17 12:26:42.48</Delivery_Date>

<Supplying_Plant>1901</Supplying_Plant>

<SAP_Item_No>10</SAP_Item_No>

<CMS_PR_Details_No>23569</CMS_PR_Details_No>

<CMS_User_Id>1435</CMS_User_Id>

<CMS_REQ_Date>2015-12-10 12:26:42.48</CMS_REQ_Date>

<CMS_PR_Header_No>2469</CMS_PR_Header_No>

<SAP_Processed>N</SAP_Processed>

<Ent_Date>2016-01-05 13:17:20.077</Ent_Date>

</row>

[former_member186851 · Accepted solution]

Ayush,

Try the below XPATH

//ns0:MT_MaterialRequistions/row/clinicCode(removed /_)

And uncheck the method"Extract with External Job)

[former_member182412 · Accepted solution]

Hi Ayush,

Your xml is incorrect i corrected it and tested.

<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_MaterialRequisitions xmlns:ns0="urn://BATRAS/CMS/PurchaseRequisition">
  <row>
    <UniqueID>8</UniqueID>
    <CompanyCode>1000</CompanyCode>
    <ClinicCode>MNA</ClinicCode>
    <SAP_Material_Code>7000000003</SAP_Material_Code>
    <SAP_Material_Description>PATIENT REGI.FORM</SAP_Material_Description>
    <SAP_Material_Group>100001</SAP_Material_Group>
    <Units>NOS</Units>
    <Approved_Required_Quantity>2</Approved_Required_Quantity>
    <Delivery_Date>2015-12-17 12:26:42.48</Delivery_Date>
    <Supplying_Plant>1901</Supplying_Plant>
    <SAP_Item_No>10</SAP_Item_No>
    <CMS_PR_Details_No>23569</CMS_PR_Details_No>
    <CMS_User_Id>1435</CMS_User_Id>
    <CMS_REQ_Date>2015-12-10 12:26:42.48</CMS_REQ_Date>
    <CMS_PR_Header_No>2469</CMS_PR_Header_No>
    <SAP_Processed>N</SAP_Processed>
    <Ent_Date>2016-01-05 13:17:20.077</Ent_Date>
  </row>
</ns0:MT_MaterialRequisitions>

Regards,

Praveen.

[former_member182412 · Accepted solution]

Hi Ayush,

Your name space is the problem in the xml it is urn://*******/PurchaseRequisition but in the namespace configuration you mentioned urn://BATRAS/CMS/PurchaseRequisition, so you need to change the namespace configuration to urn://*******/PurchaseRequisition then it will work.

Regards,

Praveen.

[former_member617132 · Accepted solution]

Hi Raghu/Praveen

thanks a lot

finally it worked for the first step. but now i am unable to search  in user defined selection criteria.

[former_member186851 · Accepted solution]

Hello Ayush,

Its because of Indexing..After configuring send a message it will work for the new one being sent.

For the old messages to be searched you need to do indexing.

[former_member617132 · Accepted solution]

Hi Raghu

Thanks .

Its working for Asynchronous scenarios.

What should be done for Synchronous one.

[former_member186851 · Accepted solution]

Hello Ayush,

The same way.

Please close the thread.

[former_member617132]

For Synchronous Messages

Go to SM38 and copy the  program SXMS_EXTRACT_MESSAGES , 

<Line 357> , "DELETE gt_msgtab[] WHERE qosmode = 'BE'.   - delete or comment this line.

Execute again this new report and you can see the synchronous messages.