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 APRIL 01, 2017

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.

Goal

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.

 

Solution

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