DMW/LSH: How To Enable/Disable/Truncate Debug via PL/SQL, And Find In CDR_EXE_DEBUG The Testcase Log Entries
(Doc ID 2213775.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Life Sciences Data Hub - Version 2.2.1 and later
Oracle Health Sciences Data Management Workbench - Version 2.4.3 and later
Information in this document applies to any platform.
LSH Debug (LSH:ENABLE_DEBUGGING profile) is available after DMW/LSH 2.4.3. It was back ported to 2.2.1 version, too.
This document explains how to Enable/Disable/Truncate Debug via PL/SQL code. Additionally, it shares some tips to query CDR_EXE_DEBUG table and collect correctly the log entries for each testcase. When LSH Debug is enabled, it saves all executions logs in CDR_EXE_DEBUG Table. After several runs, it is hard to figure out which rows are related to which testcase. Here you will find some ideas.
IMPORTANT: In LSW 2.4.3.X, the CDR schema is owner of table CDR_EXE_DEBUG. Then, in this KM Doc, all queries are executed as CDR.CDR_EXE_DEBUG due you login as APPS schema. In earlier LSH versions, like 2.2.1.X, the owner was APPS schema and then, in 2.2.1.X, you run the queries just as CDR_EXE_DEBUG.
Login as APPS and check to whom the table belongs in your instance to see if you should run the queries as CDR_EXE_DEBUG instead of CDR.CDR_EXE_DEBUG.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Steps to consider to enable/disable debug|
|Enable LSH Debug via PL/SQL|
|Find Testcase Logs When Few Rows Are In Debug Table. Optionally, Truncate It|
|How To Disable Debug And, Optionally, Truncate CDR_EXE_DEBUG Table|
|Extra Tips To Find Testcase Logs When Too Many Rows Exist In Debug Table, Or Several Testcases Are Run In The Same Debug Session|