IBM Support

Yantra Home page and Alert Console show inconsistent Data

Troubleshooting


Problem

Yantra Home page and Alert Console show inconsistent Data

Symptom

PART: Yantra-Console 7.1 Platform
PRODUCT: Distributed Order Management
WEB BROWSER: Internet Explorer - 6.0 sp1

Problem Description : The Total no. of records being shown on the home page for a queue and the Alert list is different.

Simulation Steps:

(1) Log into Yantra Console
(2) Check the total no. of records shown for the queue on the home page
(3) Click on the queue hyperlink.
(4) The alert list page shows total no. of records as different than the home page.

Notes :

(1) This inconsistency is because the home page shows the no. of records as the the total of OPEN and WIP alerts. Whereas the Alert List shows only OPEN alerts
(2) In 5.5SP2 both the home page and Alert List Page showed total of OPEN and WIP alerts
(3) Customer wants the data to be consistent on both these pages.

Below is the change in the Yantra7x jsp :
String sAddnParams="xml:/Inbox/@ActiveFlag=Y&xml:/Inbox/@Status=OPEN&xml:/Inbox/@Status QryType=EQ&xml:/Inbox/Queue/@QueueId=" + getValue("Queue","xml:/Queue/@QueueId");

In Yantra 5x it was :
String sAddnParams="xml:/Inbox/@ActiveFlag=Y&xml:/Inbox/Queue/@QueueKey=" + getValue("Queue","xml:/Queue/@QueueKey") + "&xml:/Inbox/Queue/@QueueId=" + getValue("Queue","xml:/Queue/@QueueId");

Cause

Resolving The Problem

The inconsistency where the total no. of records shown in the home page were a total of OPEN and WIP alerts, where as the alert list shows only no. of OPEN alerts has been fixed in Danube where it shows both OPEN and WIP alerts.

Solution 1 :
-----------------
In the Alert Search screen if check OPEN and WIP checkboxes and search. The result will give the list of all OPEN and WIP alerts. The no. of alerts shown here will match the total no. of records as shown in the home page

Solution 2 :
-----------------
As a workaround the JSP can be changed from :

Yantra7x jsp :
String sAddnParams="xml:/Inbox/@ActiveFlag=Y&xml:/Inbox/@Status=OPEN&xml:/Inbox/@Status QryType=EQ&xml:/Inbox/Queue/@QueueId=" + getValue("Queue","xml:/Queue/@QueueId");

to

Yantra 5x:
String sAddnParams="xml:/Inbox/@ActiveFlag=Y&xml:/Inbox/Queue/@QueueKey=" + getValue("Queue","xml:/Queue/@QueueKey") + "&xml:/Inbox/Queue/@QueueId=" + getValue("Queue","xml:/Queue/@QueueId");

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI49606

Product Synonym

[<p><b>]Fact[</b><p>];

Document Information

Modified date:
16 June 2018

UID

swg21541291