DMW/LSH: How To Enable/Disable/Truncate Debug via PL/SQL, And Find In CDR_EXE_DEBUG The Testcase Log Entries
Last updated on JUNE 27, 2018
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms