CAST Engineering Dashboard - Information - How to get full object name on transaction view

Purpose

This page gives information and steps to change the short transaction names into their full names.

Applicable in CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
7.2.x(tick)
7.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
CSS1(tick)
Details

In FRAME_PORTAL_TRANSACTION_VIEW, transaction names correspond to the short name of the transaction entry point artifact. In many cases, this is not enough to help the end-user identify which entry-point the dashboard is referring to. Example : when entry point artifacts short name is always the same as a jsp page, which is always named the same but stored in a different directory.

Steps

Run the below query on the Central base to update transaction objects' full name with the full name of the object that starts the transaction:

update dss_objects
set object_full_name = (
select doi.object_full_name
from dss_links dli, dss_objects doi
where dli.previous_object_id = dss_objects.object_id
and dli.next_object_id = doi.object_id
and dli.link_type_id = 11002 )
where dss_objects.object_type_id = 30002


Notes/comments