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 | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x | |
7.2.x | |
7.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 | |
CSS1 |
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