In Serena Release Control (RLC), users can view information about task executions from the RLC Deployment Log and associated reports. The RLC Deployment Log is a special auxiliary table created as a "solution view." One of the default pieces of information for any task execution is the QA Result Time. This value is stored and displayed as a string, which unfortunately means it will not be adjusted to the user's local time. These instructions explain how to fix the solution view so that the value is output as date/time.
You must know if you're using Microsoft SQL or Oracle SQL for your databases. There are two provided files; one for each type. Download one of the provided ZIP archives and extract the included XML file. Alternatively, you may make the file edits manually as detailed in step 7.
Download: RLCViews_Microsoft.zip or RLCViews_Oracle.zip
Warning!: This process will involve removing and reimporting the RLC Solution Views. Privileges to the RLC Deployment Log and RLC DU Execution Log will have to be reapplied. Additionally, reports associated with these tables will have to be recreated. Parameters for recreating the 3 default reports - "RLC Deployment Log for Release Packages", "RLC Deployment Units for Environment", and "RLC DU Execution Log for Deployment Path" are included.
For each application engine server:
..\installation directory\SBM\Application Engine\ViewDefinitions\
..\installation directory\SBM\Application Engine\bin>
ttadmin.exe /GenerateViewsAllowDeleteA dialog will appear and then close. You may leave command prompt open.
NULLIF(qaResultTime_property.VALUE,'') TS_QA_RESULT_TIME,with one of the following:
CAST(TO_TIMESTAMP_TZ(NULLIF(qaResultTime_property.VALUE,'NONE'), 'YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') AS TIMESTAMP) TS_QA_RESULT_TIME,